Setting the transaction isolation level from command line

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

Setting the transaction isolation level from command line

Postby rmichela » Fri Jan 11, 2013 9:44 pm

SQL Compare 10 has a new feature for setting the transaction isolation level within the application's GUI.

http://www.red-gate.com/supportcenter/C ... v10#o14908

How do I set this option from the command line when running SQL Compare from a deploy script?
rmichela
 
Posts: 1
Joined: Fri Jan 11, 2013 9:39 pm

Postby Brian Donahue » Tue Jan 15, 2013 11:59 am

You can get all the command-line help by running the command-line with the verbose and question-mark arguments: there is a lot more there than what you find on the help pages of the website.
Code: Select all
sqlcompare /? /v | more

To specify a transaction isolation level, use transactionIsolationLevel, or til
Code: Select all
sqlcompare /til:SERIALIZABLE
sqlcompare /til:"READ COMMITTED"
...

Hope this helps.
Brian Donahue
 
Posts: 6670
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