Getting the full update script

kevger

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

David Atkinson

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

chriskelly

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/C ... ce_Control\help\1.0\SSC_deploying.htm&p=SQL%20Source%20Control

kevger

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/C ... ce_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.

David Atkinson

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