The pxtools are a set of tools to convert a Paradox-database into a SQL-database (MySQL, PostgreSQL), CSV or XML. These are a few changes I needed to make to get it to work
License: GNU General Public License v2.0
C 79.15%Shell 18.98%Makefile 0.61%M4 1.26%
pxtools's Introduction
The pxtools are a set of tools to convert a Paradox-database into a
SQL-database.
This is a fork of https://github.com/ustramooner/pxtools, which is
derived from the original pxtools, which used to be found at
http://www.kneschke.de/projekte/paradox/ (it is now a 404).
Original author: mailto:[email protected]
pxTools
=======
pxinfo
------
dumps the basic infomations of the given paradox-file.
pxsqldump
---------
Parses the Paradox-database and dump the corresponding SQL-strings (CREATE
TABLE and INSERT INTO) on stdout.
use -n to overwrite the tablename.
use -f to specify the filename of t
pxcsvdump
---------
Parses the Paradox-database and dump the corresponding CSV-strings on
stdout.
use -n to overwrite the tablename.
Supported Field Types
=====================
Currently the following field-types are recognized:
ALPHA
DATE
SHORTINT
LONGINT
CURRENCY
NUMBER
LOGICAL
TIMESTAMP
MEMOBLOB
the rest is currenly not supported. mail me if you need more.
Problems
========
Y2K
---
Paradox-files are NOT Y2K-safe. Currently there is a workarund for this bug
in pxconvert.c that adds 100 years if the date is before 1.1.1970.
Index-files
-----------
The information you get out of the index-files by pxsqldump is not rellay
usefull. It all the data it can find, but the header is currently parsed
wrong. Anyway these index-files are not needed to convert a paradox-database
into a SQL-database. (PRIMARY KEY and FOREIGN KEY can't be detected yet.)
TIMESTAMP
---------
The field-type TIMESTAMP returned by pxsqldump has a precission of
+/- 1 second.