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
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply