If we are going to restore database from backup files why DMS Service needs access to my on premise database? (note that those databases are often hided behind firewalls and VPNs)
Yes, per the prerequisites called out in the SQL to Azure SQL Database online tutorial here: docs.microsoft.com/azure/dms/tutorial-sql-server-azure-sql-online
And there is something fishy here ... look at those SQL scripts: initial backup is from "HRMinDowntime" databases and additional transaction log backups are from "AdventureWorks2012" database?!?!?
Be sure to check out the step-by-step information provided in the tutorial for migrating SQL to Azure SQL Database online (docs.microsoft.com/azure/dms/tutorial-sql-server-azure-sql-online) - it is possible that the different segments of the video were created using different source databases. Please check the tutorial for more specific guidance, and let us know if you still have questions by contacting the Azure DMS Feedback alias (dmsfeedback@microsoft.com). Thanks!
Is that is possible to DMA tool to migrate the database on-prime to azure MI
Does the MI need to be in the business-critical tier to do this kind of migration? If yes, what are my options for the General purpose tier?
Hi Raj, can we migrate real-time data within seconds from Oracle in prem to azure Postgres instance.
If we are going to restore database from backup files why DMS Service needs access to my on premise database? (note that those databases are often hided behind firewalls and VPNs)
Yes, per the prerequisites called out in the SQL to Azure SQL Database online tutorial here: docs.microsoft.com/azure/dms/tutorial-sql-server-azure-sql-online
And there is something fishy here ... look at those SQL scripts: initial backup is from "HRMinDowntime" databases and additional transaction log backups are from "AdventureWorks2012" database?!?!?
The video walks through the SQL to Azure SQL Database tutorial using the AdventureWorks2012 database as a sample.
Be sure to check out the step-by-step information provided in the tutorial for migrating SQL to Azure SQL Database online (docs.microsoft.com/azure/dms/tutorial-sql-server-azure-sql-online) - it is possible that the different segments of the video were created using different source databases. Please check the tutorial for more specific guidance, and let us know if you still have questions by contacting the Azure DMS Feedback alias (dmsfeedback@microsoft.com). Thanks!