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