Paradox To MS SQL via DTS
Posted on 2006-11-11
I've been tasked with extracting data from tables in a Paradox based database. I'm not sure what version everything is. The BDE Administrator program on the client machines is 5.01 and there are native drivers on the client systems that are Paradox v.3, dbase v.3, DB2 v.3, foxpro v.4, etc.
Anyway - I have what I believe to be a copy of the data files and also a copy of a folder named 'structure'. My data folder contains files with extensions such as MB, DB, PX, .Xxx, Yxx, and so on. My 'structure' folder seems to be a copy of the same files in my data folder but the file sizes are significantly smaller (as if they are tables which contain no data).
I would like to try to do a DTS package to import these tables into a SQL database but when I attempt I run into problems with the CREATE because the paradox table has no valid column names and things like that.
Can anyone provide me with or point me to a resource which has step by step instructions on how to accomplish this?
If you haven't guessed already, I'm a novice in the true sense of the word when it comes to databases.