Move data from SQL Server/PostgreSQL to MySQL

Question

There is a scenario, I have a SQL Server with tones of data in it. I need to copy certain fields from certain tables (hardly ever the whole table) to another server which runs MySQL. Also there is another server with PostgreSQL. I need to do the same thing with it. Is there any know way to accomplish that?

Thank you in advance!

Maybe this other post might help you: [How to export data from SQL Server 2005 to MySQL][1] [1]: http://stackoverflow.com/questions/129/how-to-export-data-from-sql-server-2005-to-mysql Best Ragards — BizApps, Jan 26 '12 at 23:58
BizApps, I believe that post is for moving the whole database, isn't it? — Nikita Silverstruk, Jan 27 '12 at 19:21

score 1 · Accepted Answer · answered Jan 26 '12 at 23:53

1

I don't remember how flexible was the sql server exporting service, but it sounds you need a custom script to do it.

answered Jan 26 '12 at 23:53

ppk

568
1
7
20

Thats what I was thinking about but was still wondering if there is any kind of solution... – Nikita Silverstruk Jan 27 '12 at 19:22

Move data from SQL Server/PostgreSQL to MySQL

1 Answers1