• Has anyone migrated databases from on premise SQL Server to Azure Managed instance? If yes, what are the data transfer methods used? Thanks in advance.

  • What have you considered?  Have you tried anything yet? Do you have a time frame that this needs to be completed within? Is your on-prem SQL 2017?

    The possible methods are many.  The simplest is probably backup and restore.  But if your timeframe is tight, that may not work.

    Michael L John
    If you assassinate a DBA, would you pull a trigger?
    To properly post on a forum:

  • It is SQL 2017. I agree backup and restore is an option. However, I am looking to replicate the data from on prem to Azure MI continuously. Does Log shipping would work?

  • Since you can do a backup and a restore, you can do log shipping. If you're looking for a way to do this to MI with minimal downtime, that's generally acknowledged as the best approach.

    The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore Roosevelt
    The Scary DBA
    Author of: SQL Server 2022 Query Performance Tuning, 6th Edition and SQL Server Execution Plans, 3rd Edition
    Product Evangelist for Red Gate Software

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply