Migration from Azure SQL Database to SQL Managed Instance.

Author: Shruti Srivastava, Associate Data Engineer

 In this blog, We will check how to migrate data from Azure SQL database to Azure SQL Managed Instance.

Pre-requisites:

1. Azure Account
2. SSMS

Steps:

A. Create Azure SQL Database with sample database

1. Click on Create Sql database .
2. Enter subscription name, resource group, Database name, Server name.

 

3. Select pricing tier : Standard with 10 DTUs and 100MB Data max size

4. In additional setting choose data source as sample.

 

5. Select review and create.

 

6. Select create and azure sample database has been created.

 

 

   B. Create SQL Managed Instance:

1. Click on create Azure Sql Managed Instance in Azure Portal .
2. Enter subscription name, resource group, Managed Instance name, Region.

 

3. Configure Compute and Storage.

 

4. Select Backup Storage redundancy as Locally-redundant backup storage.

5. Enter Administrator account details like Managed Instance admin login and password.

 

6. Create a Virtual network and Click on Public end point enable .

 

7. Click on review and create.

8. Click on Create and Azure sql Managed Instance has been created.

 

C. Connect Azure Sql Server and  SQL Managed Instance in SSMS.

Open SSMS and In Object Explorer Connect to Database Engine

 

Both Azure Sql Server and Managed Instance will get connected in SSMS.

 

D. Create a Database in Azure Sql Managed Instance .

1. Right click on the databases and select new database and create.

 

E. Migration Process

1. As you expand databases of Sql server, you well database shrutitestdatabase. Under tables of this database you will the see tables of sample data.

2. Right Click on database named shrutitestdatabase, click on Tasks and select Export Data.

 

3. A Wizard will open up. Click on Next.

4. Select Data Source as SQL server Native Client 11.0 and then write Azure Sql Server name. In Authentication, select SQL SERVER Authentication and write Username and Password. In database select the database name click on Next.

 

5. Select Destination as SQL server Native Client 11.0 and then write Azure Sql Managed Instance server name. In Authentication, select SQL SERVER Authentication and write Username and Password. In database select the database name click on Next.

 

 

6.  Click on Copy data from from one or more tables or views and click Next.

7. Select all Tables and Views of Source Server and Click on Next.

8. Click on Run Immediately and Click Next.

9. Click on Finish.

10. Click on Close.

11. You will get the tables of Sql Server shrutitestdabase in demodatabase of Managed Instance.