Using source control with SQL datamodels?

jessek · Post by **jessek** » Thu Apr 05, 2007 9:28 am

I'm using Visual Studio 2005 with SQL Server 2005. My database has lots of tables and lots of stored procedures. How can I use Vault to manage my datamodel?

I'm looking for any suggestions, anecdotes, tool reviews, ideas -- how do I source-control my datamodel?

Thanks!

Post by **jclausius** » Thu Apr 05, 2007 9:57 am

Try creating a new data project within Visual Studio. From this you can drag your table def'n, stored procs, functions, etc. which creates DDL based files which can then be managed by Vault.

Another option would be to look at a SQL Editing tools from Apex or Red-Gate which which have support for Vault.

jessek · Post by **jessek** » Mon May 07, 2007 1:25 pm

I'm using 2005 Standard Edition; I don't see any options for creating a database project. Do I need a different version of Visual Studio? Which one?

Post by **jclausius** » Mon May 07, 2007 1:33 pm

You'll need Visual Studio 2005 Professional or higher to use the integrated Source Control features of Visual Studio.

See Microsoft's Product Feature Comparisons for additional info.

jessek · Post by **jessek** » Tue May 08, 2007 6:02 am

Thanks... looks like I get to keep paying Microsoft.

SourceGear Support

Using source control with SQL datamodels?

Using source control with SQL datamodels?

Which versions of Visual Studio support this?

That explains it.