January 5, 2016 at 2:58 pm
I'm planning to upgrade from SQL Server 2008 (Server name -A ) to SQL Server 2014 (Server name - B), when restoring databases to SQL Server 2014 which has Transactional Publication - Database A with Publication can be in place with keep_replication option but how can database B with subscription be in placed when restoring?
I trying to avoid recreating 500 subscriptions.
January 6, 2016 at 8:24 pm
LearnSQL!!! (1/5/2016)
I'm planning to upgrade from SQL Server 2008 (Server name -A ) to SQL Server 2014 (Server name - B), when restoring databases to SQL Server 2014 which has Transactional Publication - Database with Publication can be in place with keep replication but how can database with subscription be in placed when restoring?I trying to avoid recreating 500 subscriptions.
I'm a little lost with the description of the environment. I understand that you have two separate SQL Server instances installed on different machines. I think I also understand that you are upgrading by restoring databases from your 2008 instance (Server A) over to your 2014 instance (Server B).
What I don't understand is your replication topology as it relates to the upgrade. I think you are saying that your 2014 instance is a Publisher in transactional replication. It can't be a Publisher for the same databases you're planning to upgrade from your 2008 instance, and that is where I am confused by the question. Can you please explain your replication topology a bit more and how that ties into the upgrade?
January 7, 2016 at 2:10 pm
Example:
SQL server 2008 R2 - Has database A, B, and C
Database A is publisher whereas database B is subscriber, when restoring to Databases A, B and C to SQL2014, I want publication and subscription to be in place(working) like nothing happened to avoid re-creating 500 subscription.
When doing in place upgrading SQL server to 2014, we are planning to rename server and SQL instance name to current server name and instance name.
January 7, 2016 at 2:14 pm
lmarkum (1/6/2016)
LearnSQL!!! (1/5/2016)
I'm planning to upgrade from SQL Server 2008 (Server name -A ) to SQL Server 2014 (Server name - B), when restoring databases to SQL Server 2014 which has Transactional Publication - Database with Publication can be in place with keep replication but how can database with subscription be in placed when restoring?I trying to avoid recreating 500 subscriptions.
I'm a little lost with the description of the environment. I understand that you have two separate SQL Server instances installed on different machines. I think I also understand that you are upgrading by restoring databases from your 2008 instance (Server A) over to your 2014 instance (Server B).
What I don't understand is your replication topology as it relates to the upgrade. I think you are saying that your 2014 instance is a Publisher in transactional replication. It can't be a Publisher for the same databases you're planning to upgrade from your 2008 instance, and that is where I am confused by the question. Can you please explain your replication topology a bit more and how that ties into the upgrade?
Example:
SQL server 2008 R2 - Has database A, B, and C
Database A is publisher whereas database B is subscriber, when restoring to Databases A, B and C to SQL2014, I want publication and subscription to be in place(working) like nothing happened to avoid re-creating 500 subscription.
When doing in place upgrading SQL server to 2014, we are planning to rename server and SQL instance name to current server name and instance name.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply