Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: DB Structure Oracle compared to SQL Server

Re: DB Structure Oracle compared to SQL Server

From: <euan.garden_at_gmail.com>
Date: 14 Feb 2007 19:41:50 -0800
Message-ID: <1171510910.305818.157060@p10g2000cwp.googlegroups.com>


On Feb 14, 11:01 am, DA Morgan <damor..._at_psoug.org> wrote:
> Robert Klemme wrote:
> > On 14.02.2007 10:51, sybrandb wrote:
> >> What is the business case for 4 databases? Oracle != sqlserver, a
> >> *schema* in Oracle is a *database* in sqlserver. You don't need 4
> >> databases.
>
> > I am in doubt whether this is still true withSQL Server2005.
>
> It is!
> --
> Daniel A. Morgan
> University of Washington
> damor..._at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org

Close but wrong. A schema in SQL Server 2005 is like a schema in Oracle, a database in Oracle is like an instance in SQL Server in some ways and like a database in other ways. The schema answer is easy, the database one is more complex. Received on Wed Feb 14 2007 - 21:41:50 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US