Skip to main content
March 17, 2008
Question

migrate data into MySQL schema

  • March 17, 2008
  • 3 replies
  • 270 views
MySQL GUI tool - Migration Wizard works well at basically importing a database as a new schema into your mysql database server, however, I'm looking for tools that will allow me to fine tune my import a little more. For example, If I just want to import the data from say one MS Access database table into an existing MySQL database table, and allowing me to choose which column from the source database gets inserted into the target database so that you can match the data regardless of their column names. Enterprise Manager works in this fashion. What recommendations of software do you have for MySQL?
This topic has been closed for replies.

3 replies

Inspiring
March 18, 2008
I have to do monthly imports of a 300 meg csv file into an exsisting
database, and it does a great job. It allows you to import/export data in
many different formats. there is a full working trial.

k




March 17, 2008
does it do a good job of importing data into an existing database?


Inspiring
March 17, 2008
http://www.navicat.com/

The above is very good and it gives you a 30 day trial. Its simple to use.

k