Data Migration from Sybase to Postgres

Classic Servoy
1

Hi,

Please post, if anyone aware of a open source data migration tool to migrate Sybase to Postgrs DB.

Br,Darshana

2

not opensource, but we have good results, with EMS SQL DATA Pump. http://www.sqlmanager.net/en/products/p … l/datapump
(cost about $95,- which is not much, IMHO)

3

For what its worth I just did a recent migration from Sybase to Postgres 9.0 for x64.
I just used some simple tools:

  1. Used the Sybase Central dbunload tool to dump the entire database (mind you this is a really simple db not fancy stuff like triggers etc and no indices - had to add that after manually.)
  2. Edited the “reload.sql” that the dbunload produces to conform to the Postgres dialect for the “COPY FROM…” syntax
  3. The dbunload produces an “\unload” folder containing all the tables in xxx.dat format (the xxx is a number). However I had to edit each table to remove the first three characters/bytes because they screw up the PK ID for some reason. (Most editors will hide these 3 bytes it seems so look for one that can display it - I used the editor that comes with MyEclipse but there should be others that can show hex bytes)
  4. run the modified reload.sql via the Postgres Psql (or like me create a batch file/script to do all the command line stuff finally invoking the reload.sql and capturing the output into a text file for later analysis.)

Please add more helpful hints since this might be an interesting tips topic.

4

Hi,

I’m using sybase ASA DB, there are some Views/Procedures/triggers to be converted. Will this support for that.

Br, Darshana

5

Hi,

I doubt it will automatically convert any procedures. I believe ASA uses Transact-SQL as a language which is not supported in PostgreSQL.
For this you need to do a manual conversion like offered by PgExperts.

Hope this helps.

6

Hi,

If anyone used a commercial migration tool other than EMS Sql Pump to migrate from Sybase ASA to Postgres DB, please mention.

Br, Darshana

7

Hi,

Perhaps you should take a look at this service from PgExperts:
http://www.pgexperts.com/servoyconversion.html

Hope this helps.

8

Hi,
You could try demo version of console application DirectExportSybase:
http://bluetelum.com/download
All you need is native Sybase ODBC driver to be installed.

9

I question it will consequently change over any strategies or stable.