Re: Importing dump file from MS SQL to PSQL 9.3 - Mailing list pgsql-novice

From CaT
Subject Re: Importing dump file from MS SQL to PSQL 9.3
Date
Msg-id 20150823115014.GG5128@zip.com.au
Whole thread Raw
In response to Importing dump file from MS SQL to PSQL 9.3  (Freeda Suing <freeda.suing@gmail.com>)
List pgsql-novice
On Sun, Aug 23, 2015 at 06:35:41PM +0800, Freeda Suing wrote:
> Hi,
>
> Is there a straightforward way to import data to a PSQL version 9.1 from an
> MS SQL database server?
>
> If not, can you suggest any strategies on how to do it?

pgloader. It's not without its issues but I've successfully tossed a mysql db
at pgsql with it and it claims mssql support.

http://pgloader.io/howto/pgloader.1.html

--
  "A search of his car uncovered pornography, a homemade sex aid, women's
  stockings and a Jack Russell terrier."
    - http://www.dailytelegraph.com.au/news/wacky/indeed/story-e6frev20-1111118083480


pgsql-novice by date:

Previous
From: Freeda Suing
Date:
Subject: Importing dump file from MS SQL to PSQL 9.3
Next
From: Freeda Suing
Date:
Subject: Truncating table in PSQL reclaims hard disk?