If anyone can solve this please respond immediately.
I am facing a problem when i am doing Replication on Remote Database and the Desktop Database.
1. Publisher will be there in Remote Database
2. In the Remote Database we will have the information related to the all hospitals and their Hospital_id will be there in the table.
3. In the Desktop table we will have the information related to his hospital, all the tables will be having their specified Hospital_id.
The actual need is
1. Here i am using Pull subscription
2. Replicating the Desktop database based on their specified DesktopHospital_id with the Remote Database Hospital_id where the Hospital_id should match in both the databases.
3. If there is any conflicts we need to handle them based on certain conditions.