CODEWITHSUNDEEP
sqlmysqlsql-serverdatabase-design
Josh2038
Josh2038

Reputation:

Importing data to MySQL from MS SQL

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?

Thank you.

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...

Upvotes: 2

Views: 28996

Answers (3)

Node
Node

Reputation: 22315

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

Now archived at http://downloads.mysql.com/archives.php?p=mysql-migration-toolkit

Upvotes: 2

Shawn
Shawn

Reputation: 19793

I would use the Microsoft SQL Server Data Publishing Wizard (free). You can use it to script your entire database (including insert statements.) You'll have to edit this script a little bit probably to get it to run in MySQL. Now you just have a regex problem. You can try:

  • Manipulating the data in MS SQL via a query, or from code (using regex) the transfer.
  • Running your regexes on the script file itself, maybe try some macros, find and replace, etc.
  • Manipulating the data in MySQL via a query, or from code (using regex) after the transfer.

Upvotes: 0

ChrisLively
ChrisLively

Reputation: 88044

use SQL Management Studio (or Enterprise Manager depending on version) with the SQL Server import wizerd to get it into MS SQL.

From there you can export it to Mysql using the MySQL connector drivers.

As for as displaying an image from a third database, that is completely up to the code you have written in your application.

Upvotes: 1

Related Questions