?
Solved

Database under source control (TFS)

Posted on 2009-04-15
4
Medium Priority
?
377 Views
Last Modified: 2013-11-26
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?
0
Comment
Question by:jabcoco
  • 2
  • 2
4 Comments
 
LVL 19

Expert Comment

by:daveamour
ID: 24154628
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
 
LVL 19

Expert Comment

by:daveamour
ID: 24154631
Actually thinking about it you may also be able to do it directly from SQL Server Management Studiio with 2005 + - worth looking into
0
 
LVL 10

Author Comment

by:jabcoco
ID: 24158268
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
 
LVL 10

Accepted Solution

by:
jabcoco earned 0 total points
ID: 24264849
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

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Screencast - Getting to Know the Pipeline

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question