Red Gate forums :: View topic - SQL Compare 10.7 cmd ignoring transactionIsolationLevel
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

SQL Compare 10.7 cmd ignoring transactionIsolationLevel

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



Joined: 07 Apr 2014
Posts: 7

PostPosted: Thu May 15, 2014 12:45 pm    Post subject: SQL Compare 10.7 cmd ignoring transactionIsolationLevel Reply with quote

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...
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 683
Location: Cambridge

PostPosted: Mon May 19, 2014 3:30 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Anu Deshpande



Joined: 20 Apr 2009
Posts: 683
Location: Cambridge

PostPosted: Tue May 20, 2014 12:21 pm    Post subject: Reply with quote

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
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