Convert Database From Another Database File

Please help me to convert database.

This is the problem,
i work at an IT company. i'm junior database engineer at there.
my task is converting database file from another format to mysql format.
for example : our client give me the DBF file or MDB file. So, i must to convert it to mysql format.

The problem will happen when i want to transfer the file from the old file to new file.

I mean like it :
in the old file(such as mdf) have much tables. the old file have an table name "personal". I want to transfer all data from this table to new database i have built using mysql.

i want to ask for the tricks to transfer this data from old file to new one.
help me please....

re: Convert Database From Another Database File

One source I can pint you to is the phpclasses.org site. The following class converts dbf to sql.

http://www.phpclasses.org/browse/package/207.html

Ronald :cool:

re: Convert Database From Another Database File

For easy and quick database conversion from any of these formats:
- Microsoft Access
- dBase
- FoxPro
- Microsoft Excel documents
- Interbase/Firebird
- Lotus 1-2-3
- MySQL
- Oracle
- ODBC sources
- Paradox
- SQL Server
- Delimited text files
- XML

to any of these formats:
- MySQL
- Microsoft SQL Server™
- Oracle
- Microsoft Access™
- Interbase/Firebird

take a look at Full Convert Enterprise application.
http://www.spectralcore.com/fullconvert/index.php

Ramajana

re: Convert Database From Another Database File

Hey you can use SQLyog for converting databases of different formats

regds

re: Convert Database From Another Database File

And Full Covert Enterprise cost you about USD 249. With a yearly license update of USD 99!!

Ronald :cool:

re: Convert Database From Another Database File

can i get a free one?

re: Convert Database From Another Database File

Yes, it does cost $249, but this also covers one full year of free upgrades, even if a new major version is released. The license you mention is only the download license renewal (to be able to download all updates even after the initial year passes) - and it is an option, not mandatory purchase. What you download can be used undefinitely, of course.

R.