SQL Server replication migration from sql 2012 to 2019

• SQL_Hunt

  SSC-Dedicated

  Points: 33518

  More actions

  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.

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  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.

• WHug

  Ten Centuries

  Points: 1248

  More actions

  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

• SQL_Hunt

  SSC-Dedicated

  Points: 33518

  More actions

  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.