当前位置: 动力学知识库 > 问答 > 编程问答 >

TFS 2010/VS 2010: Deployment of database project changes to test environment

问题描述:

We have a system consisting of a winforms client, a bunch of web services, a bunch of reporting services reports and a database with a corresponding database project in VS 2010.

We use TFS as source control system and for automatic builds etc.

When our tester queues a new build from within the Build Explorer, our client and server is build and the server is deployed to the web server. Reports and database changes are not deployed automatically.

Is it possible to have the changes from the database project deployed automatically to the test database whenever a new test build is queued?

网友答案:

Yes.

Your build template can invoke VSDBCMD.exe to do a comparison between your database project (.dbschema) and your test database in order to generate and execute a script that will update your test database.

Here is info about VSDBCMD.

Here is the procedure to setup your build template to use VSDBCMD.

分享给朋友:
您可能感兴趣的文章:
随机阅读: