Hi

I'm a DBA in a small startup company specializing in backend services -
provisioning and billing - for internet telephony devices (cable modems,
etc.). I've been tasked with doing a study on the cost and feasabitlity of
converting our database servers from sql server to Oracle. Seems to me the
driving force is perception from outside our company (the people we'd like
to buy us) that we would be more attractive "if only" we used Oracle. Sql
Server does not scale they say, etc., etc. So we are trying to get bought.

1. I (we) are perfectly happy with sql server. 2. I know nothing about
Oracle. I would like to know if anyone here has any personal experience with
this conversion process, knows of any links, stories, how-to's, etc.
Eventually I will call Oracle and deal with their sales people (gulp).

We are a 100% Microsoft shop with Windows 2000, sql server 2000 live/standby
config, IIS web farm, C++ apps as cgi programs, app servers and middle tier
com components. 100% of the sql is T-Sql via stored procedures.

Are there Oracle conversion tools for this? Will the T-sql convert to
Pl-sql? Is there a tool for this? Or will it all have to be re-written from
scratch? Also a concern is true load sharing. Sql server is pretty much
live/standby. I gather from Microsoft that this is a tough nut to crack and
no one really has a good implemetation of it. Distributed partitioned views?
Doesn't sound that great to me. So folks keep mentioning Oracle. What do
they have?

Well, thank for reading this. Any help or links would be greatly
appreciated.

Regards:

Ken Nickels
Gemini Voice Solutions


MS Sql Server LazyDBA home page