Data Migration from Sybase to PostgreSQL?

Posted by Cliff on Friday November 30, 2001 @10:45PM from the tools-for-the-trade dept.

hp9000 asks: "I've been asked to work on a project that will involve data migration from Sybase to PostgreSQL. I'd like to know if there's any tool, similar to Oracle's Migration Workbench, or even a shell script, to move all data from Sybase tables to PostgreSQL tables, creating the tables/tablespaces/etc in the process or at least generating a script to do so. Any kind of tool, so to speak, that would allow me to perform the migration will be great. I'm not interested in the sql code migration (that will come later if necessary), only tables, indexes, etc. at this point."

1 of 15 comments (clear)

Min score:

Reason:

Sort:

Should be relatively easy by imrdkl · 2001-12-01 00:12 · Score: 2, Interesting

With Perl. Try asking on Perlmonks. Perl has modules for both database types, and handles to both databases can be opened simultaneously in a single script, reducing the need for intermediete format conversion. If there is a mapping of all datatypes, I have not worked with Postgres, then it should be doable.