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