Smaller Scripts

Compares and synchronizes SQL database content.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, Michelle Taylor

Smaller Scripts

Postby timharkin » Mon Oct 22, 2012 5:32 pm

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?
timharkin
 
Posts: 3
Joined: Mon Oct 22, 2012 5:29 pm

Postby chriskelly » Mon Oct 22, 2012 6:47 pm

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)
Chris Kelly
Technical Support Engineer
chriskelly
 
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK

Postby swinghouse » Wed Jan 09, 2013 5:51 pm

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
 
Posts: 99
Joined: Mon Sep 12, 2011 10:51 am

Postby swinghouse » Tue Jan 15, 2013 9:39 am

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
swinghouse
 
Posts: 99
Joined: Mon Sep 12, 2011 10:51 am


Return to SQL Data Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests