Supporting Oracle as well as SQL Server

Hi all,

I have just been asked if we can support Oracle as well as SQL Server.
And what the implications are.

A bit about our setup. Basically we deal in data - there is an app,
but it is secondary to the data. Lots of data migrations etc. We have
a complicated database schema with loads of constraints and loads of
sprocs that are not written in neutral SQL. Also we use CONTEXT_INFO
for auditing the username.

Firstly - are there automated tools for porting to Oracle from SQL
Server and rewriting all the nonstandard TSQL? And are they any good?
Secondly, I am thinking this is a big deal in terms of initial
conversion, new hardware and software, training and ongoing support
and testing. Has anyone gone from supporting one to many database
types. How was it?
Thirdly - does Oracle have a CONTEXT_INFO equivalent, or do I need to
start adding loads audit_username fields to tables and sprocs?

Any links gratefully received.

Cheers,

James
MCDBA MCSD MCITP:SQL2005 (notice the lack of Oracle yet?)

I am sorry, but no. It is not possible to migrate from SQL Server to Oracle.

I am sorry, but no. It is not possible to migrate from SQL Server to Oracle.
Perhaps you should try the "Overly complex, difficult to admin" thread. They
might have a hack.

--
Jay Konigsberg
SQL Server DBA in Sacramento, CA
http://www.linkedin.com/in/jaykonigsberg

Live in Sacramento, CA?
Join the Sacramento SQL Server User Group on LinkedIn
http://www.linkedin.com/groups?home=&gid=2825448&trk=anet_ug_hm&goback=%2Emyg

lol Erland. I was not really 100% serious.

lol Erland. I was not really 100% serious. However, after leaving Informix
(or more accurately Informix leaving us), I chose SQL Server over Oracle
because Oracle is so complicated to administer, even though I knew Unix
better than Windows. While Oracle has a greater capacity for load than SQL
Server, the gap has narrowed significantly to the point of making no
difference at least 90% of the time.

Now if you are dealing with a very heavy load, SQL Server is not simple
either, however, it takes so much to be an expert in anything these days
that trying to split your attention between two systems seems foolish,
expensive, or both.

--
Jay Konigsberg
SQL Server DBA in Sacramento, CA
http://www.linkedin.com/in/jaykonigsberg

Live in Sacramento, CA?
Join the Sacramento SQL Server User Group on LinkedIn
http://www.linkedin.com/groups?home=&gid=2825448&trk=anet_ug_hm&goback=%2Emyg

Thanks guys.

Thanks guys. I also think it is a bad idea, but I will check out an
Oracle forum for completeness.

Ta,

James