| Author |
Message |
rbennet8
Joined: 20 Feb 2006
Posts: 49
|
 Posted: Thu Oct 25, 2012 2:38 pm Post subject: table differences which are not different |
 |
|
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 |
|
 |
stanori
Joined: 23 Apr 2012
Posts: 66
|
| Posted: Mon Oct 29, 2012 5:53 pm Post subject: |
|
|
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 |
|
|
mEmENT0m0RI
Joined: 09 Nov 2012
Posts: 1
|
| Posted: Fri Nov 09, 2012 8:26 pm Post subject: Re: table differences which are not different |
|
|
| 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 |
|
|
|
|
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
