Possible to have a bulk option?

keymookeymoo Posts: 38
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?

Comments

  • 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
    Peter Peart
    Red Gate Software Ltd
    +44 (0)870 160 0037 ext. 8569
    1 866 RED GATE ext. 8569
  • 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.
  • Just a suggestion: if you're populating new data into a table, you might consider using SSIS, as this might work better.

    David
    David Atkinson
    Product Manager
    Redgate Software
Sign In or Register to comment.