开发者

In TFS Is there a way to track changes of scripts I make in sql 2008r2?

开发者 https://www.devze.com 2023-02-28 21:21 出处：网络

Is there a way for TFS to perform a profile of SQL 2008 and update all new scripts in T开发者_运维百科FS automatically?Also what is the recommended way to keep track of changes that are made to querie

相关专题：sql-server-2005 sql-server-2008-r2

Is there a way for TFS to perform a profile of SQL 2008 and update all new scripts in T开发者_运维百科FS automatically? Also what is the recommended way to keep track of changes that are made to queries in sql 2008?

In Visual Studio Team Developer you could use a SQL Server project to have your tables, views, stored procedures etc. under source control with TFS.

Aside from this a common way to keep your database scripts under source control is to manually generate CREATE/UPDATE SQL scripts via SQL Server and check them into your source control structure whenever database objects have changed.

This solution of course requires disciplined developers to have always an exact duplicate of your SQL Server objects in your source control.

Hope this helps!