Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2005
    Location
    USA
    Posts
    1

    Question Unanswered: Paradox to MySQL

    I need some advise.
    A friend of mine has a huge plant database in Paradox that she wants to put on the net. I'm thinking to convert it somehow and put it into mySQL so it would be easily searchable, etc.

    Does anyone have experience doing something like this?
    How can we do the transaction?

    I'm not at all familiar with Pdox, so I'd appreciate all help.

  2. #2
    Join Date
    Jul 2004
    Location
    Dundee, Scotland
    Posts
    107
    Hi Susan,

    My five cents... I know MySQL, but not Paradox. Your probably looking to export the data from Paradox as plain text (csv) then import it into MySQL, as a "one of" exercise.

    Questions:-

    - so the Paradox database is huge? what's that in rows/columns and file size?

    - how often is the Paradox database data updated, and what are the implications? (the data changes from time to time and these changes might need to be synchronised?)

    A little searching on google finds:-

    dBforums - comp.databases.paradox (http://dbforums.com/f51/)
    ... if you need to ask out to do the export from Paradox.

    http://mirwin.homestead.com/files/ti...AndExport.html
    ... via the above forum, these guys show you how (perhaps get them involved?)

    http://pxlib.sourceforge.net/pxview.html
    ...here is a program that seems to do the export, quote "pxview is a program to read Paradox DB files. It is based on the pxlib library. pxview allows to output csv for reading with spread sheets, sql to import into a relational database, html and sqlite. You can also just show some information and the table structure of the database."

  3. #3
    Join Date
    May 2002
    Location
    Bangkok
    Posts
    9

    Move Date to mySQL with dbQwikSync2mySQL

    dbQwikSync2mySQL will move data from Paradox (and other databases) to mySQL. Web Site Product Page

  4. #4
    Join Date
    Oct 2003
    Posts
    63

  5. #5
    Join Date
    Jan 2005
    Posts
    4
    Maybe you can try to use Navicat to import the data from paradox to MySQL. Navicat supports to import data from many data types. It is extremely easy to use, you can import your data within a few clicks.

    You may download an evaluation copy from here:
    http://www.navicat.com/download.html

    I came accross to this software from this review in O'Reily:
    http://www.onlamp.com/pub/a/onlamp/2...2/navicat.html

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •