Friday, February 17, 2012

Cost of development for MSSQLS vs. Oracle

Many thanks to all who posted to my query regarding MSSQLS vs. Oracle.
You comments have been of great use.
We are fairly from the responses to the thread, that MSSQLS is both the
easiest to maintain and develop with.
MSSQLS users go Hooray !
ORACLE users go BOO!
:-)
What points can we make to our client to establish for them that development
on the Oracle platform would be more expensive than developing an MSSQLS
application ?
ADO is native to Microsoft products and therefore easier ?
Integrated security with NT is better ?
Server Administration is easier ?
Thanks again folks, it really is much appreciated.
Alex, England
Alex Stevens wrote:
> What points can we make to our client to establish for them that development
> on the Oracle platform would be more expensive than developing an MSSQLS
> application ?
Send them to Monster and tell them to look at the salary ranges for
either discipline...
D.
|||"Alex Stevens" <alex@.matrixinfotech.co.uk> wrote in message news:W_mt5.6906$ly4.33806@.NewsReader...
> Many thanks to all who posted to my query regarding MSSQLS vs. Oracle.
> You comments have been of great use.
> We are fairly from the responses to the thread, that MSSQLS is both the
> easiest to maintain and develop with.
> MSSQLS users go Hooray !
> ORACLE users go BOO!
> :-)
> What points can we make to our client to establish for them that development
> on the Oracle platform would be more expensive than developing an MSSQLS
> application ?
> ADO is native to Microsoft products and therefore easier ?
> Integrated security with NT is better ?
> Server Administration is easier ?
> Thanks again folks, it really is much appreciated.
> Alex, England
>
Alex,
I have developed with database apps with ado using MSAccess, MSSQL, ORACLE and db2. I really don't think there is much of a
difference between MSSQL and Oracle when it comes to application development. ADO is ADO. ANSI SQL is ANSI SQL (assuming you are
at 8i or higher, with 9i providing standard join syntax). Code for calling an SP and using the data is the same. I think it is a
wash when it comes to development.
The real question is on of total cost of ownership. Here, MSSQL probably has an edge. You need to look at hardware, licensing,
DBA's, backup and recovery, replication, etc. in order to justify one over the other with respect to true cost of ownership.
Al Reid
How will I know when I get there...
If I don't know where I'm going?

No comments:

Post a Comment