Red Gate forums :: View topic - Strange behaviour after upgrade to
Return to RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare 10
SQL Compare 10 forum

Strange behaviour after upgrade to

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message

Joined: 17 Jul 2007
Posts: 6

PostPosted: Tue May 22, 2012 6:08 am    Post subject: Strange behaviour after upgrade to Reply with quote


yesterday I upgraded to the version Since the upgrade I have some strange behaviour.

Everything of this points happens if I compare a script folder with a database
(SQL Server 2008 x64 SP1):

1. In the script folder there a missing schema defintions in the script folder by tables. Thats all right because the tables are on PRIMARY. Now SQL Compare shows the tables as different but in the Diff Viewer the "ON PRIMARY" is shown in the script folder version, but it is missing in the file. So it is not possible to see what will be changed. I had to deploy against the script folder to see what has changed. If I open the table file of the script folder. I can See that SQL Compare has added the "ON PRIMARY" to the table definition. This is not a problem. But the problem is that the Diff Viewer do not schow the differences.

2. The same with collations. Tables are marked as different but the Diff Viewer in SQL Compare do not show any differences.

Hope this helps to find the error.

Back to top
View user's profile Send private message

Joined: 16 Jun 2010
Posts: 1144
Location: My desk.

PostPosted: Thu May 24, 2012 8:29 pm    Post subject: Reply with quote

Thanks for posting, and sorry you're having trouble.

Often, an invisible difference can be caused by extended properties- if you tick the option to ignore these, do the tables get seen as identical?

If that doesn't help, it may well be to do with the schema difference you mentioned, in which case we will need to replicate the problem here. Could you do a Snapshot of the DB (from the File menu in Compare) and also zip up the scripts, then send those over to Please quote F0060535 in the subject line.
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