Visual Studio Sql Server Data Tools Comparison Mappings
Does Visual Studio SQL Server Data Tools (any version) support changing the default comparison mappings, for objects with different names, and/or in different schemas? For example,
Solution 1:
As far as I know, no, you cannot do the comparison using SSDT
if they are in different schema
. The database
doesn't matter though, you could specify the connection
and database
when running schema compare
, but not the schema
.
One workaround to get it working in less than ideal way would be to:
- deploy your SchemaA.MyTable locally
- after the schema has been deployed successfully, replace the table definition of SchemaA.MyTable with that of SchemaB.MyTable
- Run
sqlcompare
with your project as the source and the local db (where you deployed your project in step 1) as the target.
Post a Comment for "Visual Studio Sql Server Data Tools Comparison Mappings"