Advertisement

01.15.2008 at 02:04PM PST, ID: 23085542 | Points: 250
[x]
Attachment Details

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

Asked by bethzycb in MS SQL Server, Data Manipulation, Data Mining

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...

BethStart Free Trial
[+][-]01.15.2008 at 02:19PM PST, ID: 20667310

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]01.15.2008 at 07:19PM PST, ID: 20668963

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628