why we use two databases

[Barry Kelly]

what is the advantage of using two database for a single project.

The databases might have different features: local vs remote, expensive
per user / processor vs cheap vs free, etc.

-- Barry

 

[Raghu Sunkara]

hi,
what is the advantage of using two database for a single project.

Regards,
Raghu Sunkara.

 

[Family Tree Mike]

The databases may be maintained by two different departments, such as "Human
Resources" and "Network Security". Some parts of the DB are likely private
to each department.

 

[Cowboy \(Gregory A. Beamer\)]

Although this is far less of a reason with Oracle (since version ???) and
SQL Server 2005, as you have the ability to set up "schemas" (the SQL name).

--
Gregory A. Beamer
MVP, MCP: +I, SE, SD, DBA

Subscribe to my blog
http://gregorybeamer.spaces.live.com/lists/feed.rss

or just read it:
http://gregorybeamer.spaces.live.com/

*************************************************
| Think outside the box!
|
*************************************************

 

[Cowboy \(Gregory A. Beamer\)]

In most cases, there are none. Here are a couple I can think of that have
not been mentioned.

1. You want to separate out metadata from data - this is usually when you
know other apps, in the future, will use the metadata

2. You have multiple clients and need to have a separate database for each.
This is usually a legal issue, either law or contract.

--
Gregory A. Beamer
MVP, MCP: +I, SE, SD, DBA

Subscribe to my blog
http://gregorybeamer.spaces.live.com/lists/feed.rss

or just read it:
http://gregorybeamer.spaces.live.com/

*************************************************
| Think outside the box!
|
*************************************************

 

[Family Tree Mike]

It's probably more of a territorial argument than a technical argument in our
company...