Share via

offline DB migrate to Azure SQL MI for testing first

Tuan L 1 Reputation point
2021-01-25T19:04:30.93+00:00

hi, does anyone know how or have any link on how to backup and restore my on-premise db to Azure SQl MI. I understand you can do live migration, but I want to test it first.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,143 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Cris Zhan-MSFT 6,641 Reputation points
    2021-01-26T02:59:28.39+00:00

    Hi @Tuan L ,

    SQL Managed Instance supports the following database migration options (currently these are the only supported migration methods):
    *Azure Database Migration Service - migration with near-zero downtime.
    *Native RESTORE DATABASE FROM URL - uses native backups from SQL Server and requires some downtime.

    Please check the following documents for more details .
    SQL Server instance migration to Azure SQL Managed Instance(overview)
    Migrate your databases(quickstart guide)
    Quickstart: Restore a database to Azure SQL Managed Instance with SSMS

    To avoid failures and check compatibility, you can use Data Migration Assistant (DMA) to analyze your databases on SQL Server and find any issue that could block migration to a SQL Managed Instance,such as existence of FileStream or multiple log files.

    In addition for large migrations (in terms of number and size of databases), we recommend that you use the Azure Database Migration Service, which can migrate databases at scale.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.