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

Orderd Data Compare?

Hi,

is there a way to tell the synchronization in which table order it should delete/insert rows? I can‘t synchronize my databases because referential integrity problems.

Thanks,


Alex
alex_sefrin
0

Comments

4 comments

Sort by
  • Matthew Flatt
    Hi alex,

    What exact error messages are you encountering when running the comparison?

    Have you tried the Disable foreign keys, primary keys, indexes and unique constraint options?
    Matthew Flatt
    0
  • alex_sefrin
    Hi Matthew,

    my tables have some delete triggers and they fire if I try to delete them in the wrong order.

    Kind regards,


    Alex
    alex_sefrin
    0
  • David Atkinson
    Alex,

    Have you tried to disable your triggers (in Project Options)?

    David Atkinson
    Red Gate Software
    David Atkinson
    0
  • alex_sefrin
    Thanks, that will solve my problems!
    alex_sefrin
    0

Add comment

Please sign in to leave a comment.