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/Content.aspx?c=SQL_Source_Control\help\1.0\SSC_deploying.htm&p=SQL%20Source%20Control

[kevger]

[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