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

  • 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 '19 at 10:12
  • 1
    You can try this: dalibo.github.io/sqlserver2pgsql – a_horse_with_no_name Oct 1 '19 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 '19 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.

| improve this answer | |

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