Smaller Scripts

timharkin

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

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

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

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