×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Beginning with Paradox

Beginning with Paradox

Beginning with Paradox

(OP)
I have been tasked at work with designing a cut down audit records system based on an existing system. The clients want legacy data imported . The exisitng system uses paradox. I must migrate lagacy data to a new SQL server back end.
First, I need to find where the Paradox database is located.
Second, I need to examine its structure so I can build the SQL database.
Third, I must exctract the required data from Paradox to SQL.
Any help locating, examining and extracting will be welcome.
Suggestions of tools software, etc....I will appreciate it all !!

RE: Beginning with Paradox

1) The client has to give you some idea where to start, either a web app or a location on their server or the table files themselves.  If the files are not currently in use, copy them to your computer for convenience.  (Maybe do this anyhow during development, then get an up to date copy when your development is finished.)

2) Open each table file and examine the structure.  There's a menu item for this.  Info or Structure or something like that.  

3) You'll probably need to export your tables to CSV or another format, then write a script of some sort to import it into SQL.

I would actually not do step 3 immediately.  I'd generate some test data after step 2, then create the forms and whatnot to manipulate the data and create new.  Once development is done, delete all the records from the database, then import the new ones.

RE: Beginning with Paradox

Can anyone tell me how to go into an exiting table and delete fields/columns? I just recently changed jobs and find myself, after 6 years, using Paradox again, and I can't remember how to do this simple task!

RE: Beginning with Paradox

Nomi I answered this one in the other thread you started about deleting fields.

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close