You are designed solution that connects to MSSQL 2008. You plan to deploy the database to development machine and a staging database server from within MSSQL2008. You plan to setup separate build configuration for development and staging. You also plan to deploy multiple production database server managed by an outside vendor. You must not allow the outside vendor to access the Visual Studio project. You need to recommend an approach to configuring and deploying the production management server.
Which two actions should you recommend?
A.
Use VCDBCMD to deploy the database
B.
Use Visual CLR database project
C.
Use SQL Server Management Studio to deploy the production database
D.
Use SQL Server Database project