Migrating SQL Database On-Premise to Azure SQL Database through SSMS
Vložit
- čas přidán 6. 09. 2024
- 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/c...
Join the group: t.me/sqlbrainbox
Book 1:1 Call: topmate.io/nir...
Follow me on LinkedIn: / niravgandhisql
Azure SQL DBA Videos: • Free Azure SQL DBA Tra...
Create an Azure Account: azure.microsof...
Azure Document:docs.microsoft...
#azuresql #sql
Impressed nirav, nice content as a DBA it helps a lot to move to azure & get job ..
Great job nirav
Thank you very much
good explaination,can u make a video on sql server onpremise migration to azure
Wow! Top, Tk!
Please share the link to your connection
Thanks
Thank you. Can we get a new video on how to migrate Sql server on Azure VM to Azure Sql managed instances
Sure.
0:08 you said you have already discussed migration steps in the last video... Which is not present in the playlist.
let me check
Can it really be this simple? I hope so xd gonna try it tomorrow :)
Thanks
Excellent
Thanks
What permission is required on Azure SQL to migrate from On-prem using DMA
Admin or sys admin
@@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?
For DB manager for azure SQL
Getting connection timeout expired error ☹️
Dude hope you provide correct info .
Compatibility has nothing to do with linked server and email.
Please refer Microsoft compatibility
Please provide more details
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?
I don't have any idea
@@Niravgandhi Thanks for the answer. If you try POC then please let know.
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?
yes
and the data ?? who migrate only the schemas?
Plz provide more details
Is this possible if we want to migrate to Synapse Dedicated SQL Pool?
No idea
Very nice and done completely. Thanks
Thank you too!
Is it migrated with data?
Yes
Thanks.
Does it work for big volume ?
Yes it does
In need personal training for azure
I m not providing