Solved

Database under source control (TFS)

Posted on 2009-04-15
4
372 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
In this article I will describe the Backup & Restore 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.
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…

729 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