SQL Server replication migration from sql 2012 to 2019

  • Hello

    I need to migrate existing sql server 2012 replication to the SQL Server 2019 instance.

    Can anyone please help with a robust scripts to extract all the publishers and subscribers to run against the new environment (sql 2019) and getting the replication established properly?

     

    Thanks.

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

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

  • SQL Server Management Studio has a wizard for scripting out replication.  While this reply doesn't satisfy your requests for a tsql method, if you are in a hurry try the Replication Wizard out.  Right click on the Replication folder and select Generate Scripts.

    See Scripting Replication in https://docs.microsoft.com/en-us/sql/relational-databases/replication/scripting-replication?view=sql-server-ver15

    --Will

  • Thanks, Wei. But using the Wizard we can extract the Publication, but it does not provide an option to extract the subscriptions. Any possible method to script out the subscriptions?

    Thanks.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply