Hi,

We are working with Visual Studio. I am familar with source safe for version control of source code and application code. However, we are working as well with a database (SQL2000). We have a local / development database and a production database.

Whenever we finish new feature development the schema from the local database needs to be updated to the production (table fields, stored procedures, views, triggers, etc..) without corrupting the actual data. Is there a good way to do this? As well, what are the options available for version control of database. Can anyone point us in the right direction.

Dwight