Announcing Azure SQL Migration extension for Azure Data Studio - public preview

Published Sep 01 2021 08:06 AM 4,508 Views

With rising demands from the ever-changing business landscape and now with the global pandemic, organizations large and small continue to accelerate digital transformation initiatives to thrive in the new hybrid world. Organizations that have migrated their core business applications and databases to the cloud have overcome many of the challenges several industries have encountered since the global pandemic began. The fundamental step towards a successful digital transformation is enabling organizations to migrate and modernize to the cloud.

 

To help migrate SQL Server databases to Azure, we are announcing a new migration experience that will not only help assess and migrate SQL Server databases to Azure with minimal downtime, but to do so using Azure Data Studio powered by Azure Database Migration Service. Azure Data Studio is a popular tool used by database administrators, data operations professionals, and developers to manage databases both on-premises and in the cloud.

 

Use the Azure SQL Migration extension in Azure Data Studio to migrate to either Azure SQL Managed Instance (Platform-as-a-Service) or to SQL Server on Azure Virtual Machines (Infrastructure-as-a-Service). As part of this Public Preview announcement, the extension will support migrations for both online (for migrations that require minimal downtime) and offline (for migrations where downtime persists through the duration of the migration) modes that suit the requirements of various applications.

 

ADS extension GIF.gif

 Get started with the Azure SQL Migration extension from the server connections in Azure Data Studio and launch the Migrate to Azure SQL wizard to begin.

 

The new Azure SQL Migration extension in Azure Data Studio brings together a simplified assessment and migration experience that delivers the following capabilities.

  • Integrated assessment and migration experience. A responsive user interface that provides an easy-to-navigate step-by-step wizard to configure, run and monitor database migrations.
  • Assessment for cloud readiness. An enhanced assessment engine that can assess SQL Server instances and identify databases that are ready for migration to Azure SQL Managed Instance or SQL Server on Azure Virtual Machines.
  • Minimal downtime migrations. A robust, scalable, and secure Azure Database Migration Service that provides reliability and resiliency for database migrations and orchestrates data movement activities to deliver a seamless migration experience with minimal downtime.

 

Screenshot 2021-08-26 122225.png

 Sample database readiness assessment for Azure SQL Managed Instance and SQL Server on Azure Virtual Machine.

 

Starting today, the new Azure SQL Migration extension is available in the Azure Data Studio marketplace. Azure Data Studio provides the flexibility as a cross-platform database tool for data professionals who use on-premises and cloud data platforms on Windows, MacOS, and Linux.

 

To provide secure and easy access to source database backups and to upload them to Azure, we are providing the flexibility to set up a self-hosted integration runtime on a machine that can connect to the on-premises environment. All of these data movement activities are automated and orchestrated by the Azure Database Migration Service, thereby reducing the effort to perform database migrations.

The database backup files can be provided in an on-premises network file share where the service will utilize the self-hosted integration runtime to fetch the database backups. Alternatively, the database backup files can be provided in an Azure storage container where the service can fetch the backups and migrate them to the desired target. The extension also provides monitoring of database migrations along with a detailed view of database backups’ metadata and restore status on the target Azure SQL MI or SQL Server on Azure VM.

 

We believe that this new migration experience will empower you to successfully complete your database migrations to Azure SQL and in turn deliver greater business outcomes.

 

 

To learn more

%3CLINGO-SUB%20id%3D%22lingo-sub-2703295%22%20slang%3D%22en-US%22%3EAnnouncing%20Azure%20SQL%20Migration%20extension%20for%20Azure%20Data%20Studio%20-%20public%20preview%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2703295%22%20slang%3D%22en-US%22%3E%3CP%3EWith%20rising%20demands%20from%20the%20ever-changing%20business%20landscape%20and%20now%20with%20the%20global%20pandemic%2C%20organizations%20large%20and%20small%20continue%20to%20accelerate%20digital%20transformation%20initiatives%20to%20thrive%20in%20the%20new%20hybrid%20world.%20Organizations%20that%20have%20migrated%20their%20core%20business%20applications%20and%20databases%20to%20the%20cloud%20have%20overcome%20many%20of%20the%20challenges%20several%20industries%20have%20encountered%20since%20the%20global%20pandemic%20began.%20The%20fundamental%20step%20towards%20a%20successful%20digital%20transformation%20is%20enabling%20organizations%20to%20migrate%20and%20modernize%20to%20the%20cloud.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETo%20help%20migrate%20SQL%20Server%20databases%20to%20Azure%2C%20we%20are%20announcing%20a%20new%20migration%20experience%20that%20will%20not%20only%20help%20assess%20and%20migrate%20SQL%20Server%20databases%20to%20Azure%20with%20minimal%20downtime%2C%20but%20to%20do%20so%20using%20Azure%20Data%20Studio%20powered%20by%20Azure%20Database%20Migration%20Service.%20Azure%20Data%20Studio%20is%20a%20popular%20tool%20used%20by%20database%20administrators%2C%20data%20operations%20professionals%2C%20and%20developers%20to%20manage%20databases%20both%20on-premises%20and%20in%20the%20cloud.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EUse%20the%20%3CA%20href%3D%22https%3A%2F%2Faka.ms%2Fazuresqlmigrationextension%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EAzure%20SQL%20Migration%20extension%3C%2FA%3E%20in%20Azure%20Data%20Studio%20to%20migrate%20to%20either%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fazure-sql%2Fmanaged-instance%2Fsql-managed-instance-paas-overview%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EAzure%20SQL%20Managed%20Instance%3C%2FA%3E%20(Platform-as-a-Service)%20or%20to%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fazure-sql%2Fvirtual-machines%2Fwindows%2Fsql-server-on-azure-vm-iaas-what-is-overview%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ESQL%20Server%20on%20Azure%20Virtual%20Machines%3C%2FA%3E%20(Infrastructure-as-a-Service).%20As%20part%20of%20this%20Public%20Preview%20announcement%2C%20the%20extension%20will%20support%20migrations%20for%20both%20online%20(for%20migrations%20that%20require%20minimal%20downtime)%20and%20offline%20(for%20migrations%20where%20downtime%20persists%20through%20the%20duration%20of%20the%20migration)%20modes%20that%20suit%20the%20requirements%20of%20various%20applications.%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-center%22%20image-alt%3D%22ADS%20extension%20GIF.gif%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F306955i0EE5BC3BE6477645%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22ADS%20extension%20GIF.gif%22%20alt%3D%22ADS%20extension%20GIF.gif%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CEM%3E%26nbsp%3B%3CSPAN%20style%3D%22font-size%3A%20small%3B%20font-family%3A%20inherit%3B%22%3EGet%20started%20with%20the%20%3C%2FSPAN%3EAzure%20SQL%20Migration%20extension%3CSPAN%20style%3D%22font-size%3A%20small%3B%20font-family%3A%20inherit%3B%22%3E%20from%20the%20server%20connections%20in%20Azure%20Data%20Studio%20and%20launch%20the%20%3C%2FSPAN%3E%3CFONT%20size%3D%222%22%3EMigrate%20to%20Azure%20SQL%3C%2FFONT%3E%3CSPAN%20style%3D%22font-size%3A%20small%3B%20font-family%3A%20inherit%3B%22%3E%20wizard%20to%20begin.%3C%2FSPAN%3E%3C%2FEM%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20new%20Azure%20SQL%20Migration%20extension%20in%20Azure%20Data%20Studio%20brings%20together%20a%20simplified%20assessment%20and%20migration%20experience%20that%20delivers%20the%20following%20capabilities.%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3E%3CSTRONG%3EIntegrated%20assessment%20and%20migration%20experience.%3C%2FSTRONG%3E%20A%20responsive%20user%20interface%20that%20provides%20an%20easy-to-navigate%20step-by-step%20wizard%20to%20configure%2C%20run%20and%20monitor%20database%20migrations.%3C%2FLI%3E%0A%3CLI%3E%3CSTRONG%3EAssessment%20for%20cloud%20readiness.%3C%2FSTRONG%3E%20An%20enhanced%20assessment%20engine%20that%20can%20assess%20SQL%20Server%20instances%20and%20identify%20databases%20that%20are%20ready%20for%20migration%20to%20Azure%20SQL%20Managed%20Instance%20or%20SQL%20Server%20on%20Azure%20Virtual%20Machines.%3C%2FLI%3E%0A%3CLI%3E%3CSTRONG%3EMinimal%20downtime%20migrations.%3C%2FSTRONG%3E%20A%20robust%2C%20scalable%2C%20and%20secure%20Azure%20Database%20Migration%20Service%20that%20provides%20reliability%20and%20resiliency%20for%20database%20migrations%20and%20orchestrates%20data%20movement%20activities%20to%20deliver%20a%20seamless%20migration%20experience%20with%20minimal%20downtime.%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22Screenshot%202021-08-26%20122225.png%22%20style%3D%22width%3A%20796px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F306125i266AD36DB3585E5D%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-08-26%20122225.png%22%20alt%3D%22Screenshot%202021-08-26%20122225.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22lia-align-center%22%3E%3CEM%3E%26nbsp%3B%3CSPAN%20style%3D%22font-size%3A%20small%3B%20font-family%3A%20inherit%3B%22%3ESample%20database%20readiness%20assessment%20for%20Azure%20SQL%20Managed%20Instance%20and%20SQL%20Server%20on%20Azure%20Virtual%20Machine.%3C%2FSPAN%3E%3C%2FEM%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EStarting%20today%2C%20the%20new%20Azure%20SQL%20Migration%20extension%20is%20available%20in%20the%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fsql%2Fazure-data-studio%2Fextensions%2Fadd-extensions%3Fview%3Dsql-server-ver15%23add-azure-data-studio-extensions%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EAzure%20Data%20Studio%20marketplace%3C%2FA%3E.%20Azure%20Data%20Studio%20provides%20the%20flexibility%20as%20a%20cross-platform%20database%20tool%20for%20data%20professionals%20who%20use%20on-premises%20and%20cloud%20data%20platforms%20on%20Windows%2C%20MacOS%2C%20and%20Linux.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETo%20provide%20secure%20and%20easy%20access%20to%20source%20database%20backups%20and%20to%20upload%20them%20to%20Azure%2C%20we%20are%20providing%20the%20flexibility%20to%20set%20up%20a%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fdms%2Fmigration-using-azure-data-studio%23recommendations-for-using-self-hosted-integration-runtime-for-database-migrations%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Eself-hosted%20integration%20runtime%3C%2FA%3E%20on%20a%20machine%20that%20can%20connect%20to%20the%20on-premises%20environment.%20All%20of%20these%20data%20movement%20activities%20are%20automated%20and%20orchestrated%20by%20the%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fdms%2Fdms-overview%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EAzure%20Database%20Migration%20Service%3C%2FA%3E%2C%20thereby%20reducing%20the%20effort%20to%20perform%20database%20migrations.%3C%2FP%3E%0A%3CP%3EThe%20database%20backup%20files%20can%20be%20provided%20in%20an%20on-premises%20network%20file%20share%20where%20the%20service%20will%20utilize%20the%20self-hosted%20integration%20runtime%20to%20fetch%20the%20database%20backups.%20Alternatively%2C%20the%20database%20backup%20files%20can%20be%20provided%20in%20an%20Azure%20storage%20container%20where%20the%20service%20can%20fetch%20the%20backups%20and%20migrate%20them%20to%20the%20desired%20target.%20The%20extension%20also%20provides%20monitoring%20of%20database%20migrations%20along%20with%20a%20detailed%20view%20of%20database%20backups%E2%80%99%20metadata%20and%20restore%20status%20on%20the%20target%20Azure%20SQL%20MI%20or%20SQL%20Server%20on%20Azure%20VM.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWe%20believe%20that%20this%20new%20migration%20experience%20will%20empower%20you%20to%20successfully%20complete%20your%20database%20migrations%20to%20Azure%20SQL%20and%20in%20turn%20deliver%20greater%20business%20outcomes.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3C%2FP%3E%3CDIV%20class%3D%22video-embed-center%20video-embed%22%3E%3CIFRAME%20class%3D%22embedly-embed%22%20src%3D%22https%3A%2F%2Fcdn.embedly.com%2Fwidgets%2Fmedia.html%3Fsrc%3Dhttps%253A%252F%252Fwww.youtube.com%252Fembed%252FQuh8Ge3y3X0%253Ffeature%253Doembed%26amp%3Bdisplay_name%3DYouTube%26amp%3Burl%3Dhttps%253A%252F%252Fwww.youtube.com%252Fwatch%253Fv%253DQuh8Ge3y3X0%26amp%3Bimage%3Dhttps%253A%252F%252Fi.ytimg.com%252Fvi%252FQuh8Ge3y3X0%252Fhqdefault.jpg%26amp%3Bkey%3Dfad07bfa4bd747d3bdea27e17b533c0e%26amp%3Btype%3Dtext%252Fhtml%26amp%3Bschema%3Dyoutube%22%20width%3D%22200%22%20height%3D%22112%22%20scrolling%3D%22no%22%20title%3D%22YouTube%20embed%22%20frameborder%3D%220%22%20allow%3D%22autoplay%3B%20fullscreen%22%20allowfullscreen%3D%22true%22%3E%3C%2FIFRAME%3E%3C%2FDIV%3E%3CP%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3ETo%20learn%20more%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%20data-leveltext%3D%22-%22%20data-font%3D%22Calibri%22%20data-listid%3D%226%22%20aria-setsize%3D%22-1%22%20data-aria-posinset%3D%221%22%20data-aria-level%3D%221%22%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%3CSPAN%3EGet%20started%20with%20the%3C%2FSPAN%3E%3CSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Faka.ms%2Fazuresqlmigrationextension%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%3CSPAN%20data-contrast%3D%22none%22%3E%3CSPAN%20data-ccp-charstyle%3D%22Hyperlink%22%3EAzure%20SQL%20Migration%20extension%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%3CSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Ein%20Azure%20Data%20Studio%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B134233279%26quot%3B%3Atrue%2C%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%20data-leveltext%3D%22-%22%20data-font%3D%22Calibri%22%20data-listid%3D%226%22%20aria-setsize%3D%22-1%22%20data-aria-posinset%3D%221%22%20data-aria-level%3D%221%22%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B134233279%26quot%3B%3Atrue%2C%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3ERead%20how%20to%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fdms%2Fmigration-using-azure-data-studio%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Emigrate%20databases%20with%20Azure%20Data%20Studio%3C%2FA%3E%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%20data-leveltext%3D%22-%22%20data-font%3D%22Calibri%22%20data-listid%3D%226%22%20aria-setsize%3D%22-1%22%20data-aria-posinset%3D%223%22%20data-aria-level%3D%221%22%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%3CSPAN%3EWatch%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fyoutu.be%2FQuh8Ge3y3X0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3E%3CSPAN%20data-contrast%3D%22none%22%3E%3CSPAN%20data-ccp-charstyle%3D%22Hyperlink%22%3EGetting%20started%20with%20Azure%20SQL%20readiness%20assessments%20and%20migrations%20fro%3C%2FSPAN%3E%3CSPAN%20data-ccp-charstyle%3D%22Hyperlink%22%3Em%20Azure%20Data%20Studio%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B134233279%26quot%3B%3Atrue%2C%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%20data-leveltext%3D%22-%22%20data-font%3D%22Calibri%22%20data-listid%3D%226%22%20aria-setsize%3D%22-1%22%20data-aria-posinset%3D%224%22%20data-aria-level%3D%221%22%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%3CSPAN%3EVisit%20the%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Faka.ms%2Fdatamigration%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%3CSPAN%20data-contrast%3D%22none%22%3E%3CSPAN%20data-ccp-charstyle%3D%22Hyperlink%22%3Edata%20migration%20guides%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%3CSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Ehub%20for%20documentation%20on%20various%20database%20migrations%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B134233279%26quot%3B%3Atrue%2C%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FLI%3E%0A%3C%2FUL%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-2703295%22%20slang%3D%22en-US%22%3E%3CP%3EUse%20the%20Azure%20SQL%20Migration%20extension%20for%20Azure%20Data%20Studio%20to%20migrate%20to%20either%20Azure%20SQL%20Managed%20Instance%20(Platform-as-a-Service)%20or%20to%20SQL%20Server%20on%20Azure%20Virtual%20Machines%20(Infrastructure-as-a-Service).%20As%20part%20of%20this%20Public%20Preview%20announcement%2C%20the%20extension%20will%20support%20migrations%20for%20both%20online%20(for%20migrations%20that%20require%20minimal%20downtime)%20and%20offline%20(for%20migrations%20where%20downtime%20persists%20through%20the%20duration%20of%20the%20migration)%20modes%20that%20suit%20the%20requirements%20of%20various%20applications.%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2703295%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20SQL%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAzure%20SQL%20Managed%20Instance%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESQL%20Server%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESQL%20Server%20on%20Azure%20VMs%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Version history
Last update:
‎Sep 01 2021 08:14 AM
Updated by: