Connect PHP with Paradox .db file on linux server

2.4k views Asked by At

I have the following situation:

I have to integrate a website (php on linux server) with an old app (Delphi and Paradox (.db file) on Windows) I need get data from paradox database and show them in the website. I can get transfer the .db file by FTP.

I don't think that I can install external libraries.

I did not find any command line program on Windows to convert from .db file to mysql or any format that supports PHP. In addition, Paradox database is updated daily.

Does anyone have any solution or tip or anything?

2

There are 2 answers

0
Cristhian Boujon On BEST ANSWER

I found here the solution to get data from a paradox .db file without DBE.

Regards.

0
sarnold On

Probably best is to write a new stand-alone application for the Windows host that is linked against both the Paradox libraries and the PostgreSQL libraries; make queries against the Paradox database and write the data to the PostgreSQL database.

If you wanted to go half-way and write a tool that dumps the Paradox database into a CSV format for later import on the PostgreSQL end, that could work too, but there is enough hassle in CSV formats that doing the entire transition Paradox -> PostgreSQL in one application seems like the best approach to me.