none
SQL Server 2008R2, replicating from on-prem, to SQL Server 2008R2 VM in Azure RRS feed

  • Question

  • I have been tasked with migrating a database, size being up to 15Gb, from a SQL Server 2008 database in a 3rd party cloud VM, to SQL Azure. On go-live day, when we switch from the old host, the Azure, we have a 1 hr downtime allowance.

    Unfortunately, the link speed is 1Mbps. So that would take around 30 hours to transfer. What I would like to do is create a Azure VM, with SQL Server 2008R2. Then, using either transaction replication, mirroring or log shipping, allow the database to replicate to my new VM from the source. I have no time limit for this, as the application migration is at my discretion. Could be a day, could be a few months.

    My question is - how can I achieve this? I think transaction replication would be best, so that the database is basically up to date all the time. I need to demonstrate that it's possible, so I have created two VMs in Azure (ClientSourceVM and ClientStagingVM) in separate vnets (Trying to simulate across the internet replication).

    The initial snap shot would take up to two days to transfer. Would this cause any adverse effect on the source database? Locking?

    And is it possible to do replication across the internet? It seems I need to share folders and setup permissions, but not sure how that works with servers in separate domains across the internet. Is it possible?

    With SQL Server 2008R2 - is there any better option that can serve my needs?

    Note, once the database gets to 2008R2, I'll then hopefully migrate that to it's Azure SQL destination on go-live day. The replication is purely to allow an up to date database be available on the go-live day without waiting nearly 2 days for the backup file to copy.

    Any advice and ideas would be greatly appreciated.

    Thursday, August 8, 2019 11:24 PM

All replies

  • Hi CraiglnBrisbane,

     

    >>With SQL Server 2008R2 - is there any better option that can serve my needs?

     

    Depending on your situation, I think using Azure Blob Storage Service for backup and restore may be the best approach, you want to use transactional replication, but it is very difficult to configure transaction replication in your environment. I look forward to other experts who can come up with better opinions.

     

    Please refer to https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windows-sql-high-availability-dr

     

    Best regards,

    Dedmon Dai


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Friday, August 9, 2019 7:53 AM