Migrating SQL Server 2016 on-prem to Azure SQL DB

Vijay Kumar 2,016 Reputation points
2022-02-14T07:15:47.397+00:00

Hi Team,

We are planning to Migrate all our 5 on Prem SQL Server 2016 to Azure SQL DB.

Out of five 2 with log shipping and 2 (Primary+1 Secondary) with AlwayOn.

In this case how to migrate with very little downtime?

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,750 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,554 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Alberto Morillo 32,891 Reputation points MVP
    2022-02-14T10:44:05.247+00:00

    Before migrating, my suggestion is to use Data Migration Assistant to perform an assessment of those databases, some adjustments may be needed.

    You can use Transactional Replication to migrate to Azure SQL as explained on this article.

    You can also use Azure SQL Data Sync to perform a one-way or two-replication between your server on-premises and Azure SQL Database.

    Database Migration Service (DMS) allows to perform online migrations with no downtime, but some requirements need to be met like Change Tracking must be enabled or all tables need to have primary keys. See a tutorial here. To use DMS for online migration you will also need to use Azure SQL Premium tiers. Here you will find more information about online migrations.

    Finally, you can configure Zone Redundancy or Geo-Replication to create replicas of your Azure SQL databases.

    0 comments
  2. Seeya Xi-MSFT 16,441 Reputation points
    2022-02-15T02:26:41.51+00:00

    Hi @Vijay Kumar ,

    Welcome to Microsoft Q&A!
    Please see this document: https://learn.microsoft.com/en-us/azure/azure-sql/migration-guides/database/sql-server-to-sql-database-overview
    In this link you can see the different Migration tools and Feature interoperability.

    Best regards,
    Seeya

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments