Migrating to SQL: Discover and Assess SQL Server Data Estate Migrating to Azure SQL (Ep. 2)

Published 05-11-2021 09:00 AM 685 Views
Microsoft

Understand the various cloud migration drivers, migration strategies, and various phases in the migration journey in this episode of Data Exposed with Venkata Raj Pochiraju. He'll also introduce various database migration tools and services that Microsoft builds to help you in the migration journey.

Watch on Data Exposed


Resources:

View/share our latest episodes on Channel 9 and YouTube!
4 Comments
Senior Member

Thank you @MarisaBrasile , I'm a huge fun of your channel and I like how Anna and Raj are capable of delivery the content. 

However there is one scenario that is not clear to me: can we use Azure Migrate to Discover and Assess an Azure VM estate? 

 

In fact most of the company "Lift & Shift" and then they need to extract the databases from the Azure VMs and put them in Azure SQL Database or MI or just stay there where they are. Such very common scenario is never mentioned. I have also raised a question on your official documentation and Vineet Vikram replied that Azure Migrate is not meant to do that. 

This is a paradox. How can Azure Migrate help you Discover and Assess "AWS, GCP, Xen, etc..." but not Azure VM?

 

What alternative tool Microsoft propose? 

(MAP Toolkit stats to be oldish )

The latest Azure Migrate discovery and assessment of SQL Servers are supported only SQL Servers running on VMware platform, the support for physical, hyper-V and Azure VMs will come soon.  I don't have exact dates yet.

Meanwhile continue to use DMA tool, upload the data to Azure Migrate to the consolidated report, that process is provided below.

 

Assess SQL Server readiness to migrate to Azure SQL Database - Data Migration Assistant | Microsoft ...

Thnaks

Raj

 

Senior Member

Hi @Venkata Raj Pochiraju and thank you for your reply. 

 

I had a look at the link you sent me. 

As far as I know "Azure Migrate discovery and assessment" is the only way that will allows me to consolidate the assessment and have a cost forecast. Uploading the assessment through the DMA tool will not provide any cost forecast, right? 

 

Does this link is an official Microsoft resource? 

Is there any other way to calculate cost forecast of the databases before migration?

Hello, 

The link you provided DTU calculator is outdated,  while we innovated the cost estimates of SQL Servers migrating to Azure SQL in Azure Migrate service end to end, this is only available for SQL Servers running on VMware.  To get the same results for SQL Servers on physicals servers or any other platforms, please contact us at dmsfeedback@microsoft.com that we can share you the console application that you can to get unblocked for now.

Thanks

raj

%3CLINGO-SUB%20id%3D%22lingo-sub-2342158%22%20slang%3D%22en-US%22%3EMigrating%20to%20SQL%3A%20Discover%20and%20Assess%20SQL%20Server%20Data%20Estate%20Migrating%20to%20Azure%20SQL%20(Ep.%202)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2342158%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EUnderstand%20the%20various%20cloud%20migration%20drivers%2C%20migration%20strategies%2C%20and%20various%20phases%20in%20the%20migration%20journey%20in%20this%20episode%20of%20Data%20Exposed%20with%20Venkata%20Raj%20Pochiraju.%20He'll%20also%20introduce%20various%20database%20migration%20tools%20and%20services%20that%20Microsoft%20builds%20to%20help%20you%20in%20the%20migration%20journey.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E%3CFONT%20size%3D%225%22%3E%3CA%20href%3D%22https%3A%2F%2Fyoutu.be%2F0uek-0cG6bo%3FWT.mc_id%3Ddataexposed-c9-niner%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EWatch%20on%20Data%20Exposed%3C%2FA%3E%3C%2FFONT%3E%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CDIV%3E%3CEM%3E%3CBR%20%2F%3EResources%3A%3C%2FEM%3E%3C%2FDIV%3E%0A%3CDIV%3E%0A%3CDIV%3E%3CA%20href%3D%22http%3A%2F%2Faka.ms%2Fdatamigration%3FWT.mc_id%3Ddataexposed-c9-niner%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EDatabase%20Migration%20guide%3C%2FA%3E%3CBR%20%2F%3E%3CA%20href%3D%22http%3A%2F%2Faka.ms%2FAzureMigrate%3FWT.mc_id%3Ddataexposed-c9-niner%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EAzure%20Migrate%3C%2FA%3E%3C%2FDIV%3E%0A%3CDIV%3E%3CA%20href%3D%22https%3A%2F%2Faka.ms%2FAzureMigrate_SQLDiscovery%3FWT.mc_id%3Ddataexposed-c9-niner%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ETutorial%3A%20Discover%20servers%20running%20in%20VMware%20environment%20with%20Azure%20Migrate%3C%2FA%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Faka.ms%2FAzureMigrate_SQLAssessment%3FWT.mc_id%3Ddataexposed-c9-niner%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ETutorial%3A%20Assess%20SQL%20instances%20for%20migration%20to%20Azure%20SQL%3C%2FA%3E%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3CDIV%3E%3CBR%20%2F%3E%3CSPAN%3EView%2Fshare%20our%20latest%26nbsp%3Bepisodes%20on%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fchannel9.msdn.com%2FShows%2FData-Exposed%3FWT.mc_id%3Ddataexposed-c9-niner%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EChannel%209%3C%2FA%3E%3CSPAN%3E%26nbsp%3Band%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fplaylist%3Flist%3DPLlrxD0HtieHieV7Jls72yFPSKyGqycbZR%26amp%3BWT.mc_id%3Ddataexposed-c9-niner%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EYouTube%3C%2FA%3E%3CSPAN%3E!%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-2342158%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22MSDataExposed.jpg%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F202729i490928FF0C962B7B%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22MSDataExposed.jpg%22%20alt%3D%22MSDataExposed.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EIn%20the%20second%20episode%20of%20the%20Migrating%20to%20SQL%20series%2C%20learn%20how%20Azure%20Migrate%20is%20your%20one-stop-shop%20to%20migrating%20to%20Azure%20SQL.%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2342158%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20SQL%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2347860%22%20slang%3D%22en-US%22%3ERe%3A%20Migrating%20to%20SQL%3A%20Discover%20and%20Assess%20SQL%20Server%20Data%20Estate%20Migrating%20to%20Azure%20SQL%20(Ep.%202)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2347860%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F668326%22%20target%3D%22_blank%22%3E%40MarisaBrasile%3C%2FA%3E%26nbsp%3B%2C%20I'm%20a%20huge%20fun%20of%20your%20channel%20and%20I%20like%20how%20Anna%20and%20Raj%20are%20capable%20of%20delivery%20the%20content.%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%20there%20is%20one%20scenario%20that%20is%20not%20clear%20to%20me%3A%20%3CSTRONG%3Ecan%20we%20use%20Azure%20Migrate%20to%26nbsp%3BDiscover%20and%20Assess%20an%20Azure%20VM%20estate%3F%3C%2FSTRONG%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20fact%20most%20of%20the%20company%20%22Lift%20%26amp%3B%20Shift%22%20and%20then%20they%20need%20to%20extract%20the%20databases%20from%20the%20Azure%20VMs%20and%20put%20them%20in%20Azure%20SQL%20Database%20or%20MI%20or%20just%20stay%20there%20where%20they%20are.%26nbsp%3BSuch%20very%20common%20scenario%20is%20never%20mentioned.%20I%20have%20also%20raised%20a%20question%20on%20your%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoftDocs%2Fazure-docs%2Fissues%2F75114%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3Eofficial%20documentation%3C%2FA%3E%20and%26nbsp%3B%3CSPAN%20class%3D%22p-name%20vcard-fullname%20d-block%20overflow-hidden%22%3EVineet%20Vikram%20replied%20that%20Azure%20Migrate%20is%20not%20meant%20to%20do%20that.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThis%20is%20a%20paradox.%20How%20can%20Azure%20Migrate%20help%20you%26nbsp%3BDiscover%20and%20Assess%20%22AWS%2C%20GCP%2C%20Xen%2C%20etc...%22%20but%20not%20Azure%20VM%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20alternative%20tool%20Microsoft%20propose%3F%26nbsp%3B%3C%2FP%3E%3CP%3E(%3CA%20href%3D%22https%3A%2F%2Fwww.microsoft.com%2Fen-us%2Fdownload%2Fdetails.aspx%3Fid%3D7826%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EMAP%20Toolkit%3C%2FA%3E%20stats%20to%20be%20oldish%20)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2350224%22%20slang%3D%22en-US%22%3ERe%3A%20Migrating%20to%20SQL%3A%20Discover%20and%20Assess%20SQL%20Server%20Data%20Estate%20Migrating%20to%20Azure%20SQL%20(Ep.%202)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2350224%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20latest%20Azure%20Migrate%20discovery%20and%20assessment%20of%20SQL%20Servers%20are%20supported%20only%20SQL%20Servers%20running%20on%20VMware%20platform%2C%20the%20support%20for%20physical%2C%20hyper-V%20and%20Azure%20VMs%20will%20come%20soon.%26nbsp%3B%20I%20don't%20have%20exact%20dates%20yet.%3C%2FP%3E%0A%3CP%3EMeanwhile%20continue%20to%20use%20DMA%20tool%2C%20upload%20the%20data%20to%20Azure%20Migrate%20to%20the%20consolidated%20report%2C%20that%20process%20is%20provided%20below.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Fdma%2Fdma-assess-sql-data-estate-to-sqldb%3Fview%3Dsql-server-ver15%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EAssess%20SQL%20Server%20readiness%20to%20migrate%20to%20Azure%20SQL%20Database%20-%20Data%20Migration%20Assistant%20%7C%20Microsoft%20Docs%3C%2FA%3E%3C%2FP%3E%0A%3CP%3EThnaks%3C%2FP%3E%0A%3CP%3ERaj%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Co-Authors
Version history
Last update:
‎May 10 2021 11:59 AM
Updated by: