Verify that data is not replicating before troubleshooting a replication failure.
- Log in to the primary and replicate databases using isql.
- Execute select commands that
select the replicate columns from the replicate table and the columns
to be replicated from the primary table.
- Compare the data from both tables to see if it is
the same.
Incompatible data means that the system is not replicating properly. If the subscription has many columns that are replicated,
use rs_subcmp to compare data in the
primary and replicate databases.