Обсуждение: migration from Sybase to Postgres

Поиск
Список
Период
Сортировка

migration from Sybase to Postgres

От
lanczos@t-zones.sk
Дата:
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? 

Thanks

Tomas

Re: migration from Sybase to Postgres

От
"Merlin Moncure"
Дата:
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