You plan to migrate the database to Azure. You verify that all objects are valid for Azure SQL database. You need to ensure that users and logins are migrated to Azure.
What should you do?
A . Use the Copy Database wizard
B . Use the Database Transfer wizard
C . Use the SQL Management Studio to deploy the database to Azure
D . Back up the database from the local server and restore it to Azure
Answer: C
Explanation:
Use SQL Server Management Studio to establish a connection to your Azure SQL Database server.
Steps:
Create an empty Azure SQL database in the Azure portal (using a new or existing Azure SQL Database server)
Create a server-level firewall in the Azure portal (if not previously created) Use the Data Migration Assistant (DMA) to import your SQL Server database into the empty Azure SQL database
Use SQL Server Management Studio (SSMS) to change database properties.
References: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-migrate-your-sqlserver-database
Leave a Reply