Hasimbola
Comparizon and synchronization of two database SQL Server and Postgres
Hello everybody,
I use two databases:
SQL Server and Postgres
I want to compare and Synchronize value in SQL Server and Postgres
Can somebody help me or given to me a directive about it because I don’t know how it works at all
Thanks! 
Most Liked
al2o3cr
There are lots of ways to approach a problem like this.
The first one is to avoid it entirely: add code to whatever’s writing to the SQL Server database to either write to the Postgres DB directly, or to invoke an API / send an event / etc that does the write to Postgres.
Another option would be to use an off-the-shelf Change Data Capture (CDC) tool for SQL Server to (again) send changes to a system you build that writes to Postgres.
Since you’re discarding data that’s written from the Postgres side, yet another option would be a Foreign Data Wrapper (FDW) that allows Postgres to query the SQL Server DB from Postgres. For instance, the Postgres docs call out tds_fdw specifically for SQL Server.
Popular in Questions
Other popular topics
Latest on Elixir Forum
Sponsor Spotlight
We build reliable cloud platforms for business-critical systems.
Categories:
Sub Categories:
Forums
Our Sponsors
Build Elixir applications with speed and confidence.
Supporting innovation across the BEAM ecosystem.
We build reliable cloud platforms for business-critical systems.
Catch errors, track performance, monitor hosts and more.
Practical resources that improve the lives of professional developers.
Develop your skills with books, videos, and courses.
Producing high quality Elixir screencasts since 2017.
Courses that'll move you from confusion to "Aha, now I get it!"