Home » Microsoft » 70-518 » Which two actions should you recommend?
You are designing an n-tier solution that connects to a Microsoft SQL Server 2008 database.
You plan to deploy the database to development machines and to a staging database server from within Microsoft Visual Studio 2010. You plan to set up separate build configurations for development and staging. You also plan to deploy to multiple production database servers managed by an outside vendor.
You must not allow the outside vendor to access the visual Studio projects.
You need to recommend an approach for configuring and deploying the production database servers.
Which two actions should you recommend? (Each correct answer presents part of the solution. Choose two.)
A. Use SQL Server 2008 Management Studio to deploy the production databases.
B. Use VSDBCMD to deploy the production databases.
C. Use a Visual C# SQL CLR Database Project.
D. Use a SQL Server 2008 Database Project.
Correct Answer: BD
Explanation/Reference:
Answer: B,D
A:With the file created with VSDBCMD you can install in production the DBs without the necessity of give access to VS to outside vendor.
D: use Sql Server database project to install in development and staging.
References:
You can use the Vsdbcmd.exe tool to copy a database schema from a database in your development environment and then deploy that same database schema to a production server.
Vsdbcmd.exe creates a .dbschema file that describes the structure of a database. Then you can choose to configure the database directly using the .dbschema file or use the. dbschema file to create a script that you can run to build the database. If you create a script, you do not need to have the Vsdbcmd.exe tool installed on the database server.
You also can use Vsdbcmd.exe to synchronize the schema of two databases. For example, consider an environment with separate development and production databases. As developers work on the next version of an application, they might add columns to tables on the development server. When they are ready to update the application in the production environment, they would need to update the schema on the production server to match that of the development server. The developers could use Vsdbcmd.exe to create .dbschema files for both the development and production databases and then generate a deployment script by comparing the two schemas.
Like a DAC, you can deploy a SQL Server Database project directly to the target server, and you can generate an incremental deployment script to update an existing database to match a specified schema. The Add New Project dialog box in Visual Studio displays SQL Server Database project templates in the DatabaseSQL ServerAdvanced folder.