Red Gate forums :: View topic - Getting the full update script
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Source Control 1
SQL Source Control 1 forum

Getting the full update script

Search in SQL Source Control 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
kevger



Joined: 24 Aug 2010
Posts: 6

PostPosted: Mon Aug 30, 2010 2:06 pm    Post subject: Getting the full update script Reply with quote

Hi,

Is there a way to get the full update script that is being automaticly generated when doing a get latest.

When we want to deploy a database on a server not within our network, it would be usefull to just run the script. But I can't find a way to get that script.

/Greetz
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1112

PostPosted: Tue Aug 31, 2010 4:57 pm    Post subject: Reply with quote

Sorry, this isn't a feature of SQL Source Control. You'll need a copy of SQL Compare Pro to generate the script. We're working on integrating this much more tightly with SQL Source Control and SSMS in an upcoming release. If you sign up to the early access distribution list, we'll let you know as soon as it's available to try:

http://www.red-gate.com/SourceControlEarlyAccess

David Atkinson
Product Manager
Red Gate Software
Back to top
View user's profile Send private message Send e-mail
chriskelly



Joined: 19 Apr 2010
Posts: 308
Location: Cambridge, UK

PostPosted: Tue Aug 31, 2010 4:57 pm    Post subject: Reply with quote

The only way at the moment to generate a script to deploy the database contained in SQL Source Control is as follows.

Get the latest version of the database from the repository and then, using SQL Compare, compare it either with a blank database or a copy of the database in question. Next generate the script using the Synchronisation Wizard. You can then save this script and apply it to the server in question.

This document may be of use:
http://www.red-gate.com/supportcenter/Content.aspx?c=SQL_Source_Control\help\1.0\SSC_deploying.htm&p=SQL%20Source%20Control
Back to top
View user's profile Send private message
kevger



Joined: 24 Aug 2010
Posts: 6

PostPosted: Thu Sep 02, 2010 8:49 am    Post subject: Re: Reply with quote

chrisk5 wrote:
The only way at the moment to generate a script to deploy the database contained in SQL Source Control is as follows.

Get the latest version of the database from the repository and then, using SQL Compare, compare it either with a blank database or a copy of the database in question. Next generate the script using the Synchronisation Wizard. You can then save this script and apply it to the server in question.

This document may be of use:
http://www.red-gate.com/supportcenter/Content.aspx?c=SQL_Source_Control\help\1.0\SSC_deploying.htm&p=SQL%20Source%20Control


Idd that's the method currently used. But it would be nice to generate a script with the differences of the local database and the database in sql source control. So we can use these updatescripts in our setups. Acually a nice integration of sql compare.
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1112

PostPosted: Thu Sep 02, 2010 8:55 am    Post subject: Reply with quote

This integration is coming very shortly. If you've signed up to the early access program you'll be able to try this before the full release. Improving the workflow between our tools is a priority for us at the moment.

David Atkinson
Red Gate Software
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group