What are the challenges you face when working across database platforms? Take the survey
Options

Compare database objects in different SCHEMAS in same database?

JPSJPS Posts: 2 New member
edited January 12, 2022 8:35PM in SQL Compare
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?
Tagged:

Answers

Sign In or Register to comment.