Migrate SQL Server Database Off of Azure to on-prem with little downtime

  • We have decided to move off of Azure to a local data center and wanted opinions on how to do this migration with little to no downtime. My initial thought was to utilize transactional replication, however, from what I've read, Azure can not have  a database that is a publisher, only a subscriber.


    Any ideas or paste experiences are greatly appreciated.

  • I'm not sure how you'd accomplish this to be honest. Microsoft's focus is on moving you into Azure, not out of it. Probably, your best bet, would be Azure Sync or SSIS, or possibly even Azure Data Flow. I'm unaware of any other solution. Maybe there's a third party one out there.

    Sorry I'm not being helpful.

    ----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software

Viewing 2 posts - 1 through 1 (of 1 total)

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