Share via

Scripting out 'Create Merge Replication' does not include 'processing_order'

Greg Youdale 5 Reputation points
2024-05-03T03:20:20.6466667+00:00

We use Merge Replication and have defined a specific 'processing_order' for the Articles in the Publication. The Articles include tables, functions and stored procedures.
When we want to setup or refresh a test environment, we will script out the 'Create Replication' script from our production environment, such that we can recreate the same Publication in our test environment.
The problem is that the generated 'Create Replication' script does not include the 'processing_order' parameter for any function or stored procedure Article, even though it is a parameter of those Articles. The script generated does however include the 'processing_order' value for table Articles.
This causes us to maintain separate 'processing_order' scripts for each version and having to remember to execute the correct script after the Publication has been (re)created. With 200+ function and stored proc Articles, that extra script takes hours to run !
If the function and stored proc 'processing_order' value was also included in the 'Create Replication' script, it would be a very simple and fail-safe way of recreating the Publication.
Does anybody know why 'processing_order' for functions and stored proc are omitted and can the SQL Team be notified of this omission? ?

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

0 comments No comments

1 answer

Sort by: Most helpful
  1. Anonymous
    2024-05-03T08:56:00.9833333+00:00

    Hi @Greg Youdale,

    Thanks for your information.

    I've checked the article of Understanding Merge Replication article processing order and Checking the Merge Replication properties. We can get the information:

    User's image

    In addition, I found this article, you can try the methods step by step and check out the links this article provides to resolve your issue.

    I am not an expert in this field, if I have any misunderstandings, please feel free to share with us here. Thanks for your understanding. We are looking forward to hearing from you to assist further.

    Best regards,

    Lucy Chen


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    https://docs.microsoft.com/en-us/answers/support/email-notifications

    Was this answer helpful?


Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.