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

SQL script with UPDATE statement

Hi
Is it possible to generate SQL script(from the synchronization wizard) with UPDATE statements instead of the DELETE & INSERT combination?

The problem, I face is that my database has too many foreign keys in tables not being sychronized and hence they must be manually dropped and then added which, apart from inconvenience, may lead to inconsistency. Thanks
vivekt
0

Comments

3 comments

Sort by
  • Brian Donahue
    Hello,

    I'm afraid I'm not sure what you mean. If the data in a row is different (a matching row is defined by having the same comparison key value in both databases), then an update is scripted. The update procedure is not to drop a row and insert the data back in.
    Brian Donahue
    0
  • vivekt
    no im sorry..it was my first time with red gate and i configured the keys to use the columns I wanted to compare but someone advised me to stick with the default comparision columns(PKs) and it worked just fine...noob apology :oops:
    vivekt
    0
  • Brian Donahue
    No Problems! I don't think manually mapping columns should cause the program to behave that way, though.
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.