Compares and synchronizes SQL database content.
Moderators: JonathanWatts, Chris Auckland, David Atkinson, Michelle Taylor, chengvoon.tong
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?
- Posts: 3
- Joined: Mon Oct 22, 2012 5:29 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)
Technical Support Engineer
- Posts: 330
- Joined: Mon Apr 19, 2010 1:44 pm
- Location: Cambridge, UK
- 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