First, can SQL Server 2008 R2 replicate to SQL Server 2008 R2 Express Edition???
Second, I have setup replication from R2 to a SQL Server 2000 database. I defined a stand-alone table (not a parent or child) and replication worked fine. I simply changed a record and it was reflected in the 2000 database.
Next, I changed the table to be replicated to be a parent table. After I changed a record in this table, replication failed. The error message said it was unable to drop a table because it was in a relationship.
Questions. When replication occurs between a publisher and subscriber and several records in a table targeted for replication, is the table dropped in the subscriber database then copied over in its entirety??? When I define a table to be replicated,
do I have to include all the related tables???
View Complete Post