Know How to Migrate SQL Server Database to Azure SQL Database

STEP 1

Go to Start Menu » Programs » SysTools® SQL Server to Azure Database Migrator Tool. The following screen will appear after that:

STEP 2

From the software menu, click on “Open” to browse the desired MDF file for migration.

STEP 3

Now, select the .mdf file for migration and click on “Open”.

STEP 4

Select the scan mode.
Check the Auto detect option, if you don't know the SQL MDF File version. The user can also select the recover deleted objects option if the user wants to recover deleted database objects.

STEP 5

You can also select the SQL Server Version of your MDF File manually.

Note: Selecting the wrong version may result in inconsistency.

STEP 6

Select NDF Options which is the second tab. Select the first radio button if you want to detect NDF file automatically.

Important Note: The NDF file must be associated with the Primary database, i.e., the selected MDF file.

STEP 7

Choose the second radio button to add NDF files manually, Then Click on Add Files / Add Folder option to add the NDF files for migration.

STEP 8

After selecting the NDF file. Click Ok

STEP 9

The software will show a summarized detail of the selected MDF files and an automatic scanning of the MDF files will take place. Click Close

STEP 10

You can also save the scanned MDF file in .str file. If you want to save .str file, then click on "Yes" button given on the prompt screen, otherwise click No.

STEP 11

Select the location for saving .str file and click on Save:

STEP 12

Preview database of MDF and NDF files: Software will show the entire data of MDF and NDF files such as Tables, Triggers, Stored procedures, Views, etc. Also this software shows the deleted SQL table records and database objects in red color.

The user can preview deleted Stored Procedure before migration.

The user can preview deleted Triggers before migration.

The user can preview deleted Views before migration.

STEP 13

There will be a preview of all database objects before Migration. Click on Migrate to begin migration process of SQL Database to Azure Database.

STEP 14

After clicking on Migrate, you will get 'Migration Options' panel. You need to fill the required fields to migrate your SQL data to Azure Database

Pre-Requisies:

1. Client Internet IP (Your IP) should be added in Firewall settings of Azure SQL Server.

2. Destination database should be created and source database collation. We support collation that are added with 2017 SQL Server. If collation is not found then create database and set collation as per source database or as per requirement.

Note: Here is how to find authentication details to Connect with Azure SQL Database

STEP 15

Fill the Server Name of Azure SQL Server Database. The Authentication mode is taken by default as SQL Server Authentication.

STEP 16

After this, Fill login credentials for SQL Server. Fill Username and Password of Azure SQL Server Database.

STEP 17

Click on Connect to test whether Azure SQL Server Database is connected successfully. The green tick indicates the Server connection is established successfully.

STEP 18

Click on Drop Down button and the software will show the list of all the existing databases. Select the database on which you want to migrate.

STEP 19

In Step 3, you have preferences column in which you can select the database objects to migrate in Azure SQL Database.

STEP 20

For Exporting, the software gives you an option to export the migrated data 'With Only Schema' or 'With Schema & Data'.

Export With Schema & Data
Export With Only Schema

STEP 21

Export With Schema & Data

If you want to save the schema & data of the selected database then select With Schema & Data option. After choosing this Export Schema and Data option. This will enable two options migrate deleted objects and migrate deleted records option. The user can check this options in case if the user wants to migrate deleted SQL database and deleted records to Azure Database.

With schema & data

'Migration Completed' pop up will appear stating migration is successfully completed. Click 'Ok' to proceed.

Windows Authentication

Software will display the scanning report of migrating data as 'With Schema & Data'

export with schema confirmation

After clicking on 'Close' software gives you option to save your migrated data in .csv format. If you want to save data in .csv format Click Yes

Save csv report

Choose the desired location to save your migrated data in CSV

Save csv in desired location

You can check the csv report by opening it.

CSV Report generated

The database objects has been migrated successfully. You can view them in below images:

Migrated Tables:

Migrate Tables

Migrated Views:

Migrate views in Azure

Migrated Stored Procedure:

Migrate stored procedure in Azure

STEP 21

Export With Only Schema

If you migrate the database components (Tables/Views/Stored Procedures etc.) with only schema, then the software will only migrate the schema/structure of database components. After enabling 'With Only Schema' option. This software provides the option to migrate deleted objects. The user can also check this checkbox to migrate the deleted SQL database objects to Azure database.

'Migration Completed' pop up will appear stating migration is successfully completed. Click 'Ok' to proceed.

Migrate-with-schema

Software will display the scanning report of migrated data as 'With Only Schema' option.

With Only Schema

After clicking on 'Close' software gives you option to save your migrated data in .csv format. If you want to save data in .csv format Click Yes

Save as csv format

Choose the desired location to save the report of migrated data in CSV.

csv in desired location

You can check the csv report by opening it.

CSV Report

The database objects has been migrated successfully.

Database Schema:

Migrated data in Azure

SysTools SQL Server to Azure Database Migrator

Export With Schema & Data

Export With Only Schema