Migration workflow

Early Access Program for SQL Source Control

Moderators: Chris Auckland, David Atkinson, sherr

Migration workflow

Postby bhopenw » Mon Mar 08, 2010 9:20 pm

Just wondering if there are going to be built in region/environment migration tools or will have to leverage SQL Compare and Data Compare?

Thus far the TFVC integration seems great, but I having trouble seeing how we can leverage this to improve our DB migrations from region to region (DEV, TST, PRE, PRD).

Thanks,

BJHop
bhopenw
 
Posts: 30
Joined: Fri Sep 05, 2008 8:30 pm
Location: Harleysville PA USA

Postby David Atkinson » Mon Mar 08, 2010 10:36 pm

The SQL Source Control add-in's role is to allow you to easily commit and retrieve changed to and from source control. For the deployment/synchronization side you have to use SQL Compare / SQL Data Compare. In a future version these tools will be integrated much tighter together so you won't need to leave SSMS to achieve this. We eventually plan to allow the management of versions from within SSMS, such as tagging/labelling and getting these 'versions' from source control.

David Atkinson
Product Manager
Red Gate Software
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase

Postby bhopenw » Mon Mar 08, 2010 10:58 pm

Okay

Question:
Will SQL Compare be able to view this source as a Scripts Folder? I see a RedGate.scc file where with SQLCompre/SQLChangeSet its RedGateDatabaseInfo.xml.

Meaning, can I call SQL Compare from the cmd line after the source has been downloaded to a local workspace?

thanks,

BJHop
bhopenw
 
Posts: 30
Joined: Fri Sep 05, 2008 8:30 pm
Location: Harleysville PA USA

Postby David Atkinson » Mon Mar 08, 2010 11:06 pm

Yes. The RedGateDatabaseInfo.xml file is also used by SQL Source Control. You will be able to 'get' this from source control to a folder and load this up the source data source in SQL Compare Pro. And yes this works with SQL Compare's command line.

In fact you should be able to prove this to yourself if you've installed the early access build. If it doesn't work, please let us know.

In a later version, we'll let you deploy any source controlled version of a database straight from SSMS. In the interim the workaround is to get it manually from source control to a folder and load it into SQL Compare. It's a couple of additional steps, but it's still pretty simple.

David
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase


Return to SQL Source Control EAP

Who is online

Users browsing this forum: No registered users and 0 guests