从MS SQL导入数据到MySQL [英] Importing data to MySQL from MS SQL

问题描述

我想从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

这篇关于从MS SQL导入数据到MySQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！