Database migration from Access to MySQL

[David Bowskill]

Hello All

The way I understand it, the first task is to dump the Access file as a
CSV file and feed this into a ODBC /MySQL driver to create MySQL tables
- is this correct?

If this is correct, can anyone point me to a suitable ODBC driver ?

If I am talking through my hat, please give me some guidance.

Many thanks

David Bowskill

--
ubuntu-au mailing list
ubun...@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-au

[George Patterson]

On Tue, Nov 24, 2009 at 9:39 AM, David Bowskill <davi...@tpg.com.au> wrote:
> Hello All
>
> The way I understand it, the first task is to dump the Access file as a
> CSV file and feed this into a ODBC /MySQL driver to create MySQL tables
> - is this correct?
>
> If this is correct, can anyone point me to a suitable ODBC driver ?
>
> If I am talking through my hat, please give me some guidance.
>
>
> Many thanks
>
> David Bowskill
>

Hi David,

CSV files would work but is slow.

While it was a while ago since I migrated data from Access to MySQL, I
used a script which would dump a mysql dump file. There are plenty of
conversion scripts and programs out there.
http://www.bullzip.com/download.php (it needs to run on a Windows side
machines) looks good but I haven't used it.

Regards

George

[Sridhar Dhanapalan]

2009/11/24 David Bowskill <davi...@tpg.com.au>:

> Hello All
>
> The way I understand it, the first task is to dump the Access file as a
> CSV file and feed this into a ODBC /MySQL driver to create MySQL tables
> - is this correct?

There are two ways I've used:

* MDB Tools
* Pentaho Data Integration

The former can convert MDB to CSV and export the DDL.

The latter is far more powerful, but requires you to make an ODBC
connection to a running instance of Access.

--
Bring choice back to your computer.
http://www.linux.org.au/linux