Skip to content Skip to sidebar Skip to footer

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"