Once you find and fix compatibility issues, the next step is to select a migration tool or method and perform the actual migration. There are different methods available for various scenarios. The selection largely depends on downtime, database size, and network speed/quality.
Here's a comparison of various migration methods to help you correctly choose a migration method:
Migration Method |
Description |
Downtime |
Database Size |
---|---|---|---|
SQL Server Management Studio – Deploy Database to Azure SQL Database |
Wizard-based GUI to export on-premises database to
|
Yes (depends on database size) |
Small to Medium databases |
Sqlpackage.exe |
Command-line utility to export on-premises databases to
|
Yes (Depends on database size) |
Small to Medium databases |
Manual (Dacpac and BCP) |
Use
|