Set transaction isolation level in CLI

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

Set transaction isolation level in CLI

Postby JJB7 » Tue May 07, 2013 5:16 pm

Hi there, in the GUI, there is a setting to change the isolation level from SERIALIZABLE. We have multiple procs in our data warehouses that use linked servers and SQL does not allow the creation of these procs using SERIALIZABLE.

There are two ways to fix this - either by ticking the "do not use transactions in deployment scripts" or by setting another isolation level in the Application Options. The problem with the former, is I don't necessarily want to deploy without transactions in case there are issues during deployment which would result in a corrupt database.

From the CLI, there only appears to be the ability to switch off transactions with the NoTransactions switch documented here. Is there a way to change the transaction isolation level either directly using the CLI or via a project?

Thanks
JJB7
 
Posts: 8
Joined: Fri Jul 20, 2012 11:39 am

Postby JJB7 » Tue May 07, 2013 5:18 pm

Ah, I made the mistake of searching through google and NOT through the forums :oops: found the answer to my question here
JJB7
 
Posts: 8
Joined: Fri Jul 20, 2012 11:39 am


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests