none
Scripting Out replication Publication/Subscription - and SQL agent jobs RRS feed

  • Question

  • Fellow SQLers

    I am needing to rebuild a SQL 2008 R2 replication model onto SQL 2016 - same exact pubs and subs.

    My approach was scripting out the publication and scripting out the subscription.

    Then changing the server info in each of the scripts.

    But, I do not see the agent jobs being inside these system generated scripts.

    I am interpreting that I would need to script out each of the replication SQL Agent jobs manually and make the server name changes inside.

    Am I missing something on generating scripts for SQL Agent or should they be included when I created the publisher script?

    Thanks,

    MG

    Friday, November 8, 2019 3:16 PM

Answers

  • This is correct, when you run the script on the new server it will recreate the SQL Server agent jobs it needs. You do not need to script them out.
    • Marked as answer by mg101 Friday, November 8, 2019 4:38 PM
    Friday, November 8, 2019 4:07 PM
    Moderator

All replies

  • This is correct, when you run the script on the new server it will recreate the SQL Server agent jobs it needs. You do not need to script them out.
    • Marked as answer by mg101 Friday, November 8, 2019 4:38 PM
    Friday, November 8, 2019 4:07 PM
    Moderator
  • Thanks Hillary!!!!

    MG

    Friday, November 8, 2019 4:38 PM