Re: Postgres and Sybase - Mailing list pgsql-novice

From Josh Berkus
Subject Re: Postgres and Sybase
Date
Msg-id web-1798066@davinci.ethosmedia.com
Whole thread Raw
In response to Postgres and Sybase  ("Rob" <rob@jamwarehouse.com>)
List pgsql-novice
Rob,

> Sorry guys, I realise that this is probably a stupid question to be
> asking,
> but I'm fast running out of options.
>
> I've got a  Sybase dump file and I was wondering if there is any way
> to read
> this into postgres?

What's a SyBase dump file look like?   It's been 5 years, I can't
really remember.

If it's text, we can probably bend COPY around to loading it.

It it's binary, you may be S.O.L.   TechDocs is down right now, but
look later at techdocs.postgresql.org to see if anyone has written a
Sybase-to-PostgreSQL converter.

Also, if you have a *running* Sybase database, conversion is a lot
easier ... you can use Perl::DBI to read directly from sybase to a COPY
file, and then load the COPY file into Postgres.

-Josh Berkus


pgsql-novice by date:

Previous
From: "Josh Berkus"
Date:
Subject: Re: how to create secondary key!!
Next
From: "Devinder K Rajput"
Date:
Subject: pg or DBI