Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Import data from other systems?
Message
Information générale
Forum:
Oracle
Catégorie:
Autre
Divers
Thread ID:
00347890
Message ID:
00348544
Vues:
17
>I have been franticly searching for a fasyer way to import data from a VFP database into Oracle. Our current method is just to slow, exporting from Fox, so is there a way, via ODBC to import from Fox. So far searching the oracle on-line refenece is not of much help.

We did with ODBC. Here is the step (by memory)
-First our table was VFP so we did Upsizing to Oracle
-Create ODBC via Control Panel
-Create a Remote view in VFP
When you create your view be sure to check the right items in the update criteria.
-You do an append from your table into your view
-And then you use TableUpdate(.T.) / TableRevert()

We did with 300 000 records and it was not slow.

By the way, what's your methode.
Analystik Team
1430 Belanger
Montreal (Quebec)
Canada
(514) 278-2727
analyste@analystik.ca
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform