SQL Server Database Versioning RRS feed

  • 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

    Tuesday, November 6, 2012 3:01 PM


  • 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