-3

I have a .Net console application that extracts data from webapi and fill 5 tables on a MS SQL Server database.

Now I have to export these tables to a MySql Database. How can I do that in an easy way?

The Console Application is coded with Visual Studio 2015 (C#).

Is it possible to use LinqToSql on a MySql Database ?

Or is it possible to use MySql as Destination Server on Microsoft Integration Service ?

Thanks

Improve this question
1

1 Answer 1

Reset to default
-2

I Solved the problem by editing the .Net Console application in order to implement a loop-insert in MySql Database using MySql.Data.MySqlClient.

It is not fast for big data loading but it works properly.

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

4 Comments

"It's not fast" is a serious problem when talking about databases. You should check how bulk loading works on MySQL instead. Check LOAD DATA INFILE. SSIS is also a good option, certainly better than writing your own console program. You could transfer data directly from a SQL Server source to a MySQL destination, and perform transformations
I agree, but SSIS is not present in my environment. The only thing I can use is a console application.
Are you sure? The Export Wizard in SSMS actually generates SSIS packages that can be scheduled for execution.
Anyway, you can export the data to a file that can be used with LOAD DATA statement or mysqlimport.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.