New answers tagged

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