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?
Comments
1 comment
-
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:
I hope this helps. Please let us know if you have any further questions.
Cheers,
Pete Ruiz
Redgate Product Support
Add comment
Please sign in to leave a comment.