Post reply

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

  • December 11, 2019 at 7:09 pm

    #3707120

    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.

  • December 12, 2019 at 1:56 pm

    #3707379

    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 Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

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

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