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

Question

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.

score 2 · Answer 1 · answered Feb 08 '13 at 05:21

2

I would start with this article from the Postgresql site

answered Feb 08 '13 at 05:21

trent

3,114
19
17

1

We really do prefer that answers contain content not pointers to content. Whilst this may theoretically answer the question, [it would be preferable](http://meta.stackexchange.com/q/8259) to include the essential parts of the answer here, and provide the link for reference. – user9517 Feb 08 '13 at 08:44

score 0 · Answer 2 · edited May 23 '17 at 12:41

0

You could export data from MSSQL in CSV format (using MSSQL Enterprise Manager) and then import the CSV files into Postgresql (here there is an example). I suggest to export one CSV per table, so you can better manage any constraint rule.

edited May 23 '17 at 12:41

Community

1

answered Feb 08 '13 at 08:39

lg.

4,649
3
21
20

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

2 Answers2