You have two SQL Server instances named SQLDev and SQLProd that have access to various storage media. You plan to synchronize SQLDev and SQLProd. You need to recommend a solution that meets the following requirements: ✑ The database schemas must be synchronized from SQLDev to SQLProd. ✑ The database on SQLDev must be deployed to SQLProd by using a package. ✑ The package must support being deployed to Windows Azure SQL Database. What should you recommend? More than one answer choice may achieve the goal. Select the BEST answer.

A. A database snapshot
B. SQL Server Integration Services (SSIS)
C. Change data capture
D. A data-tier application

  Discussion forum


Leave an answer