Add version control to existing SQL Server database

Posted by ederbf on Stack Overflow See other posts from Stack Overflow or by ederbf
Published on 2012-11-07T16:58:41Z Indexed on 2012/11/07 16:59 UTC
Read the original article Hit count: 255

I am part of a development team currently working with a database that does not have any kind of source control. We work with SQL Server 2008 R2 and have always managed the DB directly with SSMS. It now has ~340 tables and ~1600 stored procedures, plus a few triggers and views, so it is not a small DB.

My goal is to have the DB under version control, so I have been reading articles, like Scott Allen's series (http://bitly.com/9cJmGR) and many old SO related questions. But I am still unable to decide on how to proceed.

What I'm thinking of is to script the database schema in one file, then procedures, triggers and views in one file each. Then keep everything versioned under Mercurial. But of course, every member of the team can access SSMS and directly change the schema and procedures, with the possibility that any of us can forget to replicate those changes in the versioned files.

What better options are there? And, did I forget any element worth having source control of?

© Stack Overflow or respective owner

Related posts about sql

Related posts about sql-server