SysTools SQL Server to Azure Database Migrator

SysTools SQL Server to Azure Database Migrator

 

Advance Utility to Migrate SQL Server Database to Microsoft Azure SQL Database

• Able to Move all SQL database objects: Tables, Triggers, Stored Procedures etc.
• Migrate corrupted / inaccessible SQL database to Azure Database
• Preview all database components before migrating SQL Database to Azure
• Migrate Deleted Table, Stored Procedure, Functions, Views, Triggers, Rules, Indexes
• Auto-detect SQL Server version while migrating data to Azure SQL database
• Preview deleted table records and database objects in Red color
• Allows to migrate selected data items 'With Schema' or 'With Schema & Data' option
• Supports to export SQL database from SQL Server 2019 and all below versions 
• Provides facility to Migrate NDF file data to Azure SQL database
• Allows to Migrate deleted records to SQL Azure cloud database
• Provided support to Auto-Detect Collation till SQL Server 2017

 

SysTools SQL Server Database to Azure Database Migrator Tool

Quick Solution to Upload SQL Database to Azure

 

Preview Database Objects Before Migration

Once the MDF / NDF file gets loaded for the migration process the SQL Server Database to Azure Migrator tool generates the preview of database objects. Only just by selecting the particular database object the user can view its contents on the right pane. This software shows the deleted database objects and table records in red color.

• Tables
• Functions
• Triggers
• Views

• Stored Procedure
• Rules
• Indexes
• XML Data Type

 

 

Option to Migrate Multiple NDF Files

With SQL to Microsoft Azure Migrator tool, you can browse multiple NDF files for the migration process. The tool gives two options to select NDF files i.e.

• Auto-detect: By selecting this feature the tool will auto-detect the secondary (NDF) file
• Manual Selection: Use ‘Add Files’ option to add single or multiple NDF files for migration & ‘Add Folder’ Option to add various NDF files present in a folder.

 

 

Key Features of SQL Server Database to Azure Database Migrator Tool

An Advance Utility to Move Database from SQL Server to Azure SQL Database

 

 

Transfer SQL Server Database to Azure

Users can perform direct migration from SQL to Azure SQL database with the help of this software. SQL Server credentials like Server name, Database name, Username and password etc. are required to migrate data from SQL Server. After that, one can easily move SQL data to Azure.

 

 

Move All SQL Database Objects

SQL Server to Azure Database migrator supports to transfer all database objects from SQL Server. Table, Views, Sequence, Indexes, Rules, Functions, Tables, Stored Procedures, associated Primary Key, Unique keys, data types and all other components can be transferred from SQL to Azure migration tool.

 

 

Migrate Corrupted Database in Healthy State

The software is capable to migrate corrupted database into healthy state from local SQL server to Microsoft Azure SQL Database. When the user selects corrupted SQL Server database file to transfer, the tool quickly scans the selected file and migrate it in healthy state.

 

 

Auto-detect SQL Server Version

SQL to Azure Database migration tool is a smart utility that can auto-detect the version of SQL Server files before migrating them. However, sometimes users know the actual version of the SQL database file. For that case, the software gives an option to check the appropriate SQL Server version manually.

 

 

Able To Migrate Deleted Records

As there are high possibilities that users might have deleted some database objects accidentally and now they need to migrate them into the SQL Azure cloud database. In that case, the SQL to Azure Database migrator tool helps users to transfer their accidentally deleted SQL database records. So that users can migrate them into the Azure SQL Server without any trouble. Also, this software previews the deleted database records in red color.

 

 

Preview All Database Components

After scanning the SQL Server database items, the software previews all database components such as Tables, Functions, Stored Procedures, Columns, Indexes, Keys etc., along with item count in its in-built database viewer. This feature establish the software’s credibility as users can decide which data is to be migrated. Also the user can preview deleted database objects in red color.

 

 

Transfer Selective Database Objects

SQL Server Database to Azure Migration Software enables users to perform selective migration of SQL database objects. This functionality allows users to select specific database objects that need to be migrated from the list. From the export window, users can select Tables, Views, Stored Procedures etc. to migrate.

 

 

Migrate Only Schema/ Schema & Data

SQL Server to Azure Database migrator tool permits users to move the database items with two options, either as ‘With schema’ or ‘With Schema & Data’. Selecting only schema option migrate only the schema/ structure of selected database components. In addition, one can move the database components with both schema and Data.

 

 

Move to New / Existing Azure DB

The software allows users to migrate the SQL database in existing SQL Azure cloud database. Also, if users want to import SQL Database to new Azure database, they can create a new database in their Azure Server to migrate a database as a new database. For this, users just need to make a new database by clicking on Create new database option.

 

 

MDF & NDF File Migration

SQL Server to Azure Migrator tool can transfer primary and secondary database files i.e. MDF and NDF. The software enables the user to browse any of these files for the migration purpose. Also, as soon as the file gets loaded the tool will generate the respective database objects.

 

 

Feature to Save Large File Scan

After scanning the MDF and NDF files of SQL Server users can save the scanned file as .str file at any location. Basically, this feature saves the scanning time i.e. if in case the process is closed in between then later it can be started just by loading the already saved .str file.

 

 

Creates CSV Report

When the software completes the process of migrating SQL Data to Azure Database it given an option to save the Export details into a .csv file format. This report contains database objects like tables, views, triggers, stored procedures, functions, rules, and the exported report counts.

 

Software Specifications

 

Hard Disk Space: 100 MB

Processor: Intel® Core™ 2 Duo CPU E4600 @ 2.40GHz 2.39GHz

RAM: 2 GB

SQL Server:

2019, 2017, 2016, 2014, 2012, 2008 R2, 2008, 2005 & 2000

Win OS: 10, 8.1, 8, 7 & All below Versions

Additional Software: Microsoft .NET framework 4.5 or above

ODBC Driver 17 should be installed

 

Application Pre-Requisites

1. If you are using Windows 10/8.1/8/7 or Vista, then please launch the tool as "Run as Administrator"

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

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

 

SQL Server Database to Azure Migrator Feature Comparison

Get an Overview of SQL to Azure Migrator Tool Features – DEMO and Licensed Version

 

Features	DEMO Version	FULL Version
Add MDF/NDF File	V	V
Two Advance Scanning Modes	V	V
Preview MDF/NDF Components	V	V
Save Scanned MDF in STR Format	V	V
Support SQL Server versions 2019, 2017, 2016, 2014, 2012, 2008, 2005 & 2000	V	V
Preview deleted SQL table records and database objects	V	V
Migrate Entire data from MDF/NDF File	X	V
Migrate with Schema & Schema & Data	X	V

 

Frequently Asked Questions

Listed Commonly Asked Questions and Answers

 

What are the steps for migrating SQL server database to Microsoft Azure SQL?

To move / transfer data from SQL server to Azure Database follow these simple steps:

• Step 1: Download & Run SysTools SQL to Azure Migration Tool
• Step 2: Click the Open button to Browse MDF file for migration
• Step 3: Preview SQL Server database objects i.e. Table, Views, etc
• Step 4: Click Migrate to begin SQL server database migration to Azure
• Step 5: Enter Server Name, Login credentials & click “Connect”
• Step 6: Now, select the Destination database
• Step 7: Select migrate ‘With Only Schema’ or ‘With Schema & Data’
• Step 8: Lastly, click the Migrate button

 

 

Can I migrate corrupt SQL Server database to SQL Azure database?

“While migrating SQL Server to Azure, my database suddenly got inaccessible and we got to know that there is corruption in our database. Is this tool helpful in fixing SQL database?

Yes, if the database is corrupted, then the software scans the corrupted file and allow you to migrate SQL Server database to Azure in healthy state.

 

Is there any file size limitation imposed by software to migrate SQL 2012 database to Azure?

No, there is no such file size limitation imposed by SQL to Azure Database Migrator software to move the database.

 

Can I move only tables from SQL 2008 database to Azure?

Yes, of course also you can transfer all database objects like functions, views etc. using SQL to Azure database migration software.

 

If I do not know the version of SQL database, can I be able to transfer SQL Server 2014 to Azure?

SQL Server to SQL Azure Database Migrator has an amazing Auto-detect feature which automatically detects the SQL version. Hence you can easily move SQL Server database to Azure from SQL Server 2019, 2017, 2016, 2014 & its below version.

 

Does this software allow to migrate Schema only from SQL Server database?

Yes, with the help of this SQL Server to Azure Migration Tool one can migrate the database with Schema or Schema and data both.

 

Does tool support all versions of SQL Server for the migration process?

Yes, the software supports SQL Server versions like 2019/2017/2016/2014/2012/2008 R2/2008/2005/2000.

 

Is it possible to perform selective migration of SQL Server database objects with this tool?

Yes, of course, the tool allows you to select the particular database objects like triggers, views, etc., for the migration process. Once the objects are selected users can migrate them to Azure SQL database.

 

Is it necessary to have SQL Server on my local machine to use this software?

No, the software does not require SQL Server environment for migrating SQL database to Azure.

 

Can I migrate SQL database to new Azure SQL database?

Yes, of course, user can transfer SQL database to new Azure SQL database. But, it is necessary that the user should create a new database in their Azure Server for carrying out the migration process.

 

Is it possible to migrate SQL Server to Azure SQL database having basic service tier?

Yes, of course, you can easily move SQL Server to Azure SQL having basic tier with this tool. Basically, this software supports all 3 service tiers i.e. Basic, Standard & Premium of Azure SQL database.

 

I am using standard service tier with 3000 DTU, so is it possible to perform SQL to Azure migration by this tool?

Yes, of course, you can easily migrate SQL Server to Azure SQL Server having standard tier with 3000 DTU by this tool.

 

What Customers Are Saying

SysTools SQL Server Database to Azure Database Migrator Software Verified Purchase Reviews

 

“No matter how difficult the task of migration is, I can perform it easily with SQL Server to Azure Database migrator. It not only performs the migration process, but also makes the corrupted database into healthy state for a complete database migration. Thank you!”

Jamir Aguirre, Hungary

MSBI Developer

 

“SQL Server to Azure Database migration is such a complex task. However, with the help of SQL Database to Azure migrator tool, it becomes very easy for me. I have been migrated all SQL database files into SQL Azure cloud without any hassle via this amazing utility. Its Preview and Select option is actually handy to migrate migrate SQL Server Database to Azure.”

Jakob Flaten, U.S

SQL Analyst

 

“First of all, I want to say a big thank you to the whole developer team for designing such unique and eminent software. Due to its user-friendly interface, we easily move SQL Server database to Azure. I would like to recommend this tool for migrating SQL Data to Azure Database.”

Marius Jeremiassen, Greenland

SQL DBA