Supporting Oracle as well as SQL Server
JimLad
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'm 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?)
Jay Konigsberg
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
"JimLad" <james...@yahoo.co.uk> wrote in message
news:9707f8ef-a443-465d...@z35g2000yqd.googlegroups.com...
Erland Sommarskog
> 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'm 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?
be quite an investment. East is east and west is west and rarely do they
meet.
I have no experience with Oracle myself, but so much is clear that
you would need to rearchitecture things quite a bit. For a more
entusiastic view of the operation, an Oracle forum could be a good
place to hang out in.
--
Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Jay Konigsberg
(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're dealing with a very heavy load, SQL Server isn't 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
"Erland Sommarskog" <esq...@sommarskog.se> wrote in message
news:Xns9D37137F...@127.0.0.1...
JimLad
> lol Erland. I wasn't 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're dealing with a very heavy load, SQL Server isn't 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
>
> Live in Sacramento, CA?
> Join the Sacramento SQL Server User Group on LinkedInhttp://www.linkedin.com/groups?home=&gid=2825448&trk=anet_ug_hm&gobac...
>
> - Show quoted text -
Thanks guys. I also think it's a bad idea, but I will check out an
Oracle forum for completeness.
Ta,
James