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.
| Author |
Topic |
|
asifarion
Starting Member
3 Posts |
 Posted - 2010-07-17 : 02:55:09
|
I have Two Machines (PC1 and PC2) and installed Sql Server 2005 on both. I initialized a ‘Merge Publication ‘ on PC1; Publication database was “db_Inventory” .I ticked the check boxes “Create a snapshot immediately” and” Schedule a snapshot Agent to run at the following times” and changed the schedule to occur every 5 minutes Daily. I want to Subscribe this Publication on a database ‘Master’ which is created on PC2. For that purpose I created a Subscription on PC1 (Subscriber and Subscription database is PC2 and Master. ) successfully. I inserted new records to db_Inventory using My Accounting Software that is running on PC1. The problem I’m facing is that the newly inserted records to Publication database are not getting inserted in the Subscribing database Master. But I can insert records to this database by simply changing the Database connection in My Accounting Software (The two databases having same structure).For testing purpose, I created a new database Master_B on PC1 and created a new subscription for that db. In this case, all records I inserted to db_Inventory are getting added in Master_B. I don’t know how to solve this issue. Help me pls……. |
|
|
|
|
|
Replication on SQL Server 2005