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 !!
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
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
RE: Beginning with Paradox
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886