MySQL Forums
Forum List  »  Other Migration

Re: Help
Posted by: Peter Brawley
Date: April 02, 2007 08:47PM

Clipper data files come in many flavours--dBASE III-compatible, FoxPro-compatible, even SQL-Server-compatible. AFAIK there is not a Clipper RDD for MySQL. Neither is there a mysql plugin database engine that reads dBASE III, FoxPro or SQL Server files. So you have three main choices ...

(i) generate CSV data dumps from a Clipper (or DBASE III or FoxPro etc) app,

(ii) if you have an ODBC driver for your flavour of Clipper-generated dbfs, access them in ODBC and port them to mysql, which has an ODBC driver, or

(iii) write a program in any language you please to read those files directly to dump the contents (which might not be as hard as it sounds because a .dbf is simply an ASCII data file with a binary header--the hard part is extracting memo file data).

PB



Edited 1 time(s). Last edit at 04/02/2007 08:52PM by Peter Brawley.

Options: ReplyQuote


Subject
Views
Written By
Posted
5011
April 02, 2007 04:45PM
Re: Help
3683
April 02, 2007 08:47PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.