RE: Oracle to MSSQL conversion?

> -----Original Message-----
> From: ml-errors_at_fatcity.com [mailto:ml-errors_at_fatcity.com]On Behalf Of
> Boivin, Patrice J
> Sent: Thursday, July 31, 2003 12:59
> 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?

The closest analogy is Filegroups. Serve very similar purpose (to abstract the physical storage), but aren't quite as sophisticated (no surprises there)

> (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?

No practical limit on schemas, don't know about Filegroups. Be warned that some people will try to convince you an Oracle schema equates to a SQLServer database. They're talking rubbish. A schema is a schema in both.

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