Migrating SQL Database On-Premise to Azure SQL Database through SSMS

In this video, I will provide the complete details of database migration from on-premise to Azure SQL Database using SSMS.
WhatsApp channel: whatsapp.com/channel/0029VaAA...
Join the group: t.me/sqlbrainbox
Book 1:1 Call: topmate.io/nirav_gandhi
Follow me on LinkedIn: / niravgandhisql
Azure SQL DBA Videos: • Free Azure SQL DBA Tra...
Create an Azure Account: azure.microsoft.com/en-in/free/
Azure Document:docs.microsoft.com/en-in/azur...
#azuresql #sql

[@juturvenkat7784]

Impressed nirav, nice content as a DBA it helps a lot to move to azure & get job .. Great job nirav

[@Niravgandhi]

Thank you very much

[@wanderson34456]

Wow! Top, Tk!

[@Niravgandhi]

Please share the link to your connection

[@sanjaykumawat8034]

Thanks

[@venkateshkurnool6124]

Excellent

[@Niravgandhi]

Thanks

[@RajeshNayak-pn3bv]

good explaination,can u make a video on sql server onpremise migration to azure

[@LuvxJacqu4li8e]

Very nice and done completely. Thanks

[@Niravgandhi]

Thank you too!

[@Arnav.v]

Getting connection timeout expired error ☹️

[@marketbytesofficial1028]

Where should we install the DMA? Can we install it on the same sql server or any dedicated VM which is on the same network?

[@Niravgandhi]

yes

[@justahuman2153]

Thank you. Can we get a new video on how to migrate Sql server on Azure VM to Azure Sql managed instances

[@Niravgandhi]

Sure.

[@gocrow23]

This is SQL Server Mgmt Studio. What If a On-prem VM (with MySQL on it) is migrated to IAAS on cloud then is there a way to Discover & configure MYSQL Instance. I know it's possible for SQL Server to be discovered & configured but not sure same is possible with MySQL, will it give error during discovery that it's not having compatible version of SQL instance?

[@Niravgandhi]

I don't have any idea

[@gocrow23]

@@Niravgandhi Thanks for the answer. If you try POC then please let know.

[@saurabhwaghmare393]

0:08 you said you have already discussed migration steps in the last video... Which is not present in the playlist.

[@Niravgandhi]

let me check

[@abdulkhan1310]

Is this possible if we want to migrate to Synapse Dedicated SQL Pool?

[@Niravgandhi]

No idea

[@Promesses]

Thanks. Does it work for big volume ?

[@Niravgandhi]

Yes it does

[@srinibassaho]

What permission is required on Azure SQL to migrate from On-prem using DMA

[@Niravgandhi]

Admin or sys admin

[@srinibassaho]

@@Niravgandhi thank you for your response. I believe Sysadmin is not supported on Azure SQL? Can we use Db manager and login manager instead of Sysadmin?

[@niravgandhi8160]

For DB manager for azure SQL

[@josef5636]

Can it really be this simple? I hope so xd gonna try it tomorrow :)

[@Niravgandhi]

Thanks

[@cjsalda]

and the data ?? who migrate only the schemas?

[@Niravgandhi]

Plz provide more details

[@viveksavani5713]

Is it migrated with data?

[@Niravgandhi]

Yes

[@kousarjamadar7339]

In need personal training for azure

[@Niravgandhi]

I m not providing

[@ujayp4695]

Dude hope you provide correct info . Compatibility has nothing to do with linked server and email. Please refer Microsoft compatibility

[@Niravgandhi]

Please provide more details