Possible to have a bulk option?

keymoo · January 27, 2011 5:03AM

SQL Data Compare uses INSERT statements to sychronize databases - is it possible to use a bulk option where the data is bulk exported to native files and then bulk loaded into the destination?

peter.peart · January 28, 2011 8:05AM

Hi there,

Thanks for your post.

Unfortunately, this isn't possible at the present time directly within the tool. There isn't however anything to stop you from setting the tool to use transactionsfor the INSERT (if it is a huge script) and then create a synch script rather than perform the synch.

You could then manually alter the script to add in the various commands to take a full backup, change the recovery model of the DB to bulk logged, run the synch script, change the recovery model back to full and then perform a full backup.

HTH!

Pete

keymoo · January 28, 2011 9:00AM

Thanks for the reply. I generated a synch script (took about a day to generate), with the resulting file 157 GB. This file failed to run using sqlcmd at the commandline.

Have a bulk option would be very useful indeed when comparing databases with large data differences.

David Atkinson · January 28, 2011 9:25AM

Just a suggestion: if you're populating new data into a table, you might consider using SSIS, as this might work better.

David

Possible to have a bulk option?

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk