Source Code control and SQL Server express??

Hi,

I was wondering if anybody could advise on source code control for SQL Server express, for the table schema and stored procedures

I currently use Sourcesafe V6 to work with visual studio 6 and 2003 (although it isn't integrated in 2003), and wondered if that can be used

Any suggestions would be greatly appreciated, as I see this as a disaster waiting to happen!

Thanks in advance.

Mark



Answer this question

Source Code control and SQL Server express??

  • Ram#

    There are products like Lumigent's Audit DB that can give you more control over changes to the database.

    http://www.lumigent.com/


  • Natalie Schelm

    I suggest that you store the TSQL commands that you used to create the database objects in script files and use source code control with those files. If you are already using SourceSafe, then you can use it with these script files too.

    Thanks
    Laurentiu



  • B. Schwartz

    Thanks for that - I was hoping it could be a bit more embedded than that, like it is in Visual Studio.

    Thanks again.


  • Source Code control and SQL Server express??