Multiple versions of SQL Server Database

We are giving programming work to outside consultants. There are 3 instances of the same web application. One for the manager, one for the developer and one for the designer. Therefore, we will need to maintain 3 versions of the application and the database. We are using TFS to manage the application versions. What would be the best way to manage different versions of the database?

Thank you for your help.
Nick

TFS can handle this fine. It works really well with SQL Server. But I would question having 3 different instances/versions. To me, the app should handle the 3 cases via application permissions that way all 3 can use the same app and database.

Tara,

Thank you for your reply.

The outside developer can make changes to the database. So I need a different version of the database.

1 Like