feature suggestion

Forum for users of SQL Compare schema synchronization utility

Moderators: JonathanWatts, Chris Auckland, David Atkinson

feature suggestion

Postby ogrishman » Wed Dec 29, 2010 4:04 am

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
Code: Select all
CREATE ...
statements to create these objects. What I suggest is that could you please add an existence testing statement before these
Code: Select all
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
 
Posts: 29
Joined: Mon Apr 12, 2010 8:21 pm

Postby David Atkinson » Wed Dec 29, 2010 9:56 am

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
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase

Postby David Atkinson » Fri Oct 28, 2011 12:01 pm

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
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase


Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests