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
sqlcomparewith 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"