Do not use on any
shared computer
July 25, 2008 12:11am pdt
null
[x]
Attachment Details

Which of this options is better: replicate a database or share the data?

Tags: Microsot, SQL Server, 2000, Replication Best practices
Hi!
I have to integrate two databases in order to generate a solution suitable for two institutions. Each institution has its own database, one of them is a people register which is the base of the services given for the other institution...  I need to know your opinion about crossing both databases... What do you think is best, to replicate the people register from one database to another, or cross the information between both databases? This solution is very important, so I need to know what the best practices are around this...

Any help will be appreciated...

Beth
Start your free trial to view this solution
Question Stats
Zone: Database
Question Asked By: bethzycb
Question Asked On: 01.15.2008
Participating Experts: 2
Points: 250
Views: 0
Translate:
Loading Advertisement...
 
[+][-]Expert Comment by dtodd

Rank: Sage

Expert Comment by dtodd:

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
 
[+][-]Expert Comment by Lowfatspread

Rank: Genius

Expert Comment by Lowfatspread:

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
 
Loading Advertisement...
20080723-EE-VQP-34 / EE_QW_2_20070628