MongoDB Atlas has capability to replicate data bidirectionally between MongoDB and SQL Server

MongoDB Atlas
1

Hi MongoDB Community Support Team,

Could you please confirm whether MongoDB Atlas has the capability to perform bi-directional data replication or synchronization in real-time without any lag between MongoDB and SQL Server databases?

We are trying to do POC on the current environment which is running on SQL Server and client takes around 90 seconds to sync the data with SQL servers. So we have divided the POC into two parts.

POC:

  1. Real-time sync using MongoDB realm feature between database and clients. – Completed
  2. MongoDB altas real-time sync with SQL Server Database. – Pending

The first POC we have completed so far and the second part of POC is still looking for some bi-directional replication between MongoDB and SQL server database.

Thanks,
Kamal Kumar

3

Yes, please look at Relational Migrator’s CDC capability for near realtime continuous sync:

https://www.mongodb.com/docs/relational-migrator/jobs/sync-jobs/#:~:text=Relational%20Migrator%20offers%20two%20different,Capture%20(CDC)%20migration%20strategy.