How can I restore a microsoft sql server database backup to postgres?

10,560

I would start with this article from the Postgresql site

Share:
10,560

Related videos on Youtube

user158092
Author by

user158092

Updated on September 18, 2022

Comments

  • user158092
    user158092 over 1 year

    I need to take a Microsoft SQL Server database backup (dump) file and import/restore into a PostgreSQL database. Does anybody have some sort of transform script (maybe a perl/sed/awk script) that could be run on the MSSQL Server backup file, so that it could be restored to the PostgreSQL database? Let's assume the tables have already been created in postgres, but they are all empty.

  • user9517
    user9517 over 11 years
    We really do prefer that answers contain content not pointers to content. Whilst this may theoretically answer the question, it would be preferable to include the essential parts of the answer here, and provide the link for reference.