Ignore Schema ownership of object for comparison
dhaavisto
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.
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
There is no option to ignore schemas. You could try the schema mapping feature to map the new schema to dbo. See http://www.red-gate.com/supportcenter/C ... c43727.htm or you could individually map each table with its new equivalent using the table mapping feature.
Kind regards,
David Atkinson
Red Gate Software
Product Manager
Redgate Software