Activity overview
Latest activity by mEmENT0m0RI
Procs do not get included in the Synch up SQL
Procs do not get included in the Synch up SQL if only comments in them are different. They show up on the compare GUI page, but do not get included in the synchronization SQL script and therefore c...
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. / comments
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 ru...