>>I used Upsizing wizard to port data from VFP-5.0 to Oracle 7.3
>>I was able to port partially. The following errors occured.
>>
>>1. Char data type is not in reality converted to VARCHAR2 into oracle
>>i.e. a field of width char(30) having 'Satya' is ported as 'Satya '
>>with spaces .
>>
>>2. A table with column name SECTION was exported as SECTION_
>>
>>3. logical data type is exported as numeric 1 or 0 .
>>But I want them to be char 1 or 0 . i.e. '1' or '0' .
>>
>>4. Even memo fields are having 400 charecters , VARCHAR2(500) is not sufficient and not even VARCHAR2(2000). They need to be essentially declared as long .
>>
>>5. I already have the structure in Oracle. I want VFP rows only to be copied to oracle and not structure. But the table in oracle is being over written .
>>
>>And some other errors , which I manipulated in Oracle.
>>
>>Any body, having solutions can mail me at,
>>
>>spvedulla@hotmail.com
>> or
>>spvedula@rocketmail.com
>
>If Oracle structure already exists then you, probably, could create Remote Views and populate them with VFP data. At least here you could check datatypes, etc. programmatically.
Can You explain how to create Remote view. From New in File menu, it is not activated. even I have ODBC conectivity. and Upsizing works properly. I have in 35 tables in Oracle Data type. and the Oracle database is very big. Some tables have 250 fields too.
If some of fields in foxpro were to be dropped in Oracle and some have to be created. Is it possible using that way ?
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