Forum Discussion
Hosted SQL advice please
I’m looking to migrate away from our on prem DC and separate SQL server into Azure. My plan is to join our Windows 10 clients to our existing Azure domain (AAD), continue to use Exchange online f...
Consider the size of your DB, if it's small, you can set up a replica to the Azure SQL.
But if the size if big, then it's better to backup your on prem DB and upload it to Azure then restore it to Azure SQL.
Then setup a replication between on prem DB and Azure SQL. Once they both are lined up. Disconnect the on prem DB and direct users to use the Azure SQL DB instead. This shift needs to be done in a pre defined maintenance window to avoid any business disruption
Hope this helps!
But if the size if big, then it's better to backup your on prem DB and upload it to Azure then restore it to Azure SQL.
Then setup a replication between on prem DB and Azure SQL. Once they both are lined up. Disconnect the on prem DB and direct users to use the Azure SQL DB instead. This shift needs to be done in a pre defined maintenance window to avoid any business disruption
Hope this helps!