RE: migration from Sybase to Postgres

Поиск
Список
Период
Сортировка
От lanczos@t-zones.sk
Тема RE: migration from Sybase to Postgres
Дата
Msg-id 20060708190204.32446.qmail@ewm.e-zones.sk
обсуждение исходный текст
Список pgsql-general
 > [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
>

В списке pgsql-general по дате отправления:

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: VACUUM FULL versus CLUSTER ON
Следующее
От: rstp
Дата:
Сообщение: Version Discrepancy