# Auto-fill Postgres Database via SQL Server datas

**URL:** <https://forum.elixirforum.com/t/auto-fill-postgres-database-via-sql-server-datas/46780>\
**Category:** Questions\
**Tags:** databases, postgres, mssql, auto-fill, synchronize\
**Created:** [March 24, 2022, 5:27am UTC](https://forum.elixirforum.com/t/auto-fill-postgres-database-via-sql-server-datas/46780 "2022-03-24T05:27:52Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![csadewa](https://forum.elixirforum.com/user_avatar/forum.elixirforum.com/csadewa/32/24535_2.png) [@csadewa](https://forum.elixirforum.com/u/csadewa)\
**Post date:** [March 24, 2022, 9:25am UTC](https://forum.elixirforum.com/t/auto-fill-postgres-database-via-sql-server-datas/46780/2 "2022-03-24T09:25:36Z")

</div>

Hmmm, the question is syncing data between two database. I don’t think this is a problem to be solved exclusively with elixir. Considering you only have read only access to SQL server, tools like Debezium ([https://debezium.io/](https://debezium.io/)) which Change Data Capture probably wouldn’t work (if you could use Debezium, you could capture data from SQL server and write it to PostgresDB).

In the past, what i have done is making a data pump (which is inspired by [Ingest data from a relational database | Elastic Docs](https://www.elastic.co/guide/en/cloud/current/ec-getting-started-search-use-cases-db-logstash.html)) which periodically read from source DB (SQL Server) (limited by last updated\_at/inserted\_at), and write the data to sink DB (PostgreSQL in this case).

---

_[View the full topic](https://forum.elixirforum.com/t/auto-fill-postgres-database-via-sql-server-datas/46780)._