␡
- Configuring a Distributor
- Creating a Publication
- Creating Subscriptions
- Testing the Replication
- Summary
Like this article? We recommend
Like this article? We recommend
Like this article? We recommend
Like this article? We recommend
Testing the Replication
Now that we’ve configured replication, we can run a few SQL statements to test it. I’ll execute the following UPDATE statement on the publisher:
UPDATE dimAccount SET AccountDescription = ’work in progress’ WHERE AccountKey = 11
SQL Server informs me that this query affected one row. Next, I switch the database context to the distribution database and run the stored procedure sp_browsereplcmds. SQL Server shows the following command being delivered:
{CALL [sp_MSupd_dboDimAccount] (,,,,N’work in progress’,,,,,,11,0x1000)}
Finally, I query the subscribing database to see whether the changes made on the publisher were replicated to the subscriber:
SELECT AccountDescription FROM dimAccount WHERE AccountKey = 11 Results: AccountDescription -------------------------------------------------- work in progress