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 SQL Azure.
What should you recommend? More than one answer choice may achieve the goal. Select the BEST answer.
A. a database snapshot
B. change data capture
C. a data-tier application
D. SQL Server Integration Services (SSIS)
E. SQL Data Sync
