What should you recommend?

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.

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

Explanation:
* SIS supports connections to SQL Database by using the ADO.NET provider. OLEDB is not supported at thistime. You can build the SSIS package connecting to SQL Database and create the data flow tasks the same
way as you would against a typical on-premise SQL Server.
SSIS for Azure and Hybrid Data Movement



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Razor

Razor

D. A data-tier application
You would choose SSIS to transfer the data but the requirements are just about metadata. These are saved in .dacpacs