从MS SQL导入数据到MySQL

问题描述:

我想从MS SQL Server导入数据,通过某种正则表达式运行它来过滤掉东西,并将其导入到MySQL中。那么,对于每个查询,我希望从第三个数据库显示一个相关的图像。

I want to import data from MS SQL Server, run it through some sort of regexp to filter out stuff, and import it into MySQL. I then, for each query, wish to display a relevant image from a third database. What would be the easiest way to do this, importing and linking wise?

谢谢。

澄清:这是最简单的方法,导入和链接明智?它是一个php应用程序来过滤来自另一个数据库的数据,然后每个记录显示一个来自第三个数据库的关联图像。这是从头开始的。

Clarification: It is a php application to filter data from another database, and then for each record show an associated image from a 3rd database. It is from scratch...

你可以尝试MySQL Migration Toolkit。
http://dev.mysql.com/downloads/gui- tools / 5.0.html

You can try the MySQL Migration Toolkit. http://dev.mysql.com/downloads/gui-tools/5.0.html

现在存档在 http://downloads.mysql.com/archives.php?p=mysql-migration-toolkit