Re: Importing dump file from MS SQL to PSQL 9.3

From: CaT <cat(at)zip(dot)com(dot)au>
To: Freeda Suing <freeda(dot)suing(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Importing dump file from MS SQL to PSQL 9.3
Date: 2015-08-23 11:50:14
Message-ID: 20150823115014.GG5128@zip.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Freeda Suing 2015-08-24 11:07:27 Truncating table in PSQL reclaims hard disk?
Previous Message Freeda Suing 2015-08-23 10:35:41 Importing dump file from MS SQL to PSQL 9.3