Data Migration from Sybase to Postgres

Home for older / inactive topics

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
ServoyCamp
Servoy Certified Developer
Servoy Valued Professional
SAN Developer
Harjo
 
Posts: 4321
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
SAN Developer / Servoy Valued Professional / Servoy Certified Developer

ROCLASI Software Solutions / JBS Group, Partner
Mastodon: @roclasi
--
ServoyForge - Building Open Source Software.
PostgreSQL - The world's most advanced open source database.
User avatar
ROCLASI
Servoy Expert
 
Posts: 5438
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
SAN Developer / Servoy Valued Professional / Servoy Certified Developer

ROCLASI Software Solutions / JBS Group, Partner
Mastodon: @roclasi
--
ServoyForge - Building Open Source Software.
PostgreSQL - The world's most advanced open source database.
User avatar
ROCLASI
Servoy Expert
 
Posts: 5438
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

Re: Data Migration from Sybase to Postgres

Postby mkimtani068 » Mon Mar 11, 2019 3:16 pm

I question it will consequently change over any strategies or stable.
mkimtani068
 
Posts: 2
Joined: Tue Mar 05, 2019 2:00 pm
Location: Indore


Return to Archive

Who is online

Users browsing this forum: No registered users and 0 guests

cron