Smaller Scripts

timharkin · October 22, 2012 12:32PM

Is there a way to limit the number of inserts in a script generated by SQL Data Compare? FOr example, if there are 50,000 inserts requred to sync, coul five scritps be generated that would have 10,000 inserts each?

chriskelly · October 22, 2012 1:47PM

There is an option to break the generated scripts up into transactions and gives you the option to set the batch/transaction size.

Simply navigate to Tools > Application Options and look around half way down under the sub-title "Deployment Scripts".

(I have also emailed you this)

swinghouse · January 9, 2013 11:51AM

Is the "Split transaction/batch operations" option available in the commandline as well? I can't find it at http://www.red-gate.com/supportcenter/C ... L_Switches

/Mattias

swinghouse · January 15, 2013 3:39AM

I've now added a feature request on the UserVoice forum for Data Compare regarding the split option on the commandline: http://redgate.uservoice.com/forums/147879-sql-data-compare-feature-suggestions/suggestions/3551991-make-the-split-transaction-batch-operations-opti

Smaller Scripts

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk