Options

Synonyms not identified as different

flcdrgflcdrg Posts: 17
edited March 6, 2009 4:03AM in SQL Comparison SDK Previous Versions
Comparing two databases that contain synonyms similar to the following

schema 1:

CREATE SYNONYM [synSample].[InsertSummary] FOR [dbOne].[dbo].[InsertSummary]

schema 2:
CREATE SYNONYM [synSample].[InsertSummary] FOR [dbTwo].[dbo].[InsertSummary]

Why aren't these highlighted as a difference?

We're using the SDK to update a database and this change wasn't noticed by the SDK. We've confirmed that SQL Compare 8 also doesn't show this as a change in the UI.

-dave
· Share on Twitter

Comments

  • Options
    simon.jacksonsimon.jackson Posts: 45
    There is an option which is set by default ( IgnoreDatabaseName ). If you remove this from your compare options the difference should be detected. The equivalent option in Compare 8 is "Database and server name in synonyms" in the Ignore section

    The decision to make this option default was taken because old versions of compare used not to detect these differences.

    Hope that helps
    · Share on Twitter
Sign In or Register to comment.