Importing data to MySQL from MS SQL?

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

Up vote 1 down vote favorite share g+ share fb share tw.

I want to import data from mssql, run it through some sort of regexp to fitler 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?

Thankyou Clarification: It is a php application to filter data from another database, and then for each record show an associated image froma 3rd database. It is from scratch... sql mysql sql-server database-design link|improve this question edited Oct 8 '08 at 17:53Adam Bellaire26.9k884128 asked Oct 8 '08 at 13:36Josh2038.

Re-tagged this to merge mssql tags into sqlserver. – ConcernedOfTunbridgeWells Oct 8 '08 at 15:06 hrm why would you have to even import the data into mysql then? Just query whatever database and display the image... – Shawn Oct 10 '08 at 2:33.

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.

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.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.