How can we help you today? How can we help you today?

Transaction in sync sql script

Hi,
I try to sync Two database, And I know that it would be some error, but I nedd to sync what I can. (offen happens when have dependance's problem with create order objects).



I set do not use transaction in synchronization sql Script.

Problem is that SQL compare stop sync on first error. I need script to continue to the end of script.

After that I would need be refresh project and try again until all object would be created.

It would be nice to include 'continue on errors' option.

radovan
rdobrich
0

Comments

1 comment

Sort by
  • JonathanWatts
    radovan,

    We are aware of this feature and a few developers and tester here Red Gate agree with you that this option would be nice.

    However, we have held off implementing this feature this time around as it is possible to execute scripts to end if you use SSMS or Query Analyzer to run the synchronization script rather than SQL Compare.

    Sorry, but I hope this explains our thinking in this matter.

    Regards,

    Jonathan
    JonathanWatts
    0

Add comment

Please sign in to leave a comment.