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

ingoring cross database differences?

willgartwillgart Posts: 8
edited February 13, 2008 9:46PM in SQL Compare Previous Versions
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?

Comments

  • Options
    Thanks for your post.

    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.
    Chris
Sign In or Register to comment.