You administer a Microsoft SQL Server 2012 database instance.
You plan to migrate the database to Windows Azure SQL Database. You verify that all objects contained in the database are compatible with Windows Azure SQL
Database.
You need to ensure that database users and required server logins are migrated to Windows Azure SQL Database.
What should you do?
A.
Use the copy database wizard
B.
Use the Database Transfer wizard
C.
Use SQL Server Management Studio to deploy the database to Windows Azure SQL Database
D.
Backup the database from the local server and restore it to Windows Azure SQL Database
A
The Copy Database Wizard moves or copies databases and certain server objects easily from one instance of SQL Server to another instance, with no server downtime. By using this wizard, you can do the following:
– Pick a source and destination server.
– Select database(s) to move or copy.
– Specify the file location for the database(s).
– Copy logins to the destination server.
– Copy additional supporting objects, jobs, user-defined stored procedures, and error messages.
Schedule when to move or copy the database(s).
https://docs.microsoft.com/en-us/sql/relational-databases/databases/use-the-copy-database-wizard
2
1