Database under source control (TFS)

Hi, we currently develop a web application who interact with SQL database.
Our web site is under source control (TFS) and everything is working fine.
The problem is that the "Database" is'nt under source control.

How can we manage tables/stored procedure/functions under source control has we normally does with our web app?

Our database is actually under SQL 2005, but we can move into 2008 if needed.

We know a little about "TFS - Database Edition"...... and trying to figure out if it's what we are looking for..

Any suggestion?
LVL 10
jabcocoAsked:
Who is Participating?
 
jabcocoConnect With a Mentor Author Commented:
We need to manage version release including
- Table creation/modification
- Stored procedure creation/modification
- Function procedure creation/modification
- Data procedure creation/modification

We create our own "Visual Studio Tools" to maintain a update.sql file in our C# project.

Database project did not what we need same with Source control inside with the manager

Thanks for your time "Dave".

0
 
daveamourCommented:
You can create a database project in VS and do all of your db work through VS.
Any changes or creation of anything - tables, stored procedures etc you do through VS then the scripts are all under source control.
0
 
daveamourCommented:
Actually thinking about it you may also be able to do it directly from SQL Server Management Studiio with 2005 + - worth looking into
0
 
jabcocoAuthor Commented:
Hi dave,

Creating a "Database Project" did'nt what we need, because i have no way to "manage" all my stored proc and table who already exist in my database. It just allow me to have ".sql" script thqat can be tested/execuded directly from VS, but i will have to create a script for each of my current stored proc, table... is'nt a option.

I'le check about "Source Control" under Management studio... I'le let you know
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.