PDA

View Full Version : [ubuntu] MySQL MS Access compatibility



reg4c
November 21st, 2008, 09:53 AM
Hey,

I have a MySQL database on one server and an MS Access database on the other.

Now, its easier for me to create a MySQL database then an MS Access.

Does anyone have any idea how I can convert MySQL DB to MS Access format and vice versa.

Cheers

dgoosens
November 21st, 2008, 11:00 AM
if you only need to do this once...
you can convert them with the TRIAL version of NAVICAT:
http://www.navicat.com/

the Linux version of this tool just runs in Wine, so you might want to start Windows, install Navicat, do the export and go back to Ubuntu...

otherwise...
you can always export as tab seperate file...

dGo

koenn
November 21st, 2008, 03:45 PM
otherwise...
you can always export as tab seperate file...

dGo

good idea. You can even export tables, views, ... into 'create table', 'create view' sql scripts, which you can use to recreate the database on an other system.