Red Gate forums :: View topic - SQL Compare 10.2 has been released
Return to RSS Feed Available

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

SQL Compare 10.2 has been released

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

Joined: 30 Oct 2006
Posts: 529
Location: Red Gate Software

PostPosted: Wed May 16, 2012 1:56 pm    Post subject: SQL Compare 10.2 has been released Reply with quote

Announcing SQL Compare 10.2, available through Check for Updates and the download link below:

New Features:

* You can now specify source control repositories and versions on the command line, and migration scripts will work with command line synchronizations / script generation.

* Licensing of the command line can also be done entirely from the command line with no UI elements, so the command line can now be activated on non-interactive servers without having to copy files.

* New option: Ignore system named constraint and index names - this will ignore (at both compare and deploy time) the names of indexes, statistics, foreign keys, primary keys, and unique, default and check constraints where these have been autogenerated by SQL Server rather than user-assigned.

* New SSMS Integration: SQL Compare projects can be found and comparisons launched from inside SSMS, including SQL Server 2012 SSMS; integration will now be set up by the main installer rather than needing seperate installation.

* SQL Snapper is now included in the SQL Compare install by default. SQL Snapper is a standalone utility which can be used to take snapshots of databases on machines that don't have their own SQL Compare license - so you can e.g. troubleshoot problems or prepare deployment scripts for clients or customers with machines you can't access by getting them to send you the snapshot.

Major fixes

SC-5600 - Column mapping warnings added when SQL Compare guesses renamed columns
SC-5710 - Escape characters now work in filters
SC-5608 - Added option to ignore tSQLt tests
SC-5128 - Azure support now also supports tables with a unique constraint as the clustered index (i.e. no primary key)
SC-5721 - Inline constraints now no longer generate an extra alter column statement
SC-5668 - Values of incorrect type in partition functions now detected in scripts
SC-4567 - Data compression now ignored at deploy time as well as compare time
SC-5477 / SC-5658 - Snapshot backwards compatibility for extended properties fixed
SC-5701 / SC-5679 - Ignore tSQLt option now works correctly if there are no tSQLt objects to ignore
SC-5594 - No longer attempts to use migrations when deploying to a script folder
SC-5591 - Object existence checks now work correctly for full text indexes
SC-4670 - UDDTs deployed to live from a scripts folder now have improved dependency ordering
SC-5729 - Views that depend on columns in other views now have improved dependency ordering
SC-5722 - Views that depend on other views via fully qualified names now have improved dependency ordering
SC-5693 - Function dependencies on tables now correctly handled alongside 'use drop and create instead of alter' option
SC-5732 - Functions that depend on table columns now have improved dependency ordering

Minor fixes:

SC-4793 - Made grey text more readable throughout the UI
SC-5444 - Copy and paste of source control repository location now enables Compare Now
SC-5412 - Attempts to browse source control repositories with SOC uninstalled now handled more gracefully
SC-5355 - Migration script error dialog now longer resizes oddly
SC-5682 - Fixed rare UI crash when attempting to delete with no text in server combo box
SC-5007 - Cancelling UAC on update now handled more gracefully
SC-4567 / SC-4522 / SC-4465 / SC-5609 / SC-5453 - Option text clarified for no comment headers, case sensitive object definition, ignoring constraint/index names and identity on columns, quoted identifier settings, and regarding supported server versions for options.

Last edited by Michelle Taylor on Wed Nov 07, 2012 6:37 pm; edited 1 time in total
Back to top
View user's profile Send private message

Joined: 18 May 2012
Posts: 1

PostPosted: Fri May 18, 2012 4:40 pm    Post subject: Re: SQL Compare 10.2 has been released Reply with quote

Hello I upgraded to 10.2 and now I receieve an error. It says Aborting and this happens everytime it gets to Reading forein keys.

SQL Server 2000 databases
Windows 7 64bit

Clint Rhodes
Back to top
View user's profile Send private message

Joined: 18 May 2012
Posts: 1

PostPosted: Fri May 18, 2012 6:51 pm    Post subject: Foriegn Keys 2000 Reply with quote

I am having the same problem as Clint.
Back to top
View user's profile Send private message

Joined: 22 May 2012
Posts: 1
Location: FL, USA

PostPosted: Tue May 22, 2012 7:13 pm    Post subject: Reply with quote

I guess there's a first time for everything. I've been using this program for a couple of years now and this is the first time an upgrad has killed my ability to do my job. I am getting the same error as specified below by clint2627. It is only on some of my databases, though. They are SQL 2000 databases and they are production db's used by a major corporation. I have copies that I work with on a development server. All server instances are upgraded with the latest service packs and patches, etc.

PLEASE figure this out fast and post a patch. I'm working on a deadline and the client is going to have a total meltdown if the work isn't completed on time.

Jerry Boutot, MCAD MCP
AppDataWorks, LLC
Back to top
View user's profile Send private message
Brian Donahue

Joined: 23 Aug 2004
Posts: 6678

PostPosted: Wed May 23, 2012 12:14 pm    Post subject: Reply with quote

Please feel free to try the patch you can download from . I hope this works for you!
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