What are possible ways to migrate SQL Server DB to PostgreSQL DB? Currently I am assigned to complete the task of migrating several small to large databases (from 10GB to 200GB) from SQL Server to PostgreSQL RDBMS.

I would like to ask the community to share experience of migration.


Are there free ways to migrate? I am aware of creating SSIS solution
but it seems that there I have to migrate table by table
Which tool have you successfully used to complete such tasks?


Thank you
You can try to use Foreign Data Wrapper and tds_fdw

Or you can try pgloader.

Both work perfectly, are easy to set up and are packaged on any serious Linux distributions.