Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Merge Replication

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-08-24 : 07:37:33
Abhijeet writes "Hi there.

I am replicating 2 tables from A SQL Server to B SQL Server
The replication type is Merge Replication.

Case - 1
When I entered the data in 2 tables thro' windows application connected to SQL server A.
The automatic merge replication is set, so it should replicate with the 2 same tables in SQL Server B.
Instead of that after few times the record is deleted from SQL Server A.

Case - 2
When I entered the data in 2 tables thro' web application connected to SQL server B.
The automatic merge replication is set, so it should replicate with the 2 same tables in SQL Server A.
It properly replicates with SQL Server A.

My problem is in Case-1 why the record gets deleted?
and what do I have to do to replicate the data from Server A to Server B

SQL Server A - Publisher-Distributor
SQL Server B - Subscriber
SQL Server Ver 2000 at both ends

Pl Assist.
Warm Rgds"
   

- Advertisement -