News We Recently Launched AD Migrator and AD Reporter | News SysTools Commitment to Child Safety: Upholding the Fight Against CSAM |

SysTools SQL Server to Azure Database Migrator

Migrate SQL Server Database to Azure Database Step by Step

STEP 1

Download & Install SysTools SQl Server Migrator Tool

Start screen

STEP 2

Next, Click on Open Button to Add SQL Server Database

login

STEP 3

Software Provide Two Mode to Browse SQL Server Database: Online & Offline

enter domains

Browse SQL Server Database

STEP 4

Next, Select Online Mode to Process Further

enter domains

STEP 5

Select Live SQL Server with Authentication

login

STEP 6

Next, Select Required SQL Server Database from Drop Down List

login

STEP 7

Click OK to Process Further

login

STEP 8

SQL Server Database Scanning Started, Click on Close to Preview

login

STEP 9

Next, View Loaded SQL Server Database Objects

login

STEP 10

Now, Preview SQL Server Database Table, View, Procedure, Rules in Details

login

STEP 11

Next, Click on Export Button to Start Migration Process

login

STEP 12

Software Provides Three Migration Option. Select the one prefered:

  • SQL Server Database
  • SQL Server Scripts
  • Azure SQL Server

export

STEP 4

Next, Select Offline Mode to Process Further

STEP 5

Click on Browse button to Add MDF File

STEP 6

Select Required MDF File and Click on Open

STEP 7

Next Select Scan Mode: Quick Scan (For Normal File) & Advance Scan (For Corrupted File)

STEP 8

Software Auto Detect SQL Server Version or User Can Choose the SQL Server Version Manually.

STEP 9

Software Provide Option to Recover Deleted Objects when You Selected Advance Scan Mode

STEP 10

Click OK to Load MDF File

STEP 11

MDF File Loaded on the Software, Click on Close to Process Further

STEP 12

Software Prompt to Save Scanned File, Click Yes to Proceed

STEP 13

Save Scanned File in .str Format, Click OK

STEP 14

Next, View Loaded SQL Server MDF File Objects

STEP 15

Now, Preview SQL Server Database Table, View, Procedure, Rules in Details

STEP 16

Click on Export button. Software Provides Three Export Option: SQL Server Database, SQL Server Scripts, & and SQL Azure

STEP 13

Select the Azure SQL Server option. You need to fill the required fields to migrate your SQL data to Azure Database

Pre-Requisites:

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

migrate-options

STEP 14

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

authentication

STEP 15

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

add password

STEP 16

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

connect server

STEP 17

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.

connect db

STEP 18

Select the database objects to migrate in Azure SQL Database.

select objects

STEP 19

For migrating, the software gives you an option to export the server 'With Only Schema' or 'With Schema & Data'.

select schema options

STEP 20

Now, click on the checkboxes of deleted objects and deleted records in case you want to migrate that also.

checkboxes

STEP 21

Hit the Migrate button to begin the migration.

migrate

STEP 22

The software will display the status of migration along with basic informartion and statistics.

migration status

STEP 23

Once completed, the software displays a pop up, Click Ok here.

click ok

STEP 24

Hit Yes,if you want to export the migration details in a CSV files.

csv file

STEP 25

Simply browse the desired location to save the CSV report.

Select location

Open and check the CSV file to get the information.

view CSV file

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

Migrated Tables:

tables

Migrated Views:

views

Migrated Stored Procedures:

Stored Procedures

Get SQL Server Migrator Software Free Download Now