Re: SQL Server vs Oracle?!

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



I can give you the marketing BS and my personal preferences and why. But, those are not objective reasons to switch your RDBMS platform. SQL SERer 2005 is finally at a level where I feel it can compete head-to-head with Oracle on many levels. It scales much better than Oracle. There are also many added benefits, like asynch queues (Service Broker), Reporting and Notifications, along with the ability to easily implement SOA through HTTP endpoints. But, your company may have already spent the money to have all of that in Oracle. Unless they are unhappy with ongoing fees, I see few reasons to just dump Oracle.

You need to give more information about what you are doing and the reasons for considering SQL Server over Oracle for future development. In addition, what are the skillsets of your DBAs; if they are all Oracle, you have a hiring issue.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
http://gregorybeamer.spaces.live.com

********************************************
Think outside the box!
********************************************
"Steve Kershaw" <steve_kershaw@xxxxxxxxx> wrote in message news:1166111718.922249.229200@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I need your help!

I'm working at a company that is considering changing from Oracle to
SQL Server 2005. The debate goes on and on and on....

I need some arguments that will help me convince those who are on the
fence to go to SQL Server 2005 for all new development projects. Can
anybody help me with this?

Steve


.



Relevant Pages

  • Re: How to convince my customer to use SQL2005 instaed of Oracle10g
    ... migration to Sql 2005 would be direct & straight forward, quick, and ... If I were you I would focus one SQL Server 2005 clearest advantages ... would need a 4 processor license but for Oracle you would need a 16 ... You mentioned Availability, so I assume your looking into HA (high ...
    (microsoft.public.sqlserver)
  • Re: SQL Server 2005 vs Oracle
    ... SQL and Oracle. ... SQL Server one sizes log files to handle the largest transaction and its ...
    (comp.databases.ms-sqlserver)
  • Re: IOT, memory and transaction time
    ... What is a better way of structuring this SQL for Oracle? ... Oracle expertise available at the moment but certainly SQL Server ... Server uses dynamic memory allocation whereas Oracle, in our tests, ...
    (comp.databases.oracle.misc)
  • Re: How to convince my customer to use SQL2005 instaed of Oracle10g
    ... the old Sql versus Oracle debate. ... If I were you I would focus one SQL Server 2005 clearest advantages ... You mentioned Availability, so I assume your looking into HA (high ...
    (microsoft.public.sqlserver)
  • Re: SQL -> Oracle
    ... > 2- extracted all my SQL queries in one single file (that was the tedious ... > 3- now whenever I need new query. ... > - Sybase and SQL server prefix their parameters with '@' ... > - Firebird and Oracle have selectable stored procedures so you use them ...
    (borland.public.delphi.non-technical)