migration from Sybase to Postgres

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?

Thanks

Tomas

From pgsql-general-owner@postgresql.org Fri Jul 7 10:26:50 2006

X-Original-To: pgsql-general-postgresql.org@postgresql.org
Received: from localhost (mx1.hub.org [200.46.208.251])
by postgresql.org (Postfix) with ESMTP id EB1279FB222
for <pgsql-general-postgresql.org@postgresql.org>; Fri, 7 Jul 2006 10:26:49 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024)
with ESMTP id 05465-07 for <pgsql-general-postgresql.org@postgresql.org>;
Fri, 7 Jul 2006 10:26:39 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-
Received: from nz-out-0102.google.com (nz-out-0102.google.com [64.233.162.204])
by postgresql.org (Postfix) with ESMTP id 4C0239FAC76
for <pgsql-general@postgresql.org>; Fri, 7 Jul 2006 10:26:38 -0300 (ADT)
Received: by nz-out-0102.google.com with SMTP id 8so1479494nzo
for <pgsql-general@postgresql.org>; Fri, 07 Jul 2006 06:26:37 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
s=beta; d=gmail.com;
h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
b=hR4YlCW27Hu16vnuu11hEdVun1y3Pqo9CjEbRKucXsByO93iiqNWDK7pPf1IRatx+rGS9o9ZkxjugcZRsUoH5Sqhd7DsHajR7dJuXHHN0rjwZd5+TmmdlKzZ9pUGEsu1cCCs1aLPFApRe1D5ozGFtBa0OGVgmrZDn5CePU6NReI=
Received: by 10.65.152.15 with SMTP id e15mr2021278qbo;
Fri, 07 Jul 2006 06:26:36 -0700 (PDT)
Received: by 10.65.139.14 with HTTP; Fri, 7 Jul 2006 06:26:36 -0700 (PDT)
Message-ID: <b42b73150607070626r33553586r804a176beb5534e@mail.gmail.com>
Date: Fri, 7 Jul 2006 09:26:36 -0400
From: "Merlin Moncure" <mmoncure@gmail.com>
To: "lanczos@t-zones.sk" <lanczos@t-zones.sk>
Subject: Re: migration from Sybase to Postgres
Cc: pgsql-general@postgresql.org
In-Reply-To: <20060707125022.3619.qmail@ewm.e-zones.sk>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <20060707125022.3619.qmail@ewm.e-zones.sk>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200607/234
X-Sequence-Number: 97858

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.

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

merlin