SysTools SQL Server to Azure Database Migrator is designed to migrate SQL Server databases to Microsoft Azure SQL Database. It supports the migration of all SQL database objects, including tables, triggers, stored procedures, functions, views, indexes, and more. The software can migrate corrupted or inaccessible SQL databases to Azure, ensuring data integrity during the process. Users can preview all database components before migration, allowing them to verify the data and schema. The tool automatically detects the SQL Server version and offers multiple export modes, including SQL Azure, Scripts, and SQL On Premise. It also allows users to preview deleted records and database objects in red color, providing an option to migrate data items with or without schema. The software supports SQL Server versions 2022 and below and can migrate NDF file data to Azure SQL databases. It also supports auto-detection of collation up to SQL Server 2017.

Features & Benefits

• Comprehensive Migration
  • Migrates all SQL database objects, including tables, views, stored procedures, functions, triggers, indexes, rules, and XML data types.
• Corrupted Database Migration
  • Capable of migrating corrupted databases to a healthy state in Microsoft Azure SQL Database.
• Database Object Preview
  • Allows users to preview all database components before migration, ensuring data accuracy and completeness.
• NDF File Support
  • Supports the migration of NDF files, providing flexibility in handling secondary database files.
• Deleted Records Migration
  • Enables users to migrate accidentally deleted SQL database records to Azure SQL Server.
• Selective Migration
  • Enables users to perform selective migration of SQL database objects, choosing specific tables, views, and stored procedures to migrate.
• Schema and Data Options
  • Permits users to migrate database items with either schema only or with both schema and data.
• Multiple NDF Files
  • Allows users to browse multiple NDF files for migration, with options for auto-detection or manual selection.
• Save Scan Results
  • Saves scanned MDF and NDF files as .str files to resume the process later, saving time.
• CSV Report Generation
  • Generates a CSV report containing details of the migrated database objects, including tables, views, triggers, and stored procedures.