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 patch

Answer 1

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

Answer 2

sorry friend TFS is not available now

Answer 3

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

Answer 4

Thanks as per my research database and server project is best suite.