I
I
ilya_oktane2021-08-17 09:12:35
Database administration
ilya_oktane, 2021-08-17 09:12:35

How to migrate ms sql with replication subscribers to new server?

windows server 2012 r2, sql server 2012 standart, there are 12 subscribers (replication configured by merge). We are planning to migrate to windows server 2016 with sql server 2016 standart and install filters on subscribers. There is a plan:
Link the new and old database on the servers, create one subscriber, create a new database for it and switch it in the trading database, so in turn with each subscriber so as not to stop trading. After the transfer, insert into the new database the data that was transferred to the old database with a query like INSERT INTO table (1,2,3...) SELECT (1,2,3...) FROM RemoteServer.RemoteDB.dbo.table, so with all tables. Did I describe everything correctly and everything will be fine? And are there other options? For example, can I add a new server as a subscriber to the old server and use the new one as a distributor? Then I can simply delete the subscriber in the old server and add it to the new one, so the data will go?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Alexey Dmitriev, 2021-08-17
@SignFinder

No one will give you a guarantee that everything will go well if you undertook to do a job in which you "swim".
For seamless migration, there are AlwaysOn availability groups, there is also database mirroring.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question