RE: Oracle to MSSQL conversion?

An Oracle database with multiple applications using different schemas in the same database would be close to the SQL Server model.

Ron Smith

-----Original Message-----
[mailto:Stephen.Wolfe_at_macdill.af.mil]
Sent: Thursday, July 31, 2003 10:55 AM
To: Multiple recipients of list ORACLE-L

Being more of a SQL 2000 DBA (I am experienced from SQL Server 6.5).

At my installation I have 5 SQL-2000 database machines and recently acquired three Oracle 9i machines.

The limit is essentially a function of your storage area and the amount of real memory available to the processor or processor array.

I'm trying to draw similarities between the RDBM concepts now as I learn Oracle's idea of a database.

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.

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 7:59 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Oracle to MSSQL conversion?
>
>
> I have a question re. these conversions...
>
> If an Oracle database has 120 tablespaces, how does that
> translate in MSSQL speak?
>
> (One of the tablespaces is USERS, home of dozens of schemas;
> the others are either RB, SYSTEM, TEMP or application tablespaces)
>
> How many separate schemas-tablespaces can MSSQL hold per server?
>
> Patrice.
>
> -----Original Message-----
> Sent: Thursday, July 31, 2003 7:34 AM
> To: Multiple recipients of list ORACLE-L
>
>
> I know Microsoft is offering a new course called 'Microsoft
> SQL Server 2000 for Experienced Database Professionals'. It
> is aimed at DBAs with experience with Oracle, DB2, Sybase
> etc. who want to know more about SQL Server.
>
> You can read more about this course at
> http://www.microsoft.com/traincert/syllabi/2723afinal.asp.
>
> Gudmundur
>
> > Hello,
> >
> > There is alot of talk about multi-skilling/reskilling going on here
> > at my company. We use Oracle and MSSQL dbs. I have been wondering if

> > anyone is aware of a resource that shows the oracle programming
> > technique and what the corresponding MSSQL programming technique is.

> > ie
> > Oracle defines variable : MSSQL defines variable
> > Oracle cursor looks like this : MSSQL cursor looks like this.
> > Oracle uses rollbacks : MSSQL uses "MSSQL rollbacks"
> > etc
> > Hope you all understand what I mean.
> >
> > TIA
> > Denham Eva
> > Oracle DBA
> > Linux like TeePee... No Windows, No Gates and Apache inside!
> >
> >
> > ______________________________________________________________
> > _______________________
> > This e-mail message has been scanned for Viruses and Content and
> > cleared by MailMarshal
> >
> > For more information please visit www.marshalsoftware.com
> > ______________________________________________________________
> > _______________________
> >
> > ##############################################################
> > #######################
> > Note:
> > This message is for the named person's use only. It may contain
> > confidential, proprietary or legally privileged information. No
> > confidentiality or privilege is waived or lost by any
> > mistransmission. If you receive this message in error, please
> > immediately delete it and all copies of it from your system, destroy

> > any hard copies of it and notify the sender. You must not, directly

> > or indirectly, use, disclose, distribute, print, or copy any part of

> > this message if you are not the intended recipient. TFMC and any of
> > its subsidiaries each reserve the right to monitor all e-mail
> > communications through its networks.
> >
> > Any views expressed in this message are those of the individual
> > sender, except where the message states otherwise and the sender is
> > authorized to state them to be the views of any such entity.
> >
> > Thank You.
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Denham Eva
> > INET: EvaD_at_TFMC.co.za
> >
> > 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: Gudmundur Bjarni Josepsson
> INET: gbj_at_index.is
>
> 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: Smith, Ron L.
  INET: rlsmith_at_kmg.com

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