RE: Oracle to MSSQL conversion?

What SQL Server calls databases I think of them as schemas in Oracle.

Suhen

-----Original Message-----
[mailto:Stephen.Wolfe_at_macdill.af.mil]
Sent: Friday, 1 August 2003 4:10 AM
To: Multiple recipients of list ORACLE-L

Yes, MSSQL is running as an instance and you can multiple instances on the same server (that is W2K or 2003 server), each instance is SQL server consuming it's predefined resources. Each instance of MSSQL can be servicing different databases.

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: Boivin, Patrice J [mailto:BoivinP_at_mar.dfo-mpo.gc.ca]
> Sent: Thursday, July 31, 2003 1:39 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Oracle to MSSQL conversion?
>
>
> I haven't heard of an SQL Server instance before... do you
> mean a SQL Server server?
>
> (this is getting a bit confusing)
>
> Patrice.
>
> -----Original Message-----
> Sent: Thursday, July 31, 2003 1:19 PM
> To: Multiple recipients of list ORACLE-L
>
>
> > 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: Boivin, Patrice J
> INET: BoivinP_at_mar.dfo-mpo.gc.ca
>
> 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Suhen Pather
  INET: suhen.pather_at_marcglobal.com.au

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).