RE: migration from Sybase to Postgres

> [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of
>
> On 7 Jul 2006 12:50:22 -0000, lanczos(at)t-zones(dot)sk
> <lanczos(at)t-zones(dot)sk> wrote:
> > What is the most appropriate way to migrate a database form
> Sybase (SQL Anywhere 5.504) to Postgres? I found some
> shareware of freeware migration tools on the net, which are
> the best? Is it faster to use any of them them or just simply
> do 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.

Do You mean the SQL Server Express for free?

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

Following my quick look into it does not support it.

Tomas

> merlin
>