I.T. Discussion Community!
-Collapse +Expand
DBA
Search DBA Group:

Advanced
-Collapse +Expand DBA Store
PRESTWOODSTORE

Prestwood eMagazine

March Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyDBA, Databases, & Data BoardDB Other & Misc. Topic   Print This     

Paradox data conversion

Paradox data conversion in DB Other & Misc. topic (part of our DBA, Databases, & Data group).

Quick Search: Paradox   conversion   Paradox data   Paradox data conversion  
gchoy
 (Inactive)
Atlanta, GA USA
I have some experience migrating dbaseIV data to an Oracle database. I have not used any tools. Imported data into MS Access, then exported from MS Access to Oracle (using ODBC). I have an AS/400 background... go figure :-)

I have an upcoming challenge. I don't know anything about Paradox database files. I will have some old Paradox database files and record layouts. My mission will to get the data from these old Paradox database files into the AS/400's DB2/400 database.

Assuming I similarly need to go through MS Access, I think I will have to do separate research to get up on the MS Access to AS/400 via ODBC. So I am not asking about that here (unless someone can advise).

Assuming I similarly need to go through MS Access, will I need any special ODBC driver for the Paradox data source? Will I need to determine the version of the Paradox database files (if there is such a thing)?

How about the "MS Access" assumptions above? Is this the way? Is there a better way? Are there tools to facilitate this? Are there services that do this? (I guess subcontracting feasability would depend on how much data I will be dealing with and/or how many iterations will be necessary). My preference would be to do it myself.


------------------
Thanks!
 Posted 20 years ago (Thread Starter)
Comment Quote
About gchoy -Collapse +Expand
Visit Profile
Inactive member.
Member does not subscribe to this thread.
Email Not Verified!
Once email is verified, we will review and approve the account.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #1051, 2 replies
Thread Started 2/20/2001 5:12:00 PM
View Counter=2930
Last Reply Posted 5/21/2001 1:35:00 AM)
Location=Atlanta, GA USA  
Joined=20 years ago   MB Posts=1  
Most Recent Post
Steve Butterworth
 (Inactive)
-- USA
I frequently am moving data between different packages and the best method I stick to is to use TAB-DELIMITED text as the format for transfer to and from.

Paradox has excellent import/export filters built in.

SO I would export from Paradox to tab-delimited text, and import into Access, if you must use that, but why not go straight to DB2 and import from ODBC source .txt file.

Export from Paradox to .txt, import into db2 via odbc same text file.
 Posted 20 years ago
Comment Quote
About Steve Butterworth -Collapse +Expand
Visit Profile
Inactive member.
Member does not subscribe to this thread.
Email Not Verified!
Once email is verified, we will review and approve the account.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #2230 (Level 1.1)  Reply to 1051
Thread Started 5/21/2001 1:35:00 AM
View Counter=2
Location=-- USA 
Joined=20 years ago   MB Posts=6  
Scott Wehrly
Prestwood IT
 (Inactive)
Las Vegas, NV USA
Well, if I can suggest a different method...I've done data moves like this (from one database vendor to another) in Delphi, which has a BatchMove component that simplifies the operation.


As long as there is a match of all of the primary key and required fields between the Paradox table and the DB2 table (optional fields can just be excluded from the data move), the Delphi component moves the data in a single batch with little or no need to write code for the action. Assigning the Paradox and DB2 tables to the BatchMove component is a simple click-drag kind of operation.


Connecting to the DB2 database is simple. Delphi can either use the ODBC connection or a native DB2 network connection. The Paradox connection is the simplest.


The only problems that would occur would be where the Paradox fields have any "funky' characters in their name, like slashes or apostrophes. You can "mask" through these funky naming conventions (i.e. remap the field names to names that are ANSI standard) in Delphi with minimal effort.


The time it would take to set up a tiny Delphi BatchMove application like this is directly proportional to the number of tables involved.

-----------------------------------

And to suggest another tool (which you may already have at your disposal), the same kind of data transfer application could be built in Visual Basic v6. Ask around our regular gurus on the Access or Visual Basic forums.
 Posted 20 years ago
Comment Quote
About Scott Wehrly -Collapse +Expand
Visit Profile
Inactive member.
Member does not subscribe to this thread.
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #1856 (Level 1.2)  Reply to 1051
Reply Posted 4/26/2001 12:53:00 PM
Location=Las Vegas, NV USA 
Joined=19 years ago   MB Posts=442   KB Posts=19  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P123A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #1051 Counter
2930
Since 4/2/2008

Follow PrestwoodBoards on: 


©1995-2021 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech