Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SourceConnectionString does not take parameter value Command Timeout=1200 and other timeout values missing. #513

Open
V4A001 opened this issue Oct 19, 2024 · 0 comments
Labels
bug Something isn't working
Milestone

Comments

@V4A001
Copy link

V4A001 commented Oct 19, 2024

  • SqlPackage or DacFx Version:
  • .NET Framework (Windows-only) or .NET Core:
  • Environment (local platform and source/target platforms):

Steps to Reproduce:

  1. using the connection string does not update the timeout in sqlpackage, also the registry value is not usedImage

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.

@V4A001 V4A001 added the bug Something isn't working label Oct 19, 2024
@dzsquared dzsquared added this to the 162.6 milestone Oct 25, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants