I'd go for Oracle9 as it has better support for text and
Image datatypes (if you use them).
things to watch out for.
Oracle has a limit to the names for tables, views,
procedures, etc... of 35 characters.
Oracle Migration workbench can do most of the work, but
it will rename objects if the first 35 chars are not
unique. You will find that returning a results set from
Oracle stored procedures is different to SQL Server.
Oracle will create a cursor and pass a handle of the
cursor as the result. Your front-end app will need to
deal with it. You can;t simply issue select * from table
and through the results at your front-end app like you
can in SQL Server. Oracle will wrap it in a cursor.
NEWID() and some other functions will need to be written
manually within Oracle as a package or function.
If using text/Image within SQL Server and you can only
use Oracle 8.1.7, then make use of the DBMS_LOB package
within Oracle eg DBMS_LOB.Length etc....
-----Original Message-----
We have developed the MS Project 2002 db on MS SQL
server. Now we are told it must reside in the Oracle db.
What version of Oracel has anyone had experience with and
what should we be concerned with in converting? With the
export function do the trick? Of course this is a rush
job!!
