SQL Server database schema validation, deployment, and upgrade runtime. Enables declarative database development and database portability across SQL Server versions and environments.
SqlPackage or DacFx Version: Microsoft.Build.Sql 0.1.15-preview and SSDT targets from VS 17.9.6
.NET Framework (Windows-only) or .NET Core: both
Environment (local platform and source/target platforms): windows
Steps to Reproduce:
msbuild /t:SqlSchemaCompare /p:Source=path\to\dacpac1 /p:Target=(path\to\dacpac2 or connectionstring) project.sqlproj
there is no compare output
Did this occur in prior versions? If not - which version(s) did it work in?
I dont think this was working correctly ever.
this behaves as follows, no target is executed since /p:Target overrites /t: there is no way to set this parameter, the only way to pass the target is through scmp file passed through /p:SqlScmpFilePath
Source microsoft.build.sql\0.1.15-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets around line 900
I want to use compare this way because I intend to use AdditionalDeploymentContributors, to exclude some objects using their name not type and I dont think I can set this in a GUI version of a compare tool
Steps to Reproduce:
msbuild /t:SqlSchemaCompare /p:Source=path\to\dacpac1 /p:Target=(path\to\dacpac2 or connectionstring) project.sqlprojDid this occur in prior versions? If not - which version(s) did it work in? I dont think this was working correctly ever.
this behaves as follows, no target is executed since /p:Target overrites /t: there is no way to set this parameter, the only way to pass the target is through scmp file passed through /p:SqlScmpFilePath
Source
microsoft.build.sql\0.1.15-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targetsaround line 900I want to use compare this way because I intend to use AdditionalDeploymentContributors, to exclude some objects using their name not type and I dont think I can set this in a GUI version of a compare tool