May 16, 2022 at 8:41 pm
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
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
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
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy