Actually I want an alternate for Visual Foxpro's Upsizing wizard, When I implemented it with Real data, I got lot of problems. I want them to be solved. And I have a lot of data in Fox, almost more than 250 tables and for each table more than 250 records. And there are almost 70 such sites.
I can't change any of the field names, and I have to export data to Oracle exactly. I tried this by writing a program in VFP using ODBC. It works fairly well when compared to Foxpro's Upsizing wizard. I used some string concatenations to make a query with
CREATE blah blah....
and then pass it to SQL PLUS, It works fine. But I want to know any better way than this. Even I am checking the data types etc. It is almost like another wizard but with a bit of more ORACLE touch.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only