Ignore schema/owner difference on tables
GSS
Posts: 10 Bronze 1
in SQL Compare
I can map two tables between different servers on different schemas. I can map together two schemas and different owners.
However, the comparison generated still considers the difference in schema as a difference, shows it as a difference and scripts to things to change schemas. How can I get the comparison to ignore this difference?
For example. I have a table [dbo].[TableOne] in one database, and [Test].[TableOne] in another. I want them to be identical with the exception of their schema. I map the tables together, and map owners dbo and Test together prior to the comparison. But the comparison still considers the difference in schema to be a difference, even when all else about the tables are identical.
Is there an option to tell the comparison to ignore this? Thanks.
However, the comparison generated still considers the difference in schema as a difference, shows it as a difference and scripts to things to change schemas. How can I get the comparison to ignore this difference?
For example. I have a table [dbo].[TableOne] in one database, and [Test].[TableOne] in another. I want them to be identical with the exception of their schema. I map the tables together, and map owners dbo and Test together prior to the comparison. But the comparison still considers the difference in schema to be a difference, even when all else about the tables are identical.
Is there an option to tell the comparison to ignore this? Thanks.
