Red Gate forums :: View topic - New SQL Compare 10.2 update released
Return to www.red-gate.com RSS Feed Available

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

New SQL Compare 10.2 update released

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



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

PostPosted: Mon Aug 06, 2012 4:12 pm    Post subject: New SQL Compare 10.2 update released Reply with quote

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

http://downloads.red-gate.com/checkforupdates/SQLCompare/SQLCompare_10.2.0.1337.exe

This release of SQL Compare primarily improves SQL Server 2012 support, including sequence objects as their own type of database object, file tables, columnstore indexes, search property lists, persisted computed spatial columns, and a wide range of new SQL Server 2012 syntax including:

OFFSET and FETCH, Next Value For, new stored procedure execution options (with result sets, as for xml, as type), parse / try_parse / try_convert, iif, concat, choose, new datetime functions (e.g. eomonth), format, near, window functions (analytic / percentile), new ALTER ROLE, PROPERTY terms in CONTAINS clause, semantic search functions, and new alter fulltext index syntax.

SQL Server 2012 syntax should now highlight correctly and attempting to synchronize 2012-only objects to a server on an earlier version of SQL Server should generate a warning; you can also now tell SQL Compare to open scripts in SQL Server 2012 Management Studio

SQL Server Management Studio integration has been moved to a seperate item in the installer after some people experienced problems with this component. The version of the integration pack supplied with this installer will not work with SQL Server 2012 Management Studio; a new version of the integration pack which has 2012 support should be available soon.

Also included is better handling of Azure tables with clustered index changes, and some improvements to command line licensing; serial numbers can now be activated from the command line inline with another operation, and the new Automation License keys can be used to activate.

There are additionally a wide range of bug fixes and minor improvements:

Parser / scripts folder related:

SC-4699 - repeatedly applying convex hull geometry method no longer confuses the parser
SC-4792 - STATS_STREAM in create statistics statements now no longer confuses the parser
SC-4852 - script folder reader can now handle hashed passwords in CREATE LOGIN statements
SC-5135 - SQL 2008 syntax for fulltext indexes in hand-edited script folders now works
SC-5367 - missing a referencedfulltext stoplist in script folder no longer causes exception to be raised
SC-5546 - FOR clauses after OPTION clauses in stored procedures no longer confuse the parser
SC-5719 - fixed script parsing error with DECLARE statements containing (max) data types
SC-5821 - parser now understands table valued functions as the target of a MERGE statement

Migrations related:

SC-5267 / SC-5904 - migration script temp file store made more robust - should fix occasional file-not-found errors
SC-5315 - sorting by Transition in migration scripts folder now sorts numerically not alphabetically
SC-5474 - changing the deployment direction no longer sometimes leads to incorrect migration script display
SC-5931 - migration scripts covering objects not show in the comparison (e.g. because they only exist at an intermediate stage) now still appear

UI related:

SC-5282 - fixed minor focus issue on startup to projects dialog
SC-5408 / SC-5947- fixed rare crash on closing dialog during list box population
SC-5507 - fixed occasional crash when editing filters
SC-5520 - fixed rare crash on closing deployment wizard when project has closed underneath
SC-5539 / SC-5899 - fixed rare crash on restoring default table mappings
SC-5796 / SC-5828 / SC-5883 - fixed print preview crash from missing DevExpress DLL
SC-5825 - fixed crash in Check for Updates
SC-5933 - fixed rare crash on comparison of identical dbs on slow machines due to a race condition
SC-5973 - fixed rare crash when SQL Compare installed to deeply nested folder

Command Line related:

SC-5581 / SC-5582 - command line now automatically uses filter file in scripts folder if one is present
SC-5595 - options now taken into account when using /makescripts on command line
SC-5726 - AddDatabaseUseStatement and IgnoreSystemNamedConstraints options now work on the command line
SC-5767 - command line can now make a snapshot from a source-controlled script folder source
SC-5949 - command line no longer echoes some text entered into the licensing UI

Dependency related:

SC-4670 - fixed dependency issue between UDDTs when comparing from script folders
SC-5732 / SC-5693 - fixed dependency ordering issue with function/table dependencies and the drop/recreate option
SC-5722 / SC-5729 - fixed dependency ordering issue between views depending on other views

Reporting related:

SC-5589 / SC-4867 / SC-5750 - interactive HTML report should fetch images online if local image folder not present, but use local images if available
SC-5947 - comparison reports can now be viewed with local images on non-Windows OS

Others:

SC-4954 - Ignore data compression option now leaves compression unchanged on deploy even when other changes cause a table to be selected for deployment
SC-5453 - option text updated for SQL Server 2012 / Azure server versions
SC-5593 - SQL Source Control extended properties no longer cause SQL Compare to attempt to use SQL Source Control when SQL Source Control is not installed
SC-5757 - SQL Server 2012 backups no longer all break the backup reader with version-related error message
SC-5801 / SC-5783 - SQL 2000 databases with decimal identity columns can now be compared again
SC-5903 - SQL Compare now handles old versions of SQL Source Control with less crashing


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
seteam



Joined: 01 Nov 2012
Posts: 2

PostPosted: Thu Nov 01, 2012 5:06 pm    Post subject: Invalid Win32 Application Reply with quote

I'm attempting to install SQLCompare_10.2.0.1337.exe in hopes it fixes some issues I'm having using sql compare command line against a 2012 server and am receiving the message:
SQLCompare_10.2.0.1337.exe is not a valid Win32 application.

I'm running 64bit Windows 7.
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1121
Location: Twitter: @dtabase

PostPosted: Thu Nov 01, 2012 7:59 pm    Post subject: Reply with quote

Sounds like there was some file corruption as part of the download process. Could you try downloading again?
Back to top
View user's profile Send private message Send e-mail
seteam



Joined: 01 Nov 2012
Posts: 2

PostPosted: Thu Nov 01, 2012 8:16 pm    Post subject: Reply with quote

I've downloaded it several times same issue Sad
If no one else is having the issue then It's probably something weird with my system.
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1121
Location: Twitter: @dtabase

PostPosted: Thu Nov 01, 2012 8:29 pm    Post subject: Reply with quote

Argh. You're right. I just tried it and got the same. I'll escalate this with our support team.

Apologies.
Back to top
View user's profile Send private message Send e-mail
David Atkinson



Joined: 05 Dec 2005
Posts: 1121
Location: Twitter: @dtabase

PostPosted: Thu Nov 01, 2012 9:33 pm    Post subject: Reply with quote

I've been advised by the SQL Compare project manager that there is a more recent build you can get either via the Check for Updates feature in SQL Compare or this link:

http://downloads.red-gate.com/checkforupdates/SQLCompare/SQLCompare_10.2.3.1.exe

David Atkinson
Red Gate
Back to top
View user's profile Send private message Send e-mail
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