Red Gate forums :: View topic - Migration workflow
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Source Control EAP
SQL Source Control EAP forum

Migration workflow

Search in SQL Source Control EAP forum
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.
Jump to:  
Author Message
bhopenw



Joined: 05 Sep 2008
Posts: 30
Location: Harleysville PA USA

PostPosted: Mon Mar 08, 2010 9:20 pm    Post subject: Migration workflow Reply with quote

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
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1114
Location: Twitter: @dtabase

PostPosted: Mon Mar 08, 2010 10:36 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
bhopenw



Joined: 05 Sep 2008
Posts: 30
Location: Harleysville PA USA

PostPosted: Mon Mar 08, 2010 10:58 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1114
Location: Twitter: @dtabase

PostPosted: Mon Mar 08, 2010 11:06 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
This topic is locked: you cannot edit posts or make replies. All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group