Setting the transaction isolation level from command line

Forum for users of SQL Compare schema synchronization utility

Setting the transaction isolation level from command line

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

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

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

Postby Brian Donahue » Tue Jan 15, 2013 10: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: 6590
Joined: Mon Aug 23, 2004 9:48 am

Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: Bing [Bot] and 0 guests