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

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

RE: migration from Sybase to Postgres

От
lanczos@t-zones.sk
Дата:
 > [mailto:pgsql-general-owner@postgresql.org] On Behalf Of
>
> 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
> 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
>