Page 1 of 1

Data Migration from Sybase to Postgres

PostPosted: Thu Sep 30, 2010 9:18 am
by million.lk
Hi,

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

Br,Darshana

Re: Data Migration from Sybase to Postgres

PostPosted: Thu Sep 30, 2010 10:52 am
by Harjo
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)

Re: Data Migration from Sybase to Postgres

PostPosted: Thu Sep 30, 2010 8:35 pm
by Thomas Parry
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.

Re: Data Migration from Sybase to Postgres

PostPosted: Fri Oct 01, 2010 9:49 am
by million.lk
Hi,

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

Br, Darshana

Re: Data Migration from Sybase to Postgres

PostPosted: Fri Oct 01, 2010 10:45 am
by ROCLASI
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.

Re: Data Migration from Sybase to Postgres

PostPosted: Tue Oct 05, 2010 1:05 pm
by million.lk
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

Re: Data Migration from Sybase to Postgres

PostPosted: Tue Oct 05, 2010 1:30 pm
by ROCLASI
Hi,

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

Hope this helps.

Re: Data Migration from Sybase to Postgres

PostPosted: Tue Dec 02, 2014 10:04 am
by theparzival
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.