SourceConnectionString does not take parameter value Command Timeout=1200 and other timeout values missing.
- SqlPackage or DacFx Version:
- .NET Framework (Windows-only) or .NET Core:
- Environment (local platform and source/target platforms):
Steps to Reproduce:
- using the connection string does not update the timeout in sqlpackage, also the registry value is not used
Use: ``` powershell cd C:\temp\d365fo.tools\SqlPackage\
.\SqlPackage.exe /a:export /SourceConnectionString:"Server=(local);Persist Security Info=False;Integrated Security=true;Database=AXDB_CopyForExport;Command Timeout=1200;TrustServerCertificate=True;" /tf:J:/MSSQL_BACKUP/AXDB_CopyForExport.bacpac /p:VerifyFullTextDocumentTypesSupported=false /DiagnosticsFile:J:/MSSQL_BACKUP/AXDB_CopyForExport_DiagnosticsFile.txt
```
This value Command Timeout=1200 is not updated at all. These command works:
.\SqlPackage /Action:Export /ssn:localhost /sdn:"AXDB_CopyForExport" /sec:true /stsc:true /st:3600 /tf:J:/MSSQL_BACKUP/AXDB_CopyForExport.bacpac /df:J:/MSSQL_BACKUP/AXDB_CopyForExport_DiagnosticsFile.txt /p:VerifyExtraction=false /p:VerifyFullTextDocumentTypesSupported=false /p:CommandTimeout=1200 /su:"test1234" /sp:"test1234"
.\SqlPackage.exe /a:export /ssn:localhost /sdn:AXDB_CopyForExport /tf:J:/MSSQL_BACKUP/AXDB_CopyForExport1.bacpac /p:CommandTimeout=1200 /p:VerifyFullTextDocumentTypesSupported=false /SourceTrustServerCertificate:True /df:J:/MSSQL_BACKUP/AXDB_CopyForExport_DiagnosticsFile1.txt
(DacFx/SqlPackage/SSMS/Azure Data Studio)
Overall performance of sqlpackage is poor. Takes too long. Further more it is badly integrated in SQL Management Server . Even in version 20 latest release it is not working from the tools menu.
Other performance values to be added are unclear. Maybe remove the SourceConnectionString if it is not supported.