EchoAlertcom
IS-IT--Management
Hello,
I am struggling with Transactional Replication. I have 3 SQL2000 Servers. Two are set up to get Push Subscriptions. I think the easiest way for me to start is to explain what I need to happen.
I have 3 tables in the Publishing DB that I need to Push changes out to the two subscribers. I only want to fire Replication when specific Columns are updated, created, or deleted. Other columns in the table update all the time but I do not want that to fire the replication. Second, I only want specific Columns Replicated. When I filter by Column the columns that I deselected are dropped from the Subscription DBs. I want the specific Columns updated of rows that have changed but leave the other columns there.
When the Snapshot Initiallization occures it fails because of contraints on the table in the subscription DBs. When I alter the options during the creation of the Publisher to not drop the table and just copy the data I get an error that states that the Bulk COpy failed because of unique ID already exists.
I am frustrated and behind deadline. So any suggestions will be greatly appreciated.
Sincerely,
Steve Funk
I am struggling with Transactional Replication. I have 3 SQL2000 Servers. Two are set up to get Push Subscriptions. I think the easiest way for me to start is to explain what I need to happen.
I have 3 tables in the Publishing DB that I need to Push changes out to the two subscribers. I only want to fire Replication when specific Columns are updated, created, or deleted. Other columns in the table update all the time but I do not want that to fire the replication. Second, I only want specific Columns Replicated. When I filter by Column the columns that I deselected are dropped from the Subscription DBs. I want the specific Columns updated of rows that have changed but leave the other columns there.
When the Snapshot Initiallization occures it fails because of contraints on the table in the subscription DBs. When I alter the options during the creation of the Publisher to not drop the table and just copy the data I get an error that states that the Bulk COpy failed because of unique ID already exists.
I am frustrated and behind deadline. So any suggestions will be greatly appreciated.
Sincerely,
Steve Funk