Script out publication does not copy the replication SP to the subscriber

• stanley_1982

  Ten Centuries

  Points: 1251

  More actions

  October 23, 2019 at 8:03 am

  #3691222

  Hi ,

  I have configure few transactional replication  using the initialize from backup method for DB_test using the GUI wizard . i scripted out the create replication script when the replication is running fine using the "Generate Script " .

  So the problem come to me when i try to re-configure the transactional replication using the create script i scripted out .  when the replication is establish, None of the INSERT (sp_MSins_dboxxx_xxxx) , DELETE (sp_MSdel_dboxxx_xxxx) AND UPDATE SP ( (sp_MSupd_dboxxx_xxxx) )for the tables are replicated to the subscriber .   But if i re-configure the replication using the GUI , then the replication SP are created in the subscriber DB ,  i have cross checked the option to copy the insert update delete procedure to subscriber is set to true .

  I know the solution is to generate the SP manually and reapply to subscriber. I just curious anyone has experienced this before and know why is this happend ?

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  October 24, 2019 at 8:10 am

  #3691529

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.