mdbtools-dev

[mdb-dev] Convert Access DB into a MySQL DB

[Mario O. <mar...@gm...>]

Hello List,

i have a little Jet DB (Access) file here which i would like to convert
to a mysql database.

I have compiled and installed the latest cvs version successfully.

Now, how do i proceed? Which tool do i need to convert my access file
into a mysql db?

Thansk, Mario

Re: [mdb-dev] Convert Access DB into a MySQL DB

[Mario O. <mar...@gm...>]

On Fri, 2005-05-06 at 07:31 +0000, david whiting wrote:
> Hi Mario,
> 
> I haven't used mdb-tools for a while so I might be getting a bit rusty
> and I have an old version from CVS (I haven't had to work with an
> access file for a while). But, if I remember correctly,  if your DB is
> called 'accessDB' you should be able to use:
> 
> i) mdb-tables accessDB 

How can i find out the tables in the file?
I have tried to open it with M$ Access 2003, but got an error that i
would need the privileges to do so, and to make sure the DB isnt locked
or something.

I am Administrator, and the file is fully r/w by the user.


Thanks, Mario

Re: [mdb-dev] Convert Access DB into a MySQL DB

[Horst K. <md...@kn...>]

Am Donnerstag 05 Mai 2005 20:22 schrieb Mario Ohnewald:
> Now, how do i proceed? Which tool do i need to convert my access file
> into a mysql db?
If mdbtools can read your mdb file you might want to use knoda 
(http://www.knoda.org) to export your data to Mysql

Horst

Re: [mdb-dev] Convert Access DB into a MySQL DB

[Mario O. <mar...@gm...>]

Hello Dave, 

On Fri, 2005-05-06 at 14:12 +0000, david whiting wrote:
> For me just calling mdb-tables with the name of the DB gives me the
> tables. For example:
> 
> mdb-tables Nwind.mdb 
> 
> gives me:
> 
> Order Details Orders Products Shippers Categories Customers Employees Suppliers 

mdb-tables file.pck
ABFBaum AfATabel clItem GEVOBaum sABFKons sBilzTxt sBuchArt sBuchTxt
sEUERTxt sFestKto sMahn sPersKto sSchlBez sStVor sUstVor TBSBaum sFibuK
sSachKto sStTab sZvkK sFKonst Waehrung bFibuHd SendArt
tmpAuktionDocStTmp ABFDruck Inventur SeitInv SeitIPos WEBuch EABPWEBuch
EABPRABuch EABPBuchJournal EABPKtoBlatt tKasBuch tKasSplit
tKasStueckelung sAnlHist sAusw AbgrBuch sAnlagen SAfATab SJAfA AbgrBetr
AbBetr2 IFBProt UserProt sHBank sBankVb sperskom sperskor MahnPositionen
sKzBaum bSalden sKassen ToDo Favoriten sClKonst DOB tSVAssist tKasTrans
sBelArt sGrundl DbProt LastBuH LastBuN sZusatzZeilen ABFMe ABFRabat Tbs
sArtikel ArtLief ArtVerw ArtStat ArtMenge artbeweg StckList ArtPreis
PrsStaff ABFProj Zuschlag ABFDok ABFDokWK ABFPos ABFPosWK ABFTZ ABFPStat
AbfStat RABuch TUBuch ABFStapl RappProj BestDok BestPos BestStat
AcontoBuchung InvFortschritt WebShop WebShopCatalogTreeNew
WebShopCatalogTree tNebenZeileWK sEBImpGrundlagen bEBImport sVorlauf
sBeschr sBuch Elster_Grundl Elster_Main sZKD sInkasso tmpPersKtoSelA
tmpPersKtoSelB TempArtNr sZvkS VZ ZScheck ZDDTA ZASCII VESRDaten ZOnline
TMailAccounts WebShopItems WebShopIDs OrderDoc OrderPos
WebShopBankeinzug ProvData PrsFest sAfterbuyKons ArtAenderCalc
Preisschwellen ProjInf PCFBImport bBuchung bBuchSub bOpoMain bOpoSub
OpProt bPrAntBuch tWKBuch tHauptzeileWK tWKBuchSub TMailDocTypes
TMailDocuments TMailConfig bZList BOPZahl Abgleich Abgl_OP ZAbglDat
BSmlZlg BZahl DlgDaten

So i guess that worked ;)

> 
> Can you give the exact error message? 
I did a screenshot of the access error message (in german), but i guess
its not intresting anymore at this point.

> And just out of interest are you
> using the C or java version and what is your OS?
I am running Debian sid, with the latest mdb tools (cvs version from
05.05.2005).



Do i now follow your next steps?

ii) mdb-schema -T Orders accessDB mysql
iii) mdb-export  to dump the data.

$ mdb-schema -T ABFBaum file.pck mysql
-------------------------------------------------------------
-- MDB Tools - A library for reading MS Access database files
-- Copyright (C) 2000-2004 Brian Bruns
-- Files in libmdb are licensed under LGPL and the utilities under
-- the GPL, see COPYING.LIB and COPYING files respectively.
-- Check out http://mdbtools.sourceforge.net
-------------------------------------------------------------

DROP TABLE ABFBaum;
CREATE TABLE ABFBaum
 (
        ABFBaumCode                     varchar (40),
        ABFBaumEbene                    int,
        ABFBaumName                     varchar (31),
        ABFBaumDtnrmWrg                 varchar (23)
);
-- CREATE ANY INDEXES ...



-- CREATE ANY Relationships ...

-- relationships are not supported for mysql


Any idea?

Thanks, Mario