Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VFP Upsizing wizard and Oracle
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00932935
Message ID:
00932946
Vues:
14
This is a bit of a problem in VFP. What I would do is create the tables in Oracle that match your VFP tables as close as possible. Then create a remote view in a VFP DBC for each of the Oracle tables and make sure you mae the view updatable. Then open each view, set buffering to tablebuffering, APPEND FROM VFP_TABLE_NAME and issue

? TABLEUPDATE()

after the append completes. If it fails, use AERROR() to see wht the problem was.

>Hi, I have tried to use to VFP Upsizing wizard to convert a database to an Oracle one.
>
>By using the wizard I am blocked at step number 2. I do not see any Oracle datasources even if I have them configured on my computer. I have added on ODBC connection with both Oracle's driver and Microsoft's driver. I have tried upsizing to SQL Server with an SQL Server datasource and I have no problems.
>
>I checked the VFP documentation which only mentions upsizing to SQL Server. This you have lead me to think that you can only upsize to SQL Server were it not for some web sites I found which talks about Oracle upsizing ( without helping me solve my problem ).
>
>I have tried the wizard under VFP 8 and 9.
>
>Can it be done ? If so what must I do so that I can get past step 2 in the wizard ?
Mark McCasland
Midlothian, TX USA
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform