Options
ingoring cross database differences?
willgart
Posts: 8
Hi,
how I can ignore differences related to a cross database query?
my source query is:
select ... from DB1.dbo.Table1 inner join dbo.Table2
and the destination is:
select ... from OTHERDB1.dbo.Table1 inner join dbo.Table2
so it's flagged has different but it's not!
in both cases the databases exists, so the query is the same in the logic but with 1 small difference: the database name!
what can I do?
how I can ignore differences related to a cross database query?
my source query is:
select ... from DB1.dbo.Table1 inner join dbo.Table2
and the destination is:
select ... from OTHERDB1.dbo.Table1 inner join dbo.Table2
so it's flagged has different but it's not!
in both cases the databases exists, so the query is the same in the logic but with 1 small difference: the database name!
what can I do?
Comments
Unfortunately with the current release it is not possible to treat these queries as identical. SQL Compare is not setup to ignore the database names when comparing cross database queries.
I agree that this would be a useful addition to SQL Compare, so I have logged a feature request with the developers. For your reference the code it was logged under was: SC-3585.
I will let you know the status after it has been reviewed.