MySQL to Azure SQL through CSV file

Question

If I export a MySQL table into a .csv file, is there any extra work needed to now push this .csv file onto an Azure SQL database?

Bruce Chen · Accepted Answer · 2017-06-08 06:57:02Z

2

is there any extra work needed to now push this .csv file onto an Azure SQL database?

For flat CSV file, you could create the destination table in your Azure SQL Database first, then use the bcp command-line utility for importing data from a CSV file into your Azure SQL Database. For more details, you could refer to Load data from CSV into Azure SQL Database.

Additionally, you could migrate your MySQL database objects to SQL Azure, then migrate the data to SQL Azure. For more details, you could refer to the following tutorials:

Migrating MySQL Databases to SQL Server - Azure SQL DB

Migrating MySQL Data into SQL Server - Azure SQL DB

answered Jun 8, 2017 at 6:57

Bruce Chen

18.4k2 gold badges23 silver badges35 bronze badges

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

1 Comment

Barney Chambers Over a year ago

Thanks Bruce, this is a great answer

Adam Marczak · Accepted Answer · 2019-08-02 15:40:50Z

0

You can also and upload results into blob storage and use natively built in BCP in Azure SQL to pull the data.

Here is example on how to do it https://marczak.io/posts/azure-loading-csv-to-sql/

Alternatively you can easily load data from blob storage into database using Azure data Factory, you can example find here: https://azure4everyone.com/posts/2019/07/data-factory-intro/

edited Aug 2, 2019 at 15:40

answered Aug 2, 2019 at 15:30

Adam Marczak

2,35111 silver badges20 bronze badges

Collectives™ on Stack Overflow

MySQL to Azure SQL through CSV file

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related