Red Gate forums :: View topic - Smaller Scripts
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Compare 10
SQL Data Compare 10 forum

Smaller Scripts

Search in SQL Data Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
timharkin



Joined: 22 Oct 2012
Posts: 3

PostPosted: Mon Oct 22, 2012 5:32 pm    Post subject: Smaller Scripts Reply with quote

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?
Back to top
View user's profile Send private message
chriskelly



Joined: 19 Apr 2010
Posts: 309
Location: Cambridge, UK

PostPosted: Mon Oct 22, 2012 6:47 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
swinghouse



Joined: 12 Sep 2011
Posts: 94

PostPosted: Wed Jan 09, 2013 5:51 pm    Post subject: Reply with quote

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/Content/SQL_Data_Compare/help/10.0/SDC_CL_Switches

/Mattias
Back to top
View user's profile Send private message
swinghouse



Joined: 12 Sep 2011
Posts: 94

PostPosted: Tue Jan 15, 2013 9:39 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group