От: | Sinix | ||
Дата: | 27.04.10 05:18 | ||
Оценка: |
Since most SQL Server deployments do not have Visual Studio installed, or you simply do not have access from your Visual Studio environment to the database that needs to get updated, there is a fully standalone command-line-based deployment engine that allows you to deploy the results of a build. This command-line engine is XCOPY deployable, so you can copy it onto a memory stick or server share and deploy your database from there.
1: "%programfiles%\microsoft visual studio 9.0\vstsdb\deploy\vsdbcmd.exe"
2: /a:Deploy
3: /manifest:MyDatabase.deploymanifest
4: /p:DeploymentConfigurationFile=MyDatabase.sqldeployment
5: /p:SqlCommandVariablesFile=MyDatabase.sqlcmdvars
6: /cs:"Data Source=MyServer\sql2008;Integrated Security=true"