Red Gate forums :: View topic - table differences which are not different
Return to www.red-gate.com RSS Feed Available

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

table differences which are not different

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



Joined: 20 Feb 2006
Posts: 49

PostPosted: Thu Oct 25, 2012 2:38 pm    Post subject: table differences which are not different Reply with quote

I used Visual Studio 2012. I imported a new dbproj from my database which was on SQL Server 2012.
I then published the new VS 2012 dbproj to a new database on SQL 2012.

When I run SQL compare to verify the database schema I get 20+ tables out of 300 tables which say they are different, but there is no visible difference when you open the view in SQL compare. I tried ignoring whitespace and several other options but the differences are still there. This occurs on version 10.2.3.1

If I use VS 2010 to publish the database on SQL 2012, these differences do not appear when I run SQL Compare.

I am not sure how to pursue this issue.
Back to top
View user's profile Send private message
stanori



Joined: 23 Apr 2012
Posts: 76

PostPosted: Mon Oct 29, 2012 5:53 pm    Post subject: Reply with quote

Hi rbennet8,

Thanks for your post. We have opened up a support ticket in regards to this, and will be contacting you shortly.

Best Regards,
Steve
_________________
_________________
Steve Tanori
Product Support
Red Gate Software Ltd.
866-997-0378
Back to top
View user's profile Send private message
mEmENT0m0RI



Joined: 09 Nov 2012
Posts: 1

PostPosted: Fri Nov 09, 2012 8:26 pm    Post subject: Re: table differences which are not different Reply with quote

rbennet8 wrote:
I used Visual Studio 2012. I imported a new dbproj from my database which was on SQL Server 2012.
I then published the new VS 2012 dbproj to a new database on SQL 2012.

When I run SQL compare to verify the database schema I get 20+ tables out of 300 tables which say they are different, but there is no visible difference when you open the view in SQL compare. I tried ignoring whitespace and several other options but the differences are still there. This occurs on version 10.2.3.1

If I use VS 2010 to publish the database on SQL 2012, these differences do not appear when I run SQL Compare.

I am not sure how to pursue this issue.



Try toggling the ignore "constraints and index names" option. I had to flip it on and then back off for the differences to show up for some of the constraint names in the compare panel.
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