Re: dump to pg

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: Nicolas Paris <niparisco(at)gmail(dot)com>, Forums postgresql <pgsql-general(at)postgresql(dot)org>
Subject: Re: dump to pg
Date: 2017-05-31 15:33:10
Message-ID: 387A30EC-D456-4D92-8966-D3615F17148F@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On May 31, 2017, at 9:27 AM, David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
>
> On Wed, May 31, 2017 at 7:43 AM, Nicolas Paris <niparisco(at)gmail(dot)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.
>
If the dumps are not ascii the ‘to csv’ step gets problematic if not impossible legally.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2017-05-31 15:49:15 Re: Build PostgreSQL With XML Support on Linux
Previous Message David G. Johnston 2017-05-31 15:27:28 Re: dump to pg