Compare database objects in different SCHEMAS in same database?

JPS

Can SQL Compare and SQL Data Compare be used to compare database objects in different SCHEMAs in the same SQL Server database? For example, say there is a database db with 2 schemas schema1 and schema2 and both schemas have a table tbl1.. How can one employ SQL Compare, and SQL Data Compare, to compare/map tbl1 between schema1 and schema2?

Pete_Ruiz

Hello @JPS

You can do this by setting the same server/database as the source and target then mapping the schemas and tables to each other.

Please see the documentation below which outlines how to map schemas and tables:

https://documentation.red-gate.com/sc/setting-up-the-comparison/mapping-tables-and-columns

https://documentation.red-gate.com/sc/setting-up-the-comparison/mapping-owners

I hope this helps. Please let us know if you have any further questions.

Cheers,

Pete Ruiz

Redgate Product Support