Posted by Ed Murphy on 11/23/06 09:11

Engada wrote:

> I have a database which has been running in PostgreSQL for a number of
> years at this stage which I want to port into MS SQL server.
>
> It seems that the SQL that Postgre outputs when I do a backup is not
> syntactically correct within MS-SQL server.

pg_dump has a number of flags that may help, e.g. --inserts

What specific types of syntax errors do you encounter?

Googling (PostgreSQL export) turns up some third-party programs designed
to simplify this type of port.

• Next in forum: Re: Help with FOR XML - How do I return the results like this?
• Prev in forum: Re: Pls Help With JOIN query...
• Thread view: Re: Converting database to MS-SQLServer from PostGRESQL

[Reply to this message]