I'm an Oracle DBA learning to be a SS DBA; here's my $.02 worth:
1. Both databases have their place here; web apps tend to have smaller
dbases and use SqlServer due to licensing issues. Oracle is used for
warehouse databases and those requiring oracle options such as
partitioning, parallel query, etc.
2. We have oracle on NT databases; you may want to go this way at first
so you just have the DB to learn.
3. Try to develop your app without using features included in oracle
Enterprise Edition; this is very pricey compared to Standard Edition.
You can get the prices and features included in each on
technet.oracle.com. Enterprise edition is required for the add-on
options like partitioning (great stuff for large dbs), which is the only
option we currently license.
4. Oracle has a tool 'Migration Workbench'; research it on
technet.oracle.com; it's free, but won't convert your TSQL. There is no
tool that I'm aware of to do that.
5. I've read that a good book is "Oracle 8i and Microsoft SQL Server
Integration" by Stephen Chelack
good luck,
mary
-----Original Message-----
From: Ken Nickels [mailto:[Email Address Removed] Wednesday, August 07, 2002 12:42 PM
To: '[Email Address Removed] Converting from Sql Server to Oracle
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
---------------------------------------------------------------------
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page