Migrating SQL Database On-Premise to Azure SQL Database using Data Migration Assistant (DMA)

In this video, I will provide the complete details of database migration from on-premise to Azure SQL Database using SSMS.
Join the group: t.me/sqlbrainbox
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

[@wanderson34456]

Wow! Top, Tk!

[@Niravgandhi]

Thanks

[@ramanathk695]

Excellent, thanks for the clean demo

[@Niravgandhi]

Thanks

[@carlosjaundoo3188]

HI. does this migration tool provide a clone of the databases from the server side to azure or does it forklift the data leaving the source server empty?

[@beautytipswithsujata]

Oracle to postgraasql can we use migration tool DMA

[@nagaraju116]

How to know if any failure at the time of schema migration? and how to perform from that point again instead of whole through DMA

[@Niravgandhi]

You will get an error message, you have to perform action from beginning

[@pp3644]

Hi Nirav, Nice video , Thanks. what if we want to migrate entire SQL Server from on-prem to Azure VM?

[@Niravgandhi]

for sql on prem to azure VM, direct take backup and restore or create Always on between 2 servers and do it.

[@superiorproducts524]

Thanks. Is downtime required on this type of migration?

[@Niravgandhi]

Minimum downtime

[@sp0852]

Hi sir, I am getting Error SQL71501: Error validating element [dbo].[vwname]: View: [dbo].[Vwname] contains an unresolved reference to an object. Either the object does not exist or the reference is ambiguous because it could refer to any of the following objects: [dbo].[tablename].[columname]. Kindly advise, thank you.

[@Niravgandhi]

Some issue on view created by you

[@sp0852]

​@@Niravgandhithank you for the response, no issue with the view sir, same database is restoring without any issue in local sqlservers. This issue arise when deploying in azure sql database. If I comment the function in view then no issues.but this function is required to retrieve some values and display in view. Please advise.

[@user-ee9pi2ln4n]

What will be the username and password?

[@Niravgandhi]

Not getting you

[@beautytipswithsujata]

Where I can see ur email id

[@Niravgandhi]

You can go about the section, you will get it