Re: dump to pg

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: dump to pg
Date: 2017-06-01 21:33:11
Message-ID: ogq16f$4e2$1@blaine.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Nicolas Paris schrieb am 31.05.2017 um 16:43:
> 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 ?

If those are binary dumps (e.g. a DataPump dump in Oracle or a "backup" in SQL Server), then the answer is no.
Only Oracle or SQL Server can read those files.

If they aren't too big, you might get away by installing the express edition of the respective DBMS, then import them using the native tools, then export the data as CSV files.

Thomas

In response to

  • dump to pg at 2017-05-31 14:43:54 from Nicolas Paris

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Nicolas Paris 2017-06-01 21:37:13 Re: dump to pg
Previous Message Nicolas Paris 2017-06-01 21:21:01 Re: dump to pg