leobackes / pxtools Goto Github PK

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.