Trying to understand SSC setup for first time use

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

Trying to understand SSC setup for first time use

Postby dbdmora » Mon Nov 21, 2011 10:04 pm

I want to make sure I get this straight as I am evaluating the product. We currently have SVN installed, we should link a Database from our development environment instead of production environment, is this correct?

This means we have to do a full restore from our production DB into our Development DB before we can link and commit the changes to SVN.

Do we ever link a Production DB to SVN in order to get the latest changes and then deploy to production?

This is the part I am confused about, i thought you link production DB to SSC\\svn in order for developers to always get the latest.

If someone can explain the best practice setup, that will help me ensure I am evaluating this product better. Thanks.
dbdmora
 
Posts: 34
Joined: Mon Nov 21, 2011 9:55 pm
Location: Atlanta, GA

Postby Chris Auckland » Thu Nov 24, 2011 9:45 am

Thanks for your post.

SQL Source control isn't really designed to be used to deploy a structure to different environments, it's purely to help a team of developers work together and record their changes directly through SSMS.

If you need to move the structure somewhere else, e.g. production to development, then we would recommend that you use SQL Compare.

In your situation:

1) Use SQL Compare to deploy the schema from your current production database to your development environment.
2) Link the development database to SVN using SQL Source control
3) Work on the development database until you're ready to deploy the changes to production
4) Use SQL Compare to deploy the version in SVN to production (or any other environment).

SQL Compare and SQL Source Control work very well together for this kind of process. There is a bit of information on how SQL Compare is integrated in SSMS for this task here.

I hope this helps.
Chris
Chris Auckland
 
Posts: 757
Joined: Tue Oct 24, 2006 2:12 pm
Location: Red Gate Software Ltd.

Postby dbdmora » Mon Nov 28, 2011 3:19 pm

Thanks for the respond, this helps.
dbdmora
 
Posts: 34
Joined: Mon Nov 21, 2011 9:55 pm
Location: Atlanta, GA


Return to SQL Source Control 2

Who is online

Users browsing this forum: No registered users and 0 guests