Red Gate forums :: View topic - Synonyms not identified as different
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Comparison SDK Previous Versions
SQL Comparison SDK Previous Versions forum

Synonyms not identified as different

Search in SQL Comparison SDK Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
flcdrg



Joined: 16 Feb 2009
Posts: 12

PostPosted: Fri Mar 06, 2009 5:59 am    Post subject: Synonyms not identified as different Reply with quote

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
Back to top
View user's profile Send private message
simon.jackson



Joined: 08 Jan 2009
Posts: 45

PostPosted: Fri Mar 06, 2009 10:03 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group