hello,
not possible in your case.
To my understading, no tool can directly transform binary dump(Oralce &
MSSQL) to csv file format.
Steven
2017-06-02 5:37 GMT+08:00 Nicolas Paris :
> > If they aren't too big, you might get away by installing the express
> edition of the respective DBMS
>
> Thanks for the suggestion. Problem is the data is highly sensible and
> cannot go on the cloud or non trusted place
Sounds like the real question now is not how to import the data, but
how to convert the backups you have to CSV or similar?
Another idea for SQL Server is to use the bcp utility.
> Or spin up an AWS SQL Server instance:
>
> https://aws.amazon.com/windows/resources/amis/
>
Thanks for the suggestion. Problem is the data is highly sensible and
cannot go on the cloud or non trusted place
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
On 06/02/2017 09:31 AM, Neil Anderson wrote:
On 1 June 2017 at 17:37, Nicolas Paris wrote:
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.
Good idea. I think SQL
On 1 June 2017 at 17:37, Nicolas Paris wrote:
>> 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.
Good idea. I think SQL Server Express is limited to 10GB on the
> 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.
Thanks Thomas. Both are binaries. The oracle's one is a 30TB database...
--
Sent via pgsql-general mailing lis
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
Thanks all,
The point is I only have access to dump files, no ora/mssql server instance
access. I have noticed the warning around legality on that question. The
best solution for me is to ask to each. Once get answer, I will come back
here to provide the answer.
2017-06-01 4:14 GMT-04:00 vinny :
On 2017-05-31 16:43, Nicolas Paris 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 ?
Thanks a lot
A very, *very* short trip to google s
> On May 31, 2017, at 9:27 AM, David G. Johnston
> wrote:
>
> On Wed, May 31, 2017 at 7:43 AM, Nicolas Paris 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
On Wed, May 31, 2017 at 7:43 AM, Nicolas Paris 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
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 ?
Thanks a lot
12 matches
Mail list logo
