| Oracle vs MsSQL [message #182210] |
Thu, 13 July 2006 14:13  |
Mongr1l
Messages: 2
Registered: July 2006
|
Junior Member |
|
|
Hello. First, if I'm posting this in the wrong forum, please forgive me as I'm new.
I'm an MS SQL Developer of 12 years. I have been asked by my boss the merits to switching to Oracle. It pains me to say that I know absolutely nothing about Oracle, so I can not make an argument either way.
Could anyone offer some insight, please?
Thanks in advance.
-mongril
|
|
|
|
| Re: Oracle vs MsSQL [message #182214 is a reply to message #182210] |
Thu, 13 July 2006 15:33  |
Frank Naude
Messages: 4579
Registered: April 1998
|
Senior Member |
|
|
Most of us have the same problem - we know Oracle inside-out, but don't know anything about MySQL.
My personal opinion is that MySQL is OK for small to medium sized web sites, but will you use it to store a company's financial records?
Press releases that they've finally added views in MySQL 5.0 doesn't help either - it creates the impression that MySQL is at least 20 to 25 years behind Oracle.
Oh yes, and didn't Oracle buy InnoDB and BDB sometime last year?
Like I've said, I may be biased, but I would much rather list Oracle on my CV than MySQL.
Best of luck with your choice.
|
|
|
|
|
|
| Re: Oracle vs MsSQL [message #182239 is a reply to message #182224] |
Thu, 13 July 2006 21:58 |
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
|
Senior Member |
|
|
MS SQL = SQL Server ?
My approach is not that scientific, and I am by no means an expert in MS SQL, but here's what I'd do:
Have you already selected a hardware platform and operating system? If so, the choice for me is simple:
- Windoze: MS
- Unix: Oracle
- Mainframe: DB2
I have used Oracle before on both Unix and Windoze (server that is, not client) and it is always bliss on Unix, and nightmare on Windoze. That's personal opinion though.
If you are selecting the RDBMS before OS, then the same process works in reverse. That doesn't help you select an RDBMS though.
The differentiating features I can think of:
- Oracle is more labour intensive and requires a full-time skilled DBA with detailed knowledge of your DB setup.
- MS is cheaper (I think).
- Contract labour is plentiful for both.
- Final application build quality and performance is comparable.
- Oracle comes with some fancy add-ins that most sites will never use, but if you do then they're great.
- Oracle is arguably more scalable at the high-end.
Also, if you are building a data warehouse, then Sybase IQ and RedBrick are worth a close look. They should not be ruled out simply on the basis of relative obscurity.
Ross Leishman
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
