On 7 Jul 2006 12:50:22 -0000, lanczos@xxxxxxxxxx <lanczos@xxxxxxxxxx> 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