[dba-SQLServer] Version Control Integration

Red-Gate has another tool called SQL Changeset (actually I believe it is an
add-in for SQL Compare) that can be used with VSS or TFS, that might be
another piece of the puzzle.  Plus using SQL Compare to take snapshots
before/after deployments can give way to archive DB schema versions.
 
For your situation TFS might be overkill, but it does integrate so well with
VS 2005, you might just check out the licensing options.

For now, I'd just set up folders for each environment and put all scripts in
these folders with only you have write permissions to the SQL folders (and
encourage the programmers to set up their own folder).  It's primitive but
with only a few people it should work until you decide on a true version
control system.

Sorry I can't be of much more help, but most places I have worked tend to
ignore version control completely, especially when it comes to databases.

Nancy

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Arthur
Fuller
Sent: Saturday, June 28, 2008 5:35 AM
To: Discussion concerning MS SQL Server
Subject: Re: [dba-SQLServer] Version Control Integration

Thanks for the insights, Nancy. My situation is approximately this, give or
take a detail. I have been brought on to take ownership of the database,
which has been previously maintained by one guy who is actually a trader but
he sure knows his way around databases. He's made a mistake or two here and
there, and some decisions which I might question here and there, but given
the 150 tables or so and the attending sprocs, he's done a remarkable job
for a guy whose profession is stock-trading not database design. We have one
.NET guy who is entirely responsible for the web interface. He writes most
everything of consequence in C#. We have the traditional db units in place,
to wit Dev, Staging and Production, but there is no concrete and verifiable
version control. I persuaded them to license the Red Gate Toolbelt so we are
beginning to get on the right track, and can do comparisons between Dev and
Staging and Production, for example, but we still don't have version control
in place, and this worries me. Ideally, I want to get to a single solution
that handles both my changes to the database and the changes to the front
end (the .NET part) and can do all the expected things like Diff the
versions, roll back to yesterday's or last week's version, and so on.

A.

On Fri, Jun 27, 2008 at 5:37 PM, Nancy Lytle <word_diva at hotmail.com> wrote:

> I don't know what your situation is about developers (how many, etc) but
> TFS
> lets DBAs and Developers share so much more than just version control.
You
> can add tasks across from Dev to DBA and have it included in their project
> monitoring, etc.  The only problem can be if you use Linked Servers, then
> setting up the version control can be a bit more of a pain, depending on
> your environment.
>
> Nancy
>
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com


No virus found in this incoming message.
Checked by AVG - http://www.avg.com 
Version: 8.0.131 / Virus Database: 270.4.1/1522 - Release Date: 6/27/2008
8:27 AM

No virus found in this outgoing message.
Checked by AVG - http://www.avg.com 
Version: 8.0.131 / Virus Database: 270.4.2/1523 - Release Date: 6/28/2008
7:00 AM