Solved

Database under source control (TFS)

Posted on 2009-04-15
4
370 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

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

Suggested Solutions

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

861 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