table differences which are not different

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

table differences which are not different

Postby rbennet8 » Thu Oct 25, 2012 2:38 pm

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.
rbennet8
 
Posts: 49
Joined: Mon Feb 20, 2006 10:00 pm

Postby stanori » Mon Oct 29, 2012 5:53 pm

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
stanori
 
Posts: 84
Joined: Mon Apr 23, 2012 1:13 pm

Re: table differences which are not different

Postby mEmENT0m0RI » Fri Nov 09, 2012 8:26 pm

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.
mEmENT0m0RI
 
Posts: 1
Joined: Fri Nov 09, 2012 8:07 pm


Return to SQL Compare 10

Who is online

Users browsing this forum: Bing [Bot] and 0 guests