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.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement