Getting the full update script

kevgerkevger Posts: 9
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

Comments

  • 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
    David Atkinson
    Product Manager
    Redgate Software
  • 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
  • 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.
  • 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
    David Atkinson
    Product Manager
    Redgate Software
Sign In or Register to comment.