Re: migration from Sybase to Postgres - Mailing list pgsql-general

From Merlin Moncure
Subject Re: migration from Sybase to Postgres
Date
Msg-id b42b73150607070626r33553586r804a176beb5534e@mail.gmail.com
Whole thread Raw
In response to migration from Sybase to Postgres  (lanczos@t-zones.sk)
List pgsql-general
On 7 Jul 2006 12:50:22 -0000, lanczos@t-zones.sk <lanczos@t-zones.sk> wrote:
> What is the most appropriate way to migrate a database form Sybase (SQL Anywhere 5.504) to Postgres? I found some
sharewareof freeware migration tools on the net, which are the best? Is it faster to use any of them them or just
simplydo it manually? 

An excellent conversion tool is actually microsoft sql server.  It can
convert via dts transformation to any odbc source to any other odbc
source if you have a windows machine to do the conversion and a copy
of the database.

barring that, I would just dump sybase into sql statements (does it
support that?) and massage the text and pipe into psql.

merlin

pgsql-general by date:

Previous
From: lanczos@t-zones.sk
Date:
Subject: migration from Sybase to Postgres
Next
From: Marc Haber
Date:
Subject: Need help with quote escaping in exim for postgresql