SQL script with UPDATE statement

vivektvivekt Posts: 3
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

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    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.
  • 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:
  • Brian DonahueBrian Donahue Posts: 6,590 New member
    No Problems! I don't think manually mapping columns should cause the program to behave that way, though.
Sign In or Register to comment.