Answered by:
SQL Server Database Versioning

Question
-
I am going to use Visual Source Safe for my database (SQL Server) also. Here i have a confusion that which application best for source control, development easiness and deployment.
I have
SQL Server Management Studio,
SQL Server Database Project,
SQL Server Server Project
Which one is best option here. Can anyone help on this?
My Scenario :
Actually all developers work with SSMS and Object Explorer. So after apply soure safe, the difficulties we are facing to locate the stored procedures. There are more than 200 SPs so that if i need checkout a particular SP it is very tedious to find that. So we are looking best option for easy development and good source control.If we use VS we have one tool in Visual Studio 2010 called Solution Navigator. There we can find the sp with each character typed. I don't know this is best one or not. Anyway my main aim is easy development after version controlled also
Second is easy script generation for incremental patchTuesday, November 6, 2012 3:01 PM
Answers
-
Thanks as per my research database and server project is best suite.
- Marked as answer by akhilrajau Friday, November 9, 2012 7:26 AM
Friday, November 9, 2012 7:25 AM
All replies
-
Try to work with TFS in SQL Server : Using Team Foundation Server 2010 Source Control from SQL Server Management Studio
Bob Bao [MSFT]
MSDN Community Support | Feedback to us
Wednesday, November 7, 2012 2:51 AMModerator -
sorry friend TFS is not available nowWednesday, November 7, 2012 4:02 AM
-
You may check the discussion regarding version control stored procedure below and see if it helps you find a good solution.
http://stackoverflow.com/questions/2370011/how-to-add-stored-procedures-to-version-control
Catherine Sea
Version Control Software | TFS Hosting Service- Edited by Catherine Sea Wednesday, November 7, 2012 5:38 AM
Wednesday, November 7, 2012 5:38 AM -
Thanks as per my research database and server project is best suite.
- Marked as answer by akhilrajau Friday, November 9, 2012 7:26 AM
Friday, November 9, 2012 7:25 AM