We are, however, mirroring the database within site 1. We are not mirroring at site 2. I'm thinking merge replication might be better than transactional with queued updates.

Migrate SQL Server database to SQL Database using transactional replication When you need to cannot afford to remove your your SQL Server database from production while the migration is occurring, you ...

SQL Server 2012 then borrowed this columnar processing technique for its own use. As an example of how the new SQL Server could speed performance, Kelly explained how a retail chain could benefit ...

Previous replication technologies, such as SQL transaction replication, work within applications or at the hardware layer.

SQL Server transaction replication technology can be used to realize real-time data synchronization, meet the real-time demand of local enterprise and cloud platform data synchronization, and provide ...

When you need to cannot afford to remove your your SQL Server database from production while the migration is occurring, you can use SQL Server transactional replication as your migration solution.