Getting the full update script

A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.

Moderators: Chris Auckland, David Atkinson, sherr, PhilScrace

Getting the full update script

Postby kevger » Mon Aug 30, 2010 2:06 pm

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
kevger
 
Posts: 6
Joined: Tue Aug 24, 2010 12:29 pm

Postby David Atkinson » Tue Aug 31, 2010 4:57 pm

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

Postby chriskelly » Tue Aug 31, 2010 4:57 pm

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
chriskelly
 
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK

Re:

Postby kevger » Thu Sep 02, 2010 8:49 am

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.
kevger
 
Posts: 6
Joined: Tue Aug 24, 2010 12:29 pm

Postby David Atkinson » Thu Sep 02, 2010 8:55 am

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


Return to SQL Source Control 1

Who is online

Users browsing this forum: No registered users and 0 guests