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

[@raimca1]

thanks for the demo.

[@Niravgandhi]

Our pleasure!

[@ramanathk695]

Excellent, thanks for the clean demo

[@Niravgandhi]

Thanks

[@wanderson34456]

Wow! Top, Tk!

[@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?

[@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

[@beautytipswithsujata]

Oracle to postgraasql can we use migration tool DMA

[@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.

[@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.

[@superiorproducts524]

Thanks. Is downtime required on this type of migration?

[@Niravgandhi]

Minimum downtime

[@DbaAbhijathya]

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