why we use two databases

  • Thread starter Thread starter Barry Kelly
  • Start date Start date
B

Barry Kelly

Raghu said:
what is the advantage of using two database for a single project.
Click to expand...

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

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

Regards,
Raghu Sunkara.
 
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.
 
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!
|
*************************************************
 
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!
|
*************************************************
 
It's probably more of a territorial argument than a technical argument in our
company...
 
Back
Top