Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How reliable is SQL Server 2000's replication?
Message
From
30/08/2005 14:02:28
 
 
To
30/08/2005 08:00:11
Rene Lovino
Bigfoot Global Solutions, Inc
Cebu, Philippines
General information
Forum:
Microsoft SQL Server
Category:
Replication
Miscellaneous
Thread ID:
01044987
Message ID:
01045254
Views:
22
Hello Rene,

Do you replicate from Korea to Los Angeles and Philippines? Wow! Isn't that slow or very slow? What happens when the connection between the servers is broken? Do I have to take any special considerations for my tables? Say, the type of primary keys or referential integrity?

Sorry, for the many questions but I guess I need to do replication in the near future and I want to be very well documented.

Thank you very much,

Luis



>Hi Luis,
>
>I have tried using replication in SQL Server 2000. I have use the transactional replication and it works fine.
>I have no problem with it. The transactional replication works for me. I did not tried merge replication.
>
>I have tried replication of db from our data center in Korea to data center in Los Angeles and Philippines using transactional replication and it works fine.
>
>
>
>>I have a SQL Server DB that I want to be replicated in two other geographically distant buildings. What are the pre-requisites for the DB to be ready for replication? I want to use replication that updates, say, every 15 minutes data for all the DB tables.
>>
>>TIA,
>>
>>Luis
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform