Paradox to postgresql interface
Has anyone had any experience with writing an interface between Paradox
(199X's vintage) and postgresql. I have the need to be able to read a
paradox database to "see" it's structure, replicate that structure in
postgresql and finally transfer the data to postgresql.
I have not done any searches of the various lists archives yet for a
possible solution.
Dale.
On Fri, 2010-10-29 at 18:34 -0500, Dale Seaburg wrote:
Has anyone had any experience with writing an interface between Paradox
(199X's vintage) and postgresql. I have the need to be able to read a
paradox database to "see" it's structure, replicate that structure in
postgresql and finally transfer the data to postgresql.
Sure.
As I recall paradox just uses the dbf file format. So write an interface
with a dbf driver (perl, python, etc...) and use your native postgresql
interface.
Sincerely,
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
http://twitter.com/cmdpromptinc | http://identi.ca/commandprompt
On Friday 29 October 2010 5:16:14 pm Joshua D. Drake wrote:
On Fri, 2010-10-29 at 18:34 -0500, Dale Seaburg wrote:
Has anyone had any experience with writing an interface between Paradox
(199X's vintage) and postgresql. I have the need to be able to read a
paradox database to "see" it's structure, replicate that structure in
postgresql and finally transfer the data to postgresql.Sure.
As I recall paradox just uses the dbf file format. So write an interface
with a dbf driver (perl, python, etc...) and use your native postgresql
interface.Sincerely,
Joshua D. Drake
A quick Google search found this:
http://pxlib.sourceforge.net/pxview/index.php
On Windows if you have Access it should have a Paradox driver. I have also used
OpenOffice Base to convert dBase files.
--
Adrian Klaver
adrian.klaver@gmail.com