SQL & PL/SQL

Hi there!

I have written an upsizing wizard in VFP to move VFP tables to an SQL Server database. The user simply selects the data folder, the ODBC connection they want to use, and then which SQL Server database they want to upload to (or create a new one). This is all done using fairly basic T-SQL, and some SQL Server system stored procedures to get some of the info required (eg a list of the databases). In addition to the data we also create a few of our own stored procedures specifically for the app. Now we have been asked to provide the same facility for an Oracle database.

I have not yet looked at Oracle but from what I have read the stored procedures will be an issue. However, what about the data? Should I be able to use the same concept to get the data uploaded? Again we shall be doing this via ODBC.

Any pointers greatly appreciated!

TIA
Neil