How can we help you today? How can we help you today?

ingoring cross database differences?

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?
willgart
0

Comments

1 comment

Sort by
  • Chris Auckland
    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 Auckland
    0

Add comment

Please sign in to leave a comment.