November 16, 2016 at 3:23 am
Hello,
Our company is looking to migrate on-premise database to Azure DBaas. Can only afford minimum downtime as the application is web-facing. I'm thinking of transactional replication with push subscription and cutoff at some point when all articles are moved. Has anyone done this method before? Any roadblocks I should be aware of? Hopefully I'll get a test server with replication soon, so I can test the method. Please give your opinion on this or any better method if there is.
Thanks
November 16, 2016 at 11:48 am
I have never attempted to set up replication to Azure SQL DB. I suppose it will work since it's in the documentation. I'd strongly suggest testing it and setting it up, tearing it down, a few times, before you attempt to do it for real that way.
I'm not comfortable with the approach, but frankly, I'm not sure of another approach currently that will provide you with the kind of minimized downtime you're looking for.
"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
November 18, 2016 at 4:40 am
Apart from Replication I don't see any other way to minimise the downtime. Thanks for your response.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply