New answers tagged transactional-replication
1
It's a question of preference. Please see below some advantages/disadvantages I found working with each of them.
Replication (Transactional) - works excellent as long as you don't need to touch the table. It's real time so you will make your developers/testers really happy with "fresh", almost real-time data. It becomes tricky if you need to add a column, ...
2
You don't really migrate a replication topology. You simply recreate it among the new servers. Script out your replication configuration and re-create it among the new servers. So backup, and restore, followed by replication setup with ordinary initialization of the subscriber from a new snapshot.
It's possible, but more complicated, to skip the ...
Top 50 recent answers are included
