DATA MIGRATION FROM LOCAL TO AZURE

Azure SQL Database is a recommended target option for SQL Server workloads that require a fully managed platform as a service (PaaS). SQL Database handles most database management functions. It also has built-in high availability, intelligent query processing, scalability, and performance capabilities to suit many application types.

SQL Database provides flexibility with multiple deployment models and service tiers that cater to different types of applications or workloads.

Let's setup the connection between the Local SQL to the AZURE SQL :

Block Diagram of the connectivity we will be making shown below.

• We need to have SUBSCRIPTION in my case I'm using STUDENT SUBSCRIPTION.

• Creating a Resource Group.

• : Now Go to AZURE SQL and create the database.

• While creating the database, create a server and provide Username and password in it.

• Find the IP address of the system from where we will migrate the data .

• Now we'll create a firewall and add rule and IP address to it and save it.

• After the rule is added then copy the server name.

• Now open Microsoft SQL Server Management Studio and click on connect. Then paste the server name and add username and password to it and click on connect.

• Then we will able to see this in the left bottom .

• Now select the Database we need to copy to Azure Database, and export the data.

• Now do as per the instructions in the dialog box and click on Next button.

• Now the local database is copied to AZURE Database.

By doing this we successfully migrated the local SQL Database to AZURE SQL Database.

Stay tuned for my upcoming blogs.

Thank You !