Best way to transfer a few tables from reserve server to production
1
vote
1
answer
379
views
We have two MS SQL Servers (2012 Standard Edition on Windows 2012 Server) which are located in the same subnet. One is **production** server. Another is **reserve** server.
Currently there is a transactional replication between two databases on these servers where **production** server is
Publisher
and Distributor
and **reserve** server is Subscriber
.
On **production** server every night runs some tasks which inserts to (or updates) about of 5 tables one of them is about 6 Gb.
We would like to move this tasks to **reserve** server and create on one another database with the same scheme. Then when tasks upload data to another database we need to synchronize one with **production** database on **production** server.
**One moment :** For supporting actual data we must to include another database on **reserve** in replication as Subscriber
from **production** server.
As one way we consider linked server
:
1. Truncate table on production (in one table there is FKs, so we can't)
2. Insert data from another database
**Edit:** How about linked server
and merge
functionality?
How do you think are there the better way?
Asked by Konstantin
(119 rep)
Oct 6, 2014, 11:16 AM
Last activity: Aug 1, 2025, 03:02 PM
Last activity: Aug 1, 2025, 03:02 PM