Re: Paradox, C++ Builder 5 and MySQL

Hieronimus wrote:

Hi

Thanks for the quick reply.

I want to move my data from Paradox to MySQL, so all data is still
inside a Paradox db.
Since the data model is different between the two databases, I'm using
a PHP script to map the fields from Paradox to MySQL and handle all the
necessary inserts.

I'm investigating the Memo and FormattedMemo fields, they sound like
they might be the culprits. And just to add to this mess, I don't have
the full source for the applications that handles insertions into the
Paradox DB. And what I have, doesn't handle the db.

Argh.


You'll get there. FYI, Paradox does NOT use monolithic storage like Access's .mdb file. A Paradox .db file is only the table data. All other stuff like indexes, memos, BLOBs, are stored in companion files. Search your directory for file extensions like .PX, MB, etc.
.

Relevant Pages

  • Re: table refresh
    ... Too often Paradox won't allow edits due to phantom locks. ... concerned about the editing at this point but was hoping I could get around ... just resort to one of the widely available MySQL table viewers. ...
    (comp.databases.paradox)
  • Re: Paradox, C++ Builder 5 and MySQL
    ... Since the data model is different between the two databases, ... a PHP script to map the fields from Paradox to MySQL and handle all the ... a corresponding MySQL field. ...
    (comp.databases.paradox)
  • Paradox --> MySQL
    ... Paradox verwendet; nachdem sich die Anwendung paradoxenderweise mitsamt der ... Datenbank ins Chaos verschlagen hat, ist der Kunde zur Erkenntnis gekommen, ... Da ich zwar einiges mit SQL gemacht habe, aber MySQL gar nicht kenne, hier ... Prev by Date: ...
    (de.comp.lang.delphi.datenbanken)
  • Re: Paradox, C++ Builder 5 and MySQL
    ... I have a bunch of data stored on a Paradox database. ... or the MySQL tables? ... Are they native to C++ Builder? ...
    (comp.databases.paradox)
  • Re: Paradox --> MySQL
    ... > Derzeit wird Paradox verwendet; ... > Da ich zwar einiges mit SQL gemacht habe, aber MySQL gar nicht kenne, ... Prev by Date: ... Next by Date: ...
    (de.comp.lang.delphi.datenbanken)