> -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
