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.

  1. 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
  2. Which tool have you successfully used to complete such tasks?

Thank you

closed as too broad by mustaccio, John Eisbrener, MDCCL, Colin 't Hart, Laurenz Albe Oct 2 at 6:19

Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

  • 1
    Convert your DDL scripts from SQL Server to Postgres. Export the data to flat files. Import them in Postgres using copy – a_horse_with_no_name Oct 1 at 10:12
  • 1
    You can try this: dalibo.github.io/sqlserver2pgsql – a_horse_with_no_name Oct 1 at 10:40
  • If source have stored procedures of functions best possible way is to migrate that parts manually. Regex replaces or such automatic replacing methods just doesn't work – Sahap Asci Oct 1 at 12:56

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.

Not the answer you're looking for? Browse other questions tagged or ask your own question.