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

Ignore Schema ownership of object for comparison

dhaavistodhaavisto Posts: 2
The databases for our application are being consolidated into a single database. In the new form, all objects will be in a single database, but will be owned by different schemas that reflect the original databases.

I would like to be able to compare the legacy databases with the new database, but because the objects were owned by the dbo schema in the legacy databases and the objects in the new database are owned by schemas other than dbo, I'm unable to compare these objects.

Is there an option such as "ignore schema" or another option for the comparison I need?

Thank you.
Dan

Comments

Sign In or Register to comment.