You have a database hosted on SQL Server 2012 R2. The database contains 5 million rows.
You need to recommend a repeatable method to migrate the database to SQL Azure.
Which method should you recommend? More than one answer choice may achieve the goal.
Select the BEST answer.
A.
Create a SQL Server Integration Services (SSIS) package, and then run the package.
B.
Back up the database, and then restore the database.
C.
Extract a data-tier application, and then import the application.
D.
Generate scripts to create all of the all database objects and all of the data, and then
execute the scripts by using SQL Azure.
Explanation:
SQL Server Integration Services
Most flexibility
Data Transfer Efficiency: Good
/ SSIS can be used to perform a broad range of data migration tasks. SSIS provides support
for complex workflow and data transformation between the source and destination. It is a
good choice to transfer of data for databases that require many changes to work on
Microsoft Azure SQL Database. You can use SSIS data transfer packages with another
mechanism for transferring the database schema, such as a Data-tier Application package.
Incorrect:
Not D: Generate Scripts Wizard
Has explicit option for Azure SQL Database scripts generation
Data Transfer Efficiency: Poor
Good for smaller database
/ Using the Generate Scripts wizard to migrate a SQL Server database to Azure SQL
Database should be limited to:
Teams who have experience with the wizard.
Migrating simple databases that need few schema changes to run on Azure SQL Database.
The scripts generated from the source database can be modified before being used to
create the new version of the database on Azure SQL Database, but using a database
project in the SQL Server Data Tools has richer support for making schema changes.
Migrating small databases that do not have much data. The wizard generates scripts that
use insert statements instead of bulk copies to transfer the data. The insert statements can
be throttled when the tables contain too much data, and are not as fast as bulk copies.
*
On ms pages there is no word about ssis in such case (because there is no ssis in sql azure, and packages must be run locally)
https://azure.microsoft.com/en-us/documentation/articles/sql-database-cloud-migrate/
I think data-tier is correct answer. The scripts are recommended in case of very large databases or poor Internet connection.
0
0
I am also beginning to think that data-tier is right
0
0
Pretty sure dacpac can’t support migrating 5 million rows of data?
0
0
Actually bacpac can. So C should be much simpler than A.
0
0
Nevermind, SSIS is correct (Export Data… option), data tier would be correct if it was EXPORT (schema + data) but it’s EXTRACT (only schema).
0
0
https://msdn.microsoft.com/en-us/library/jj901708.aspx
summary: SQL Server Integration Services (SSIS) can be used effectively as a tool for moving data to and from Windows Azure SQL Database
0
0
SSIS is correct – not datatier because you need to export not extract to get data dacpac vs bacpac
0
0
choise Create A SQL Server Integration Services (SSIS) package, and then run the package is true
0
0
Thanks a bunch! This is definitely an astonishing internet site!|
cs go skins prices http://www.campagnol.be/forum/viewtopic.php?pid=12957#p12957
0
0