Convert postgres to SQL Server

Question

I have an SQL file generated from a Postgres database that I want to run on SQL Server 2008. The SQL file creates, drops and inserts data into tables. SQL Server returns a number of errors in the syntax.

Is there a way to make the file compatible?

If not, what is the best way to export data from Postgres to SQL Server?

serverfault.com/questions/65407/…

dMb
– dMb

2012-08-18 01:41:48 +00:00
Commented Aug 18, 2012 at 1:41 — dMb
– dMb, Commented Aug 18, 2012 at 1:41

Community · Accepted Answer · 2017-04-13 12:13:47Z

2

The best approach is usually to restore the dump to a PostgreSQL server, then copy the data out of the live server using:

A schema-only dump you hand-convert, followed by a pg_dump --data-only --inserts dump that might load as-is if you're lucky, and otherwise can be machine converted with text processing tools; or
A dedicated conversion tool if you can find one for Pg -> MS SQL. Maybe the MS SQL ODBC dump/export tool referred to in the linked post is a special case of an ETL tool.
Usually better, use ETL tools like Talend or Pentaho to aid in the conversion.

edited Apr 13, 2017 at 12:13

CommunityBot

11 silver badge

answered Aug 18, 2012 at 1:49

Craig Ringer

329k84 gold badges742 silver badges820 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Convert postgres to SQL Server

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related