Quick Tip for Data Migration from SQL Server to Azure SQL

Isha Ratra | July 5th, 2019 | Data Migration, Tips

We are running short of time & we want to migrate a large amount of data from SQL Server to Azure SQL database. Although, we have tried the Export data tier solution to transfer data from SQL Server to SQL Azure. But, the migration process takes a large amount of time. However, we can’t wait for that much time so can anyone suggest me the quick & best strategy for the data migration from SQL Server to Azure SQL Server. All suggestions are welcome?

SysTools SQL to Azure Migration Tool makes it simple for the professionals to migrate local SQL Server database to Azure. It allows users to migrate MDF to Azure SQL without any data loss. This utility is also capable of migrating NDF files to Azure. The size of the database does not matter, the software can even migrate large size SQL Server database.

Two scanning options i.e. Quick Scan and Advance Scan are provided for migrating the corrupted SQL Server database files. The tool generates the preview of the database objects users just have to click on it & can view the data. People don’t have to worry about the originality & the integrity of the data because the tool keeps it same even after the migration.

Start With Database Objects Migrated by SQL to Azure Migration Tool

The developers designed the software for the data migration from SQL Server to Azure SQL in such a manner that it can be easily used by anyone. Plus, the database objects like tables, stored procedures, triggers, views, functions, rules, XML datatype can be migrated. In addition, the tool is smart enough to auto-detect the version of SQL Server files before the migration process. Also, this utility allows to migrate selective database objects from SQL Server to Azure.

Migrating Options

People can use either MDF or NDF file for the data migration from SQL Server to Azure SQL. The utility can migrate primary or secondary database files to Azure. As soon as the file gets loaded the software will generate the preview of the database objects of the respective files.

The tool provides two options to transfer data from SQL Server to SQL Azure i.e. ‘With Schema’ or ‘With Schema & Data’. If the “With Schema” option is selected then, only the structure of the database components will be migrated. While on the other hand if “With Schema & Data” option gets selected then the database components structure along with data will be migrated.

Next Question Comes, How to Perform Data Migration from SQL Server to Azure SQL?

After having the knowledge on how the software is beneficial, let’s have a look on its complete working:

Start the SysTools SQL Server to Azure Migration Tool

launch the tool

Click on the Open button to select the database file
Choose Advance Scan mode If the database is corrupt. Otherwise, choose Quick Scan.
scan mode

Now, select the SQL Server file version. If you don’t know then click Auto-detect option otherwise you can select it manually.

Select NDF Option tab for migrating NDF file of the SQL Server database.

Either manually select the NDF file or let the program choose automatically

Make sure the NDF file is associated with the chosen MDF file.

When the file is added the software shows the summary of the MDF file. If they want, they can also save the scan result for the future.

preview sql database

SQL Server database objects like Tables, Triggers, Views, Stored Procedures, Keys, Indexes, Columns are previewed.

Click on Migrate button to transfer data from SQL Server to SQL Azure.

After that, add Azure Database details and login credentials. Click on Connect and wait for the green tick mark.

Select the destination database name from the list.

On the left side of the tool, select the database components you wish to import to Azure SQL Database.

Also, choose whether to transfer “With schema” or “With schema & data” If required, users can also migrate deleted records.

migrate local SQL Server database to Azure

Lastly, click on the Migrate button for exporting SQL Server database to Azure

Conclusion

If the main concern is the data migration from SQL Server to Azure SQL in a simple and quick way, then this software belongs to you. It has all the functionalities that a user wish during the migration of local SQL Server database to Azure. So, use this software & save time and efforts.