SQL Compare 10.7 cmd ignoring transactionIsolationLevel

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.7 cmd ignoring transactionIsolationLevel

Postby matthoneycutt » Thu May 15, 2014 12:45 pm

I'm getting differing behaviors between the command-line and GUI versions of SQL Compare 10.7. The GUI is respecting the configured transaction isolation level when it deploys scripts. The command line seems to always use "SERIALIZABLE" regardless of the transactionIsolationLevel flag.

Here's the command line I'm executing:

.\\SQLCompare.exe /include="Identical" /include="StaticData" /scripts1="C:\\path\\to\\Scripts" /scriptsfolderxml="C:\\path\\to\\scripts" /migrationsfolder:"C:\\path\\to\\migrations" /server2="(local)" /database2="TestDatabase" /synchronize /AbortOnWarnings="none" /transactionIsolationLevel="READ COMMITTED" /options="default,UseMigrationsV2" /scriptfile="C:\\Users\\me\\Desktop\\migration.sql" /force

In the generated script file, there's this:

'SET TRANSACTION ISOLATION LEVEL SERIALIZABLE'

When I do the equivalent operation using the GUI, the script correctly contains 'SET TRANSACTION ISOLATION LEVEL READ COMMITTED'

Any ideas? This is a major roadblock for my team and our use of SQL Compare/Source Control since our scripts involve linked servers and won't work with SERIALIZABLE.

I'm using SQL Compare Command Line V10.7.0.18...
matthoneycutt
 
Posts: 7
Joined: Mon Apr 07, 2014 4:48 pm

Postby Anu Deshpande » Mon May 19, 2014 3:30 pm

Thanks for your post.

We have logged a support ticket for you and will reply shortly!
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge

Postby Anu Deshpande » Tue May 20, 2014 12:21 pm

Thanks for your patience.

I was able to replicate the issue and hence have logged this in our internal tracking system whose tracking id is SC-7172.

We will keep you updated on the progress of this issue and also about our plans to fix this.
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests