July 10, 2012 at 12:44 pm
Folks, i am trying to establish transaction replication .
DB1 and DB2 have similar tables and there is a chance of having few common rows .they exist on two different servers.I want to establish transactional replication to db3 (subscriber) from db1(publisher) & db2(publisher).My idea was to create db3 tables with additional column source and place primary key over that,and manually insert data from db1 tables and db2 tables by mentioning source name while inserting and then establish transactional replication from db1,db2 to db3.i want to include the new column source in the store procedures created by transaction replication by altering them .
After performing the whole procedure i am not seeing new inserts in the subscriber.please suggest me whether i am missing some steps which i need to implement
July 10, 2012 at 2:02 pm
Wow, that's a whole lot of stuff. Why not just replicate to two different table names and then union all the results together in a view for querying?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply