Solved

Database under source control (TFS)

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

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

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

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
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.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

726 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