Compare database objects in different SCHEMAS in same database?

JPS · January 12, 2022 5:51PM

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 · January 13, 2022 11:15PM

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

Compare database objects in different SCHEMAS in same database?

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk