Determining the Migration Method
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 ... |
Get Professional Azure SQL Database Administration now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
