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
Пікірлер: 38
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
Wow! Top, Tk!
@Niravgandhi
2 ай бұрын
Please share the link to your connection
Thanks
Excellent
@Niravgandhi
Жыл бұрын
Thanks
good explaination,can u make a video on sql server onpremise migration to azure
Very nice and done completely. Thanks
@Niravgandhi
Жыл бұрын
Thank you too!
Getting connection timeout expired error ☹️
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
Thank you. Can we get a new video on how to migrate Sql server on Azure VM to Azure Sql managed instances
@Niravgandhi
6 ай бұрын
Sure.
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.
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
Is this possible if we want to migrate to Synapse Dedicated SQL Pool?
@Niravgandhi
Жыл бұрын
No idea
Thanks. Does it work for big volume ?
@Niravgandhi
6 ай бұрын
Yes it does
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
Can it really be this simple? I hope so xd gonna try it tomorrow :)
@Niravgandhi
4 ай бұрын
Thanks
and the data ?? who migrate only the schemas?
@Niravgandhi
Ай бұрын
Plz provide more details
Is it migrated with data?
@Niravgandhi
Жыл бұрын
Yes
In need personal training for azure
@Niravgandhi
5 ай бұрын
I m not providing
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