Comments
2 comments
-
Yes, you could use the nt (Transactions) option: https://documentation.red-gate.com/sc13/using-the-command-line/options-used-in-the-command-line#Optionsusedinthecommandline-NoTransactions
Bear in mind that if you use this option failed deployments will not be rolled back, so it's probably a good idea to backup the target beforehand. -
Thank you Sergio. I think that will solve the problem.
Add comment
Please sign in to leave a comment.
We are currently using SQL Compare 13.4 to compare source control (TFS) with a DB.
We are using the command line in order to generate the script that we run on the said DB.
The command works fine. The only problem appears when we have a new InMemory table. The problem is that it adds BEGIN TRANSACTION and therefore it cannot run the script.
These are the switches that we use:
/Options:f,iu,ib,icc,ich,ic,icm,IgnoreDatabaseAndServerName,ie,ifg,ift,iilp,iit,infr,ip,iqen,irpt,ist,ito,iup,iw,iweo,incd,iip,isi,adus /TransactionIsolationLevel:serializable
Is there any way of solving this problem? Any way of removing the begin/commit for InMemory tables automatically?