This guy has a VBScript that automates the scripting and versioning of
databases with VSS. It could probably be easily adapted.
http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1093178,00.html?bucket=ETA
Personally, I'd rather only script a known "good" version and rely on
database backups for catastrophes involving the database. This is
because SQL Scripts, unlike code can't be on the server unless they
actually compile.
On 7/21/05, Albie Janse van Rensburg <albie.jvr@gmail.com> wrote:
> Thanks for the help. Is this the only way? I would obviously prefer a
> more integrated approach, but we'll have to make do. Does anybody know
> anything about the source control support in SQL server?
>
> Dan Shookowsky wrote:
>
> >Before you create a tag indicating a stable version that you'd like to
> >get back to, script the database into one or more .SQL files and
> >commit these to the repository. You end up with all the info that you
> >need. If you have specific meta-data that must be in the database,
> >you'll probably need to script this in some other way.
> >
> >On 21 Jul 2005 11:46:50 -0000, users-digest-help@subversion.tigris.org
> ><users-digest-help@subversion.tigris.org> wrote:
> >
> >
> >>From: Albie Janse van Rensburg <albie.jvr@gmail.com>
> >>To: users@subversion.tigris.org
> >>Date: Thu, 21 Jul 2005 11:51:11 +0200
> >>Subject: Source Control for Database Aspect
> >>Hi all
> >>
> >>I am implementing Subversion for a .Net project at work, and it's great
> >>to be able to use plug-ins like AnkhSVN to get Subversion integrated
> >>with Visual Studio. However, like most software project above the
> >>"Hello World" level, there is a database aspect to our development. We
> >>are using Microsoft SQL Server 2000, and a large part of the project's
> >>business logic lies in stored procedures and metadata that populate
> >>elements in the project. It is necessary to bring the database aspect
> >>into version control, as older versions of the .Net source are often
> >>incompatible with different versions of the database.
> >>
> >>Is there any way to accomplish this level of source control using
> >>Subversion? I am also very interested to know whether there are any
> >>Subversion plugins available that would work with SQL Server - it has
> >>some method by which Visual Source Safe (ew...) can integrate, so it
> >>seems natural to assume that third party developers should be able to do
> >>something similar.
> >>
> >>Any hints, suggestions or flames (I did mention VSS. Argh! Again!) are
> >>welcome.
> >>
> >>Albie
> >>
> >>
> >>
> >
> >
> >
> >
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@subversion.tigris.org
For additional commands, e-mail: users-help@subversion.tigris.org
Received on Thu Jul 21 16:42:54 2005