General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
MULTIPLE MEMO FIELDS IN ORACLE
Hi,
We are planing to upsize VFP database to ORACLE, getting error due to multiple memo field in single table. We feel that following steps need to do for migrating system from VFP DB to ORACLE. Please give us a detail which help us to complete this task, or any problem you found in following steps.
Step 1 : Using VFP Upsize Wizard, create tables at Oracle DB with VARCHAR default for Memo. Whatever other modification required at Oracle DB like Remote Store Procedure,views,Default & Index.
Step 2 : From Oracle DB, Drop VARCHAR (MEMO ) OR Modify structure with CLOB for all MEMO.( ORACLE allow you to create multiple CLOB ( 4 GB capacity) fields in single table.
Step 3 : Create Remote View using ORACLE DB connection.
Step 4 : Convert all SQL STP or Pure SQL for remote data compatible with ORACLE.( Here someone help us with detail about difference between ORACLE SQL / SQL Server SQL & VFP Native.
Thanks in Advance
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only