versioning a database

[Eben <eb...@bakedbean.net>]

I am working with a SQLServer 2005 database, and it would be really nice 
to be able to version the table schemas, views and stored procedures in 
Subversion. Has anyone done any work with SQLServer and Subversion?  Any 
ideas or advice are appreciated.

thanks,
Eben

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@subversion.tigris.org
For additional commands, e-mail: users-help@subversion.tigris.org

RE: versioning a database

[ta...@dbmaestro.Remove_This.com]

Take a look at a product called Teamwork (website www.dbmaestro.com). It is a change management and source control tool for MS SQLServer and Oracle.

------------------------------------------------------
http://subversion.tigris.org/ds/viewMessage.do?dsForumId=1065&dsMessageId=1108255

To unsubscribe from this discussion, e-mail: [users-unsubscribe@subversion.tigris.org].

RE: versioning a database

[John Niven <jn...@bravurasolutions.com>]

> -----Original Message-----
> From: Eben [mailto:eben@bakedbean.net] 
> Sent: Friday, 28 March 2008 14:15
> To: Subversion Users
> Subject: versioning a database
> 
> I am working with a SQLServer 2005 database, and it would be 
> really nice to be able to version the table schemas, views 
> and stored procedures in Subversion. Has anyone done any work 
> with SQLServer and Subversion?  Any ideas or advice are appreciated.
> 

No experience with SQLServer, but a fair bit with Sybase (using
Subversion and ClearCase).  I suspect Sybase and SQLServer have diverged
a fair bit over the years, but so long as you can run DDL scripts into
SQLServer there's no reason why you can't keep the DDL in Subversion.