RE: Oracle to MSSQL conversion?

I think I understand what you have said, Oracle runs an instance per database where MSSQL is one instance running multiple databases. Is this right thinking?

v/r

Stephen S. Wolfe, GS-11, DAFC
Data Services Manager
stephen.wolfe_at_macdill.af.mil
(813) 827-9974 DSN 651-9974
> -----Original Message-----
> From: Grant Allen [mailto:grant_at_towersoft.co.uk]
> Sent: Thursday, July 31, 2003 12:19 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Oracle to MSSQL conversion?
>
>
> > Maybe now is a good time for me to ask these question since it is
> > related to this thread's subject, can you say that an
> Oracle instance
> > is essentially the same as a MSSQL database? I ask this because a
> > MSSQL server can support multiple databases which can be configured
> > different
> > ways.
>
> But there are more things that the SQL Server database has
> controlled by its instance than things it can set itself
> (e.g. performance parameters, security settings, user sort
> space, processor affinity, connection handling etc. etc. are
> all instance settings). It's more accurate to say that an
> Oracle instance is closer to a SQL Server instance than a
> database, but is by no means exactly the same. Oracle just
> doesn't have the concept of multiple database support in one
> instance (and I mean database, not schema). That's not
> necessarily a bad thing, just means they are different to SQL
> Server (and DB2, Informix, Sybase and others which all have
> this). I'll stop there ... enough people on the list have
> heard my rant about this before :-)
>
> Ciao
> Fuzzy
> :-)
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Grant Allen
> INET: grant_at_towersoft.co.uk
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru')
> and in the message BODY, include a line containing: UNSUB
> ORACLE-L (or the name of mailing list you want to be removed
> from). You may also send the HELP command for other
> information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Wolfe Stephen S GS-11 6 MDSS/SGSI
  INET: Stephen.Wolfe_at_macdill.af.mil

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).