Hi,

Let's say we have 2 databases A and B. Some objects exists in A not in B. After I compare A with B, I got an synchronization script which can create these missing objects in B. In the script it just using the
CREATE ...
statements to create these objects. What I suggest is that could you please add an existence testing statement before these
CREATE
statements? That way, I can run this script in other environments directly even some objects missing in B but not missing here.

Thanks.

You Sui
ogrishman
0

Comments

2 comments

  • David Atkinson
    Making scripts more 'rerunnable' is on our backlog for the next version so there is a chance that it will be available soon, although we can't supply any hard guarantees at this point. Which objects types is it most important to check for?

    David Atkinson
    Product Manager
    Red Gate Software
    David Atkinson
    0
  • David Atkinson
    We have options for rerunnable scripts in the latest Beta.

    would you be able to let us know if this meets your requirements?

    http://www.red-gate.com/MessageBoard/vi ... hp?t=14113

    Kind regards,

    David
    David Atkinson
    0

Add comment

Please sign in to leave a comment.