SQL Compare InMemory tables compare

BogdanS

Hello,

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?

Sergio R

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.

BogdanS

Thank you Sergio. I think that will solve the problem.