Re: Oracle licence question



What you mean - they use portable SQL as definied by the ANSI SQL standard, something Oracle doesn't do very well! Come on guys, catch up!! Talk about MS locking people in - LOL!

What level is ANSI SQL compliance does Microsoft claim - can you provide a citation ?

One thing you need to watch is staffing, costs for Oracle staff here in the UK are a lot higher than SQL Server ones, also, you tend to need more; also, the SQL Server professional has a more rounded experience to the business, often trained in Business Intelligence.

Here's the published current salary costs of both sets of DBA's in the UK
Oracle - http://www.itjobswatch.co.uk/jobs/uk/oracle.do
SQL Server - http://www.itjobswatch.co.uk/jobs/uk/sql%20server%20dba.do

There shows that there is less than a 3-13% differential between the min and max salary ranges. Hardly a lot higher at all.

There is no evidence to suggest that managing Oracle requires anymore DBA's than managing SQL Server. Overall DBA counts within an organization are not comparable, as typically the Oracle DBA's are looking after more mission critical systems, and/or larger Data Warehouses, than the SQL Server counterparts. These systems also often have higher SLA requirements, which can translate into more than one shift of DBAs.

And there is evidence to suggest that managing Oracle is actually esaier than managing SQL Server. See the Edison report that showed that Oracle Database 10g requires 30% less DBA time, 20% less steps, and up to $36,000 less per year to manage than SQLServer 2000

http://www.theedison.com/research/gems/040401rdbmscmcs.pdf

I believe that a new Edison report is due out soon comparing Oracle Database 10g to SQLServer 2005. But if the last eweek review is anything to go by, the difference may become even greater with the newest release of SQL Server

"However, by making management more complex, Microsoft has discarded the one significant advantage it had over Oracle Database 10g and IBM's DB2—ease of administration. This makes DB2 and Oracle Database 10g look all the more attractive for their broader choice of development frameworks, management interfaces, and server hardware and operating systems."

http://www.eweek.com/article2/0,1895,1894609,00.asp

Your last comment, which interesting enough is not the usual MS rhetoric is purely subjective, and you have no evidence to back this statement up at all.
.

Relevant Pages

  • Re: IOT, memory and transaction time
    ... easily generate it with DBMS_METADATA.GET_DDL if your verison of Oracle ... were pretty consistent no matter how big the table (this transaction ... FOREIGN KEY (versionNo) REFERENCES T_TRANSACTIONS, ... Oracle provides read consistency and SQL Server ...
    (comp.databases.oracle.misc)
  • Re: Database or store to handle 30 Mb/sec and 40,000 inserts/sec
    ... "Writers block readers and readers block writers in SQLServer. ... getting around this fundamental issue and because of it SQL Server ... admitted they can happen in Oracle, I guess Oracle should never been used ... isolation level but you will always disagree because you follow doctorine ...
    (comp.databases.oracle.server)
  • Re: IOT, memory and transaction time
    ... easily generate it with DBMS_METADATA.GET_DDL if your verison of Oracle ... If it was the update statement that references ... FOREIGN KEY (versionNo) REFERENCES T_TRANSACTIONS, ... There are however differences how both products deal with concurrency; in Oracle readers don't get blocked while this may happen in SQL Server. ...
    (comp.databases.oracle.misc)
  • Re: Import problems on Windows Server
    ... XP is fine, so is Vista, like you I use them day in day out, around 12 hours ... a day myself too - laptops and the desktop i'm writing this on. ... I use SQL Server on XP and Vista for writing and demo'ing stuff, ... those are the same problems in the Oracle world. ...
    (comp.databases.oracle.server)
  • Re: Oracle DB to MS Sql Server DB Replication question...via Sql Server Views??
    ... into replication from Oracle to Sql Server. ... We have access to a remote Oracle database, ... We own a Sql Server database with Views that use a link server to ...
    (comp.databases.oracle.server)