Share via

What Azure platform would support a direct import of an .mdf file?

Don C 0 Reputation points
2023-03-14T21:03:37.94+00:00

We have a state supplied 1.6gb .mdf file that we are trying to create an Azure DB from. What platform will allow us to do this? We currently have a Azure Database for MySQL flexible server, but a method to import the .mdf is not jumping out at us.

Thanks!

Don

Azure SQL Database
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
986 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Oury Ba-MSFT 20,911 Reputation points Microsoft Employee Moderator
    2023-03-16T20:33:14.62+00:00

    Don C Just checking if you still need assistance on this as you did not respond to my previous comment.

    I am assuming that you are trying to migrate your 1.6 gb mdf file to a database in the cloud. Please let me know if my understanding is correct.

    Please see my suggestion below.

    1. If what you are looking for is to migrate an on-premises to Azure SQL Database, check DMSv2 documentation. The tutorial for this scenario can be found here: https://learn.microsoft.com/en-us/azure/dms/tutorial-sql-server-azure-sql-database-offline-ads
    2. If you are looking to migrate to your Azure MYSQL Flexible server that you mentioned above, you can check this tutorial for this scenario use Migrate large databases to Azure Database for MySQL using mydumper/myloader.

    Please let me know if that helps.

    Regards,

    Oury

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.