Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Need to replicate my DB on 5 branches into 1 DB at HO
Message
From
23/05/2006 01:56:44
 
 
To
23/05/2006 00:45:51
James Blackburn
Qualty Design Systems, Inc.
Kuna, Idaho, United States
General information
Forum:
Microsoft SQL Server
Category:
Replication
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01124167
Message ID:
01124185
Views:
6
Hi James, Thanks for prompt reply!

Q:Do you need real time replication or periodic?
A:Yes, I need real time replication

Q:Do you need to replicate from head office to Branch A or B…?
A:No, what I need is to replicate DB from branches (A,B,C,D,E) to Head Office.
Q:Do you need to replicate from Branch A to B or C…?
A:Yes, I need is to replicate DB from branches (A,B,C,D,E) to Head Office.

Q:Is it possible that a user at head office will change a row that also will be changed at one of the branches?
A:Yes

Do you need to have any of the data partitioned? For example, some data from A will go to C but not B,D, or E?
A: No.

FYI, I had 4 choices whether I use Sybase ASA 7 (Sorry, I dont have new version) or SQL Server or Oracle 10g Express version or MySQL 5..

Do you have any idea? and can you suggest me what DB system should I use to accomodate the above requirements? ..

Your prompt reply would be appreciated!..

Thanks a lot in advance

Regards,
Winanjaya
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform