Re: sybase->postgresql

Ashish,

> postgresql you said (I saw this on a list):
> > 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.
>
> I am brand new to postgres and do have a running sybase which I wish to
> convert. I have used perl's DBlib. However, I am not sure how to get the
> output to copy. I will also be sending the question to postgres lists, but
> thought I would send it to you too in case you are able to suggest
> something.

Easiest way?   Use perl to pull from Sybase and build a COPY-formatted file.
Then have perl log into postgres and load the file.   Seems awkward, but it's
actually *much* faster than other methods.   We do this for a 1GB Sybase
database for one client on a nightly basis; takes about 40 minutes.

--
Josh Berkus
Aglio Database Solutions
San Francisco