Import MySQL db into MS Azure

Question

I want to import a MySQL schema into a db in Microsoft Azure, I have read I need to have the file with the schema in BACPAC format, after that the file can be uploaded and imported in MS Azure.

How can a .sql file be converted into BACPAC format?

you may be able to import it to azure using php msdn.microsoft.com/en-us/library/windowsazure/ff394110.aspx — user2319961
– user2319961, Commented May 16, 2013 at 10:06

Community · Accepted Answer · 2020-06-20 09:12:55Z

3

I typed mysql to azure into Google and found this:

Migrating from MySQL to SQL Azure Using SSMA

In this blog post, I will describe how to setup your trial SQL Azure account for your migration project, create a “free” database on SQL Azure and walkthrough differences in the process of using SSMA to migrate the tables from the MySQL Sakila sample database to SQL Azure.

...

...

You can download Microsoft SQL Server Migration Assistant for MySQL from here.

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered May 16, 2013 at 10:05

ta.speot.is

27.2k8 gold badges71 silver badges98 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Rafael Over a year ago

But if my web application is accessing MySQL at the moment, then it won't work on Azure, as now the db has been converted to SQL Server

Bloke Over a year ago

Savior! If you don't get it to work at first, right click on your MySQL database and "Convert Schema". You'll see a new schema in the SQL Azure database -- right click and "Synchronize with Database". Then back up to MySQL database to right click on it and "Migrate Data" :))

Collectives™ on Stack Overflow

Import MySQL db into MS Azure

1 Answer 1

Migrating from MySQL to SQL Azure Using SSMA

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Migrating from MySQL to SQL Azure Using SSMA

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related