Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Moving data from FoxPro to Oracle
Message
From
07/02/2003 18:19:35
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Moving data from FoxPro to Oracle
Miscellaneous
Thread ID:
00750857
Message ID:
00750857
Views:
57
I am currently in the process of upsizing our FoxPro 7.0 database to Oracle 9

I start by creating the table in oracle
making a remote view of it
and then I use
SELECT * FROM table INTO ARRAY array
and
INSERT INTO table FROM ARRAY array

Is there a faster way

Some of my tables have reached the limit of 2 Gigs.
Probably wont be able to use arrays for those...

Thank you for your help

Cicilia
Next
Reply
Map
View

Click here to load this message in the networking platform