SQL Compare 10.2 has been released

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

SQL Compare 10.2 has been released

Postby Michelle Taylor » Wed May 16, 2012 1:56 pm

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

http://downloads.red-gate.com/checkforu ... .0.696.exe

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.
Michelle Taylor
 
Posts: 529
Joined: Mon Oct 30, 2006 12:45 pm
Location: Red Gate Software

Re: SQL Compare 10.2 has been released

Postby clint2627 » Fri May 18, 2012 4:40 pm

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

Image
Clint Rhodes
clint2627
 
Posts: 1
Joined: Fri May 18, 2012 4:22 pm

Foriegn Keys 2000

Postby tboggiano » Fri May 18, 2012 6:51 pm

I am having the same problem as Clint.
tboggiano
 
Posts: 1
Joined: Fri May 18, 2012 6:49 pm

Postby JBoutot » Tue May 22, 2012 7:13 pm

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.

HELP!!!!
Jerry Boutot, MCAD MCP
AppDataWorks, LLC
JBoutot
 
Posts: 1
Joined: Tue May 22, 2012 7:05 pm
Location: FL, USA

Postby Brian Donahue » Wed May 23, 2012 12:14 pm

Please feel free to try the patch you can download from ftp://support.red-gate.com/patches/sql_ ... .0.777.zip . I hope this works for you!
Brian Donahue
 
Posts: 6668
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests