Post reply

SQL Server replication migration from sql 2012 to 2019

  • May 16, 2022 at 8:41 pm

    #4033937

    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.

  • May 17, 2022 at 9:10 pm

    #4034554

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

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

  • May 18, 2022 at 4:05 pm

    #4035068

    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

  • May 18, 2022 at 4:13 pm

    #4035072

    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 3 (of 3 total)

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