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 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.