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.
A data-tier application
C.
Change data capture
D.
SQL Server Integration Services (SSIS)
Explanation:
http://technet.microsoft.com/en-us/library/ee210546.aspx