What are possible ways to migrate SQL Server DB to PostgreSQL DB? [closed]

Posted on

Question :

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

Answer :

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.

Leave a Reply

Your email address will not be published.