Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

converting paradox to oracle

Status
Not open for further replies.

mrcamo

Programmer
Feb 27, 2010
33
GB
Hi im trying to convert some paradox tables into oracle tables, im just trying to move the data across but strugelling with mis matches in data types,

Im using a CSV export and then cleaning the data then importing into Oracle,

Could anyone point me in the direction that I might find info on the following paradox data types:

Auto-incrementing
String{},
integer(32bit)
Date
Boolean Real
Text memo
Time
Integer(16bit)
Date and Time

Im just looking for descriptions of these data types so that I can alter the data into oracle equivelant data..

Any help would be apriciated
 
i have been looking all over for a description of "real" in paradox... does anyone know of any information sources i can use?
 
The TypeName of real fields in Paradox is Float64. To Google "paradox" is too obscure. Try Googling "borland paradox" and you you'll find all you need.

Roo
Delphi Rules!
 
For whatever it is worth, there are several Oracle forums here in I would imagine any one of them could help you choose a data type key word to match the needs of your former Paradox table.

A basic assumption is: the data is your CSV file (copy) is 'identical' to the data in your Paradox table (original). Moving forward, the data in your CSV file is now your original. Treating the CSV data as the 'new original', perhaps you can now focus on Oracle and match data types to the actual data in the CSV file. Given, the size of your CSV file may make that approach near impossible.

Steve.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top