Online Database Move and Copy for SQL Managed Instance (Private Preview)

Published Apr 04 2022 11:50 AM 4,273 Views
Microsoft

As you experience growth in the number Azure SQL Managed Instances, databases hosted, and volume of workloads, most likely you would need to have more flexibility in moving and copying databases across your fleet of managed instances with minimum downtime. In running multiple managed instances perhaps one, or more of your databases have grown too large and you need to re-balance your database portfolio across managed instances. Perhaps you also might have a need to migrate databases across managed instances with minimum downtime for various reasons, for example in performing upgrades, changes to your infrastructure, or perhaps moving an entire portfolio of databases to another managed instance hosted in a different environment. Perhaps you are also looking for the most performant way to copy databases between managed instances with ability to control the specific cutover time when the operation will be completed. At the same time, as you have active workloads, you cannot afford any downtime, and you need to have your application(s) seamlessly switch to the new managed instance. These are just some of the examples where online database copy and move operations between managed instances might be required.

 

Online DB copy and move features

 

For this purpose, our team has worked on a set of features using Always On technology to perform database copy and move operation across managed instances, with customer being in full control of the process. How does it work -- once you start the copy or move operation, the seeding (copying) of your database starts online from source managed instance to the target instance. Once the seeding has completed, the system enters the catch-up phase. In this phase all new commits to the source (primary) managed instance are copied near real-time to the destination (secondary) managed instance, that is two databases are kept continuously in sync. The system will keep databases in sync waiting for your instruction to perform the cutover. Once you instruct the system to perform the cutover, the operation is completed with minimum downtime. Upon operation completion, you can re-point your application(s) to use the moved or copied database instantaneously without having interruption to your workload.

 

DB move 01.png

 

Invitation for Early Adopters

 

We are currently opening these features in a limited private preview and invite you to sign up. We are looking for customers who could benefit from the above scenarios, having active workloads, and willingness to evaluate the new technology. We are interested to learn more about your usage scenarios, and cases where similar types of database mobility between managed instances could be beneficial to you. Your valuable feedback might influence and shape the future product.

 

To apply, submit the following online form with the information required:

 

 

We will be evaluating new applications on the rolling basis and we're looking forward working with you.

 

Closing remarks

 

As our products continuously evolve, please note that features and options presented in this article are subject to change. This article reflects the state of the link feature options available for Managed Instance in April, 2022.

 

If you find this article useful, please like it on this page and share through social media. To share this article, you can use the Share button below, or this short link: https://aka.ms/mi-dbcopymove-signup. Also, please feel free to post your questions and comments in the section below.

 

2 Comments
%3CLINGO-SUB%20id%3D%22lingo-sub-3275690%22%20slang%3D%22en-US%22%3EOnline%20Database%20Move%20and%20Copy%20for%20SQL%20Managed%20Instance%20(Private%20Preview)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3275690%22%20slang%3D%22en-US%22%3E%3CP%3EAs%20you%20experience%20growth%20in%20the%20number%20Azure%20SQL%20Managed%20Instances%2C%20databases%20hosted%2C%20and%20volume%20of%20workloads%2C%20most%20likely%20you%20would%20need%20to%20have%20more%20flexibility%20in%20moving%20and%20copying%20databases%20across%20your%20fleet%20of%20managed%20instances%20with%20minimum%20downtime.%20In%20running%20multiple%20managed%20instances%20perhaps%20one%2C%20or%20more%20of%20your%20databases%20have%20grown%20too%20large%20and%20you%20need%20to%20re-balance%20your%20database%20portfolio%20across%20managed%20instances.%20Perhaps%20you%20also%20might%20have%20a%20need%20to%20migrate%20databases%20across%20managed%20instances%20with%20minimum%20downtime%20for%20various%20reasons%2C%20for%20example%20in%20performing%20upgrades%2C%20changes%20to%20your%20infrastructure%2C%20or%20perhaps%20moving%20an%20entire%20portfolio%20of%20databases%20to%20another%20managed%20instance%20hosted%20in%20a%20different%20environment.%20Perhaps%20you%20are%20also%20looking%20for%20the%20most%20performant%20way%20to%20copy%20databases%20between%20managed%20instances%20with%20ability%20to%20control%20the%20specific%20cutover%20time%20when%20the%20operation%20will%20be%20completed.%20At%20the%20same%20time%2C%20as%20you%20have%20active%20workloads%2C%20you%20cannot%20afford%20any%20downtime%2C%20and%20you%20need%20to%20have%20your%20application(s)%20seamlessly%20switch%20to%20the%20new%20managed%20instance.%20These%20are%20just%20some%20of%20the%20examples%20where%20online%20database%20copy%20and%20move%20operations%20between%20managed%20instances%20might%20be%20required.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId--55274118%22%20id%3D%22toc-hId-393789776%22%20id%3D%22toc-hId-416845105%22%20id%3D%22toc-hId-416845105%22%20id%3D%22toc-hId-416845105%22%20id%3D%22toc-hId-416845105%22%3EOnline%20DB%20copy%20and%20move%20features%3C%2FH2%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFor%20this%20purpose%2C%20our%20team%20has%20worked%20on%20a%20set%20of%20features%20using%20Always%20On%20technology%20to%20perform%20database%20copy%20and%20move%20operation%20across%20managed%20instances%2C%20with%20customer%20being%20in%20full%20control%20of%20the%20process.%20How%20does%20it%20work%20--%20once%20you%20start%20the%20copy%20or%20move%20operation%2C%20the%20seeding%20(copying)%20of%20your%20database%20starts%20online%20from%20source%20managed%20instance%20to%20the%20target%20instance.%20Once%20the%20seeding%20has%20completed%2C%20the%20system%20enters%20the%20catch-up%20phase.%20In%20this%20phase%20all%20new%20commits%20to%20the%20source%20(primary)%20managed%20instance%20are%20copied%20near%20real-time%20to%20the%20destination%20(secondary)%20managed%20instance%2C%20that%20is%20two%20databases%20are%20kept%20continuously%20in%20sync.%20The%20system%20will%20keep%20databases%20in%20sync%20waiting%20for%20your%20instruction%20to%20perform%20the%20cutover.%20Once%20you%20instruct%20the%20system%20to%20perform%20the%20cutover%2C%20the%20operation%20is%20completed%20with%20minimum%20downtime.%20Upon%20operation%20completion%2C%20you%20can%20re-point%20your%20application(s)%20to%20use%20the%20moved%20or%20copied%20database%20instantaneously%20without%20having%20interruption%20to%20your%20workload.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22DB%20move%2001.png%22%20style%3D%22width%3A%20703px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F361224i4F1EA25F3503AFEA%2Fimage-dimensions%2F703x446%3Fv%3Dv2%22%20width%3D%22703%22%20height%3D%22446%22%20role%3D%22button%22%20title%3D%22DB%20move%2001.png%22%20alt%3D%22DB%20move%2001.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId--55274118%22%20id%3D%22toc-hId--1413664687%22%20id%3D%22toc-hId--1390609358%22%20id%3D%22toc-hId--1390609358%22%20id%3D%22toc-hId--1390609358%22%20id%3D%22toc-hId--1390609358%22%3EInvitation%20for%20Early%20Adopters%3C%2FH2%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWe%20are%20currently%20opening%20these%20features%20in%20a%26nbsp%3B%3CSTRONG%3Elimited%20private%20preview%3C%2FSTRONG%3E%26nbsp%3Band%20invite%20you%20to%20sign%20up.%20We%20are%20looking%20for%20customers%20who%20could%20benefit%20from%20the%20above%20scenarios%2C%20having%20active%20workloads%2C%20and%20willingness%20to%20evaluate%20the%20new%20technology.%20We%20are%20interested%20to%20learn%20more%20about%20your%20usage%20scenarios%2C%20and%20cases%20where%20similar%20types%20of%20database%20mobility%20between%20managed%20instances%20could%20be%20beneficial%20to%20you.%20Your%20valuable%20feedback%20might%20influence%20and%20shape%20the%20future%20product.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETo%20apply%2C%20submit%20the%20following%20online%20form%20with%20the%20information%20required%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Faka.ms%2Fmi-dbcopymove-signup%22%20target%3D%22_new%22%20rel%3D%22noopener%20noreferrer%22%3E%3CBUTTON%20style%3D%22background-color%3A%20%233366ff%3B%20color%3A%20white%3B%22%3ESign-up%20for%20the%20online%20database%20move%20and%20copy%20feature%3C%2FBUTTON%3E%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWe%20will%20be%20evaluating%20new%20applications%20on%20the%20rolling%20basis%20and%20we're%20looking%20forward%20working%20with%20you.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId--55274118%22%20id%3D%22toc-hId-1073848146%22%20id%3D%22toc-hId-1096903475%22%20id%3D%22toc-hId-1096903475%22%20id%3D%22toc-hId-1096903475%22%20id%3D%22toc-hId-1096903475%22%3EClosing%20remarks%3C%2FH2%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAs%20our%20products%20continuously%20evolve%2C%20please%20note%20that%20features%20and%20options%20presented%20in%20this%20article%20are%20subject%20to%20change.%20This%20article%20reflects%20the%20state%20of%20the%20link%20feature%20options%20available%20for%20Managed%20Instance%20in%20April%2C%202022.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20find%20this%20article%20useful%2C%20please%20like%20it%20on%20this%20page%20and%20share%20through%20social%20media.%20To%20share%20this%20article%2C%20you%20can%20use%20the%20Share%20button%20below%2C%20or%20this%20short%20link%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Faka.ms%2Fmi-dbcopymove-signup%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Faka.ms%2Fmi-dbcopymove-signup%3C%2FA%3E.%20Also%2C%20please%20feel%20free%20to%20post%20your%20questions%20and%20comments%20in%20the%20section%20below.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-3275690%22%20slang%3D%22en-US%22%3E%3CP%3ELooking%20for%20the%20most%20performant%20way%20to%20move%20and%20copy%20databases%20online%20between%20Managed%20Instances%20with%20minimum%20downtime%3F%20Look%20no%20further.%20Our%20EAP%20(Early%20Adoption%20Program)%20is%20for%20you.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22DB%20move%2002.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F361221i596ADB82F87521C8%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22DB%20move%2002.png%22%20alt%3D%22DB%20move%2002.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3275690%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20SQL%20Managed%20Instance%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3287747%22%20slang%3D%22en-US%22%3ERe%3A%20Online%20Database%20Move%20and%20Copy%20for%20SQL%20Managed%20Instance%20(Private%20Preview)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3287747%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3Ecan%20we%20copy%20the%20DB%20across%20subscriptions%20%3F%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%26nbsp%3B%3C%2FP%3E%3CP%3ENeeraj%20D%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3356724%22%20slang%3D%22en-US%22%3ERe%3A%20Online%20Database%20Move%20and%20Copy%20for%20SQL%20Managed%20Instance%20(Private%20Preview)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3356724%22%20slang%3D%22en-US%22%3E%3CP%3EMoving%20DBs%20across%20subscriptions%20is%20not%20supported%20at%20this%20time%2C%20however%20we%20are%20open%20to%20your%20feedback.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Co-Authors
Version history
Last update:
‎Apr 05 2022 03:13 AM
Updated by: