Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Hi,
Thanks for reply,We have system which executing on SQL Server & VFP native DB with remote view, some STP & three store procedure. Our developer initially develop system on VFP using local views & UPDATE , INSERT & DELETE SQL command. All processing they coded on cursor or view & using Transaction & TABLEUPDATE() commit data to backend.Now I got only 2 week timeframe for this assignment to make it compitable with ORACLE, My project leader want one source code which can be execute for all (VFP,SQL server 7.0 & ORACLE 8i) DB, he don't want to define more store procedure also, he added one memo fields on main tables (frequently required modification on structures like new fields) which contains XML file format so developer can add as may fields they want to put new GUI & don't have to worry about modifying structure or views.So Is that any short cut(Any tool) so I can upsize VFP or SQL DB to Oracle, create views & compare STP command syntax with Oracle & make it unique for all DB.
Again Thanks for your help.
Ambrish
Précédent
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