Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Moving data from FoxPro to Oracle
Message
De
19/02/2003 05:25:30
 
 
À
10/02/2003 16:56:07
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00750857
Message ID:
00754837
Vues:
14
>Thank you Mark,
>
>I am trying SPT now. I am sure there will be many more ?'s after I have done some more testing. :)
>
>Cicilia

I move records from FoxPro to Oracle every night for reporting purposes. Since I still use VFP 6 I used the upsizing wizard to create the tables in Oracle, wrote a Fox app to convert them to SDF files, and created some SQLLDR scripts to load the data into Oracle. It loads a million+ row table in about 2 minutes. To do this I would recommend getting the book "Oracle SQL-Loader - The Definitive Guide" published by O'Reilly. If you need further details please let me know.

HTH,
William Chadbourne
Senior Programmer/Analyst
State of Maine - DAFS App Team

Oracle - When you care enough to use the very best!!
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform