Replication

Replication

Post by Steven Harr » Sun, 31 Dec 1899 09:00:00



Has anyone looked into replication?

It would be nice to give users of my application the possibility to work
remotely and synchronise.

What I would like to do, is write the necessary code so I can still use my
.dbf files. I presume I need to track the timestamp and userkey to track
changes, and have some CLSID style of creating unique keys for records
that are added.

I noticed that Access 97 does this, as it uses a Random generator for the
Primary Key on replicated databases.

I guess there are lots of issues involved, and I just wondered if anyone
has looked into it before I spend time on it.

Thanks.

 
 
 

1. Merge Replication, on-demand PULL replication

I am doing replication through internet. For this, I am
using Merge replication,   On demand-anonymous PULL
subscription.

My publisher database server will have a dedicated IP
address and it is permanently connected to internet. But
the Subscriber database server will connect to the
internet using dial-up connection (32k Modem). So I went
for anonymous subscription. I am able to pull the
publication data from the subscriber and it is working
fine.

My Problem is :-- If i change the same record's same field
value at both subscriber and publisher then the
replication is NOT working properly. If a record's same
column value is changed at both publisher and subscriber
then it should be marked as Conflict and SQL server should
solve it. But in anonymous subscription it is NOT working
properly.

I got the error "The Process could not log the Conflict"

Any help greatly appreciated.

Regards,
Siva.

2. Clipper printing deleted material from memo field

3. Briefcase replication and SQL replication

4. Neat select -- but how ??

5. after replication timeout: update with identical values no replication

6. sybase?? ???? ??? ?? "||'? ??? ???

7. Replication Replication !

8. Replication fails over a VPN (Merge Replication)

9. Replication fails when replication a specific table

10. transactional replication adding replication guid to table

11. SNAPSHOT Replication -- struggle for replication views

12. Briefcase replication and SQL server replication