Data Migration from Sybase to Postgres

Discuss everything related to development on the open source projects that relate to Servoy Developer.

Data Migration from Sybase to Postgres

Postby million.lk » Thu Sep 30, 2010 9:18 am

Hi,

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

Br,Darshana
million.lk
 
Posts: 10
Joined: Wed Nov 25, 2009 3:21 pm

Re: Data Migration from Sybase to Postgres

Postby Harjo » Thu Sep 30, 2010 10:52 am

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)
Harjo Kompagnie
Direct ICT / Servoy Hosting / ServoyCamp
Servoy Certified Developer
Servoy Valued Professional
SAN Developer
User avatar
Harjo
 
Posts: 4268
Joined: Fri Apr 25, 2003 11:42 pm
Location: DEN HAM OV, The Netherlands

Re: Data Migration from Sybase to Postgres

Postby Thomas Parry » Thu Sep 30, 2010 8:35 pm

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.
Tom Parry
Prospect IT
Java/C++/Servoy/Jasper Reports/Simulation/Service Applications
http://www.prospect-saas.biz
Thomas Parry
 
Posts: 498
Joined: Thu Jan 10, 2008 8:48 pm
Location: Ottawa, Canada

Re: Data Migration from Sybase to Postgres

Postby million.lk » Fri Oct 01, 2010 9:49 am

Hi,

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

Br, Darshana
million.lk
 
Posts: 10
Joined: Wed Nov 25, 2009 3:21 pm

Re: Data Migration from Sybase to Postgres

Postby ROCLASI » Fri Oct 01, 2010 10:45 am

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.
Robert Ivens
ROCLASI Software Solutions / JBS Group, Partner
SAN Developer / Servoy Valued Professional / Servoy Certified Developer
Twitter: @roclasi / @servoyforge
--
ServoyForge - Building Open Source Software.
PostgreSQL - The world's most advanced open source database.
User avatar
ROCLASI
Servoy Expert
 
Posts: 5204
Joined: Thu Oct 02, 2003 9:49 am
Location: Netherlands/Belgium

Re: Data Migration from Sybase to Postgres

Postby million.lk » Tue Oct 05, 2010 1:05 pm

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
million.lk
 
Posts: 10
Joined: Wed Nov 25, 2009 3:21 pm

Re: Data Migration from Sybase to Postgres

Postby ROCLASI » Tue Oct 05, 2010 1:30 pm

Hi,

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

Hope this helps.
Robert Ivens
ROCLASI Software Solutions / JBS Group, Partner
SAN Developer / Servoy Valued Professional / Servoy Certified Developer
Twitter: @roclasi / @servoyforge
--
ServoyForge - Building Open Source Software.
PostgreSQL - The world's most advanced open source database.
User avatar
ROCLASI
Servoy Expert
 
Posts: 5204
Joined: Thu Oct 02, 2003 9:49 am
Location: Netherlands/Belgium

Re: Data Migration from Sybase to Postgres

Postby theparzival » Tue Dec 02, 2014 10:04 am

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.
theparzival
 
Posts: 1
Joined: Tue Dec 02, 2014 10:01 am


Return to Servoy Developer related projects

Who is online

Users browsing this forum: No registered users and 1 guest