Transactional Replication Initialization Limits for Small-Database Migration
When planning a minimal-downtime migration for a small application database, transactional replication keeps the publisher online during the move, but the choice between snapshot and backup initialization introduces a distinct trade-off between blocking risk and setup complexity. Snapshot initialization can briefly lock schema objects and may interfere with
microsoftsqlserver