Export SQL Server database from MySQL import [closed]

Question

Closed. This question is not about programming or software development. It is not currently accepting answers.

This question does not appear to be about a specific programming problem, a software algorithm, or software tools primarily used by programmers. If you believe the question would be on-topic on another Stack Exchange site, you can leave a comment to explain where the question may be able to be answered.

Closed 5 months ago.

Improve this question

I have .net script access to a microsoft server and I need to synch the database on this end with a LAMP server on the other end. Currently I've written my own CSV export routine, and a matching importer, but it's creaking under the strain. Is there a more efficient way to go about this? Can I stream a CSV export direct to IIS somehow?

I know that if I had more privileges, I could run a BACKUP DATABASE command, then run the backup to the other server with FTP and hopefully find some way to import this into MySQL. However this is not an option.

Could you explain why @ta.speot.is's proposed answer is not acceptable to you? Could you explain what privileges you do have? — eggyal
– eggyal, Commented May 15, 2012 at 16:46
@eggyal I have limited FTP access and the ability to upload .aspx.vb scripts. — Darth Egregious
– Darth Egregious, Commented May 15, 2012 at 18:59
You wont be able to restore a MSSQL Backup on a MySQL system. So that thought is out of the question. You might be able to run a MySQL backup to some extent on a MSSQL backup but it will require you to edit the backup script. — Namphibian
– Namphibian, Commented May 17, 2012 at 9:18

ta.speot.is · Accepted Answer · 2012-03-22 21:03:58Z

5

If MySQL is accessible from the MSSQL server then you can create a linked server within MSSQL and MERGE, INSERT, UPDATE or whatever into MySQL's tables from within MSSQL.

answered Mar 22, 2012 at 21:03

ta.speot.is

27.2k8 gold badges71 silver badges98 bronze badges

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

Comments

somnath · Accepted Answer · 2012-05-18 06:46:24Z

4

You can code a script that has .NET DataReaders to open cursors on MS SQL and then using another connection that is connected to MySQL insert the data row by row. You can process all the tables sequentially.

answered May 18, 2012 at 6:46

somnath

1,3351 gold badge9 silver badges13 bronze badges

Comments

Namphibian · Accepted Answer · 2012-05-22 07:18:31Z

4

+25

I have done something similar. The easiest way would be to have a direct connection between your MSSQL server and MySQL server. You setup a linked server in MSSQL to the MySQL server and then use insert,update etc to do transactions to the Linked server. This is what ta.speot.is mentioned in his answer. However you dont have a direct link to the MySQL server so that option is not viable.

The other option would be to use MSSQL Service broker. With service broker you could queue individual updates, deletes and inserts to a webservice. This webservice could be hosted on IIS. The webservice would get called from the queue and then you can apply the individual transactions one at a time to the MySQL database. Service broker is a asynchronous messaging system embedded inside MSSQL 2005+. With it you can send messages to other servers, databases and even external services.

Just keep in mind the Service Broker architecture takes time to learn and implement. I have created custom replication architecture between mssql and mysql using service broker that handle 88 million plus transaction a day on a celeron laptop. It just took some serious elbow grease.

UPDATE Seems like SQL2008 allows you to run Service Brokers outside of SQL server in some way. See this link http://blogs.msdn.com/b/sql_service_broker/archive/2008/11/21/announcing-service-broker-external-activator.aspx I dont know if this might be more up your street.

edited May 22, 2012 at 7:18

answered May 17, 2012 at 9:28

Namphibian

12.3k8 gold badges50 silver badges77 bronze badges

4 Comments

Darth Egregious Over a year ago

Can you set up a service broker through .net?

Namphibian Over a year ago

No service broker is all SQL. You would need to do it on the MSSQL server.

Darth Egregious Over a year ago

No dice for me then. Thanks for the interesting answer though.

Namphibian Over a year ago

Could you add some detail to the question? I am sure there must be a way to help you. Just the details are on the sketchy side.

Konstantin Pereiaslov · Accepted Answer · 2012-05-22 00:58:23Z

3

Instead of CSV-files generate SQL-scripts suitable to run on MySQL server

answered May 22, 2012 at 0:58

Konstantin Pereiaslov

1,8241 gold badge20 silver badges29 bronze badges

Comments

RicardoE · Accepted Answer · 2012-05-22 09:50:52Z

0

I dont know if this will help, but a long time ago I created a small software to do this particular task with a large dataset, here it is:

http://csvimporter.codeplex.com/

I made it open source :)

Hope it helps.

answered May 22, 2012 at 9:50

RicardoE

1,7356 gold badges24 silver badges42 bronze badges

Collectives™ on Stack Overflow

Export SQL Server database from MySQL import [closed]

5 Answers 5

Comments

Comments

4 Comments

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

4 Comments

Comments

Comments

Related