Options

SQL script with UPDATE statement

vivektvivekt Posts: 3
edited January 20, 2007 4:06PM in SQL Data Compare Previous Versions
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
· Share on Twitter

Comments

  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    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.
    · Share on Twitter
  • Options
    vivektvivekt Posts: 3
    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:
    · Share on Twitter
  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    No Problems! I don't think manually mapping columns should cause the program to behave that way, though.
    · Share on Twitter
Sign In or Register to comment.