Re: [GENERAL] dump to pg - Mailing list pgsql-general

From David G. Johnston
Subject Re: [GENERAL] dump to pg
Date
Msg-id CAKFQuwYbudaVO1FprkpK8A0MvJ7=USsgY17a9tLvmOLVRbXk2g@mail.gmail.com
Whole thread Raw
In response to [GENERAL] dump to pg  (Nicolas Paris <niparisco@gmail.com>)
Responses Re: [GENERAL] dump to pg  (Rob Sargent <robjsargent@gmail.com>)
List pgsql-general
On Wed, May 31, 2017 at 7:43 AM, Nicolas Paris <niparisco@gmail.com> wrote:
Hi,

I have dumps from oracle and microsoft sql server (no more details). Is it possible to load them "directly" into postgres  (without oracle/mssql license)?
dump -> csv -> postgtres
or something ?


​Asking the public mailing lists for PostgreSQL for an opinion on the the legality of doing something like this is problematic​..

Technically it would depend a lot on exactly what you are trying to load.  If you can go through CSV to do it then its probably just raw insert data and has a decent chance of working as long as the schema is PostgreSQL has been created to accept the incoming data.

David J.

pgsql-general by date:

Previous
From: Nicolas Paris
Date:
Subject: [GENERAL] dump to pg
Next
From: Rob Sargent
Date:
Subject: Re: [GENERAL] dump to pg