December 22, 2003 at 9:09 am
How can I create a Subscription to a Transactional Replication Publication on the same database?
When I try to use the Push Subscription Wizard and select the same database used as the publisher, I get an error message that reads: "The subscription database cannot be the same as the publication database."
The publisher is trying to replicate a table within this database to another table within the same database. I found this plausible as I read in Pro SQL Server 2000 Programming by Robert Vieira page 809 that "SQL Server alllows a server to subscribe to its own published articles." No details were given regarding what type of replication this applied to (push/pull or trans/snap/merge) so I assumed this would work for our Push Transactional Replication scenario.
Please, any assistance would be greatly appreciated. (A sort of Forum Christmas Gift to Me)
December 22, 2003 at 9:13 am
You can publish and subscribe in the the same server, but not in the same databases.
You can use that between two different databases...
December 22, 2003 at 9:25 am
Would a trigger serve your purposes, or is there data transformation that would cause too much overhead?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply