Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How reliable is SQL Server 2000's replication?
Message
De
30/08/2005 14:02:28
 
 
À
30/08/2005 08:00:11
Rene Lovino
Bigfoot Global Solutions, Inc
Cebu, Philippines
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Réplication
Divers
Thread ID:
01044987
Message ID:
01045254
Vues:
21
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform