January 30, 2023 at 5:19 pm
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.
January 30, 2023 at 6:20 pm
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:
http://www.sqlservercentral.com/articles/61537/
January 30, 2023 at 7:06 pm
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?
January 31, 2023 at 1:10 pm
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