From: | "Peter Koczan" <pjkoczan(at)gmail(dot)com> |
---|---|
To: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | converting from Sybase to Postgres |
Date: | 2007-03-20 00:03:33 |
Message-ID: | 4544e0330703191703v374bfa72ma75e146096e68c4f@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi everyone,
I'm looking to convert a lot of data from Sybase to Postgres. As this will
be a painful process, I was wondering if there are any utilities and
programs to ease the conversion process. Specifically, I'm looking for help
in 3 areas.
1. Recreation of the schema, especially converting triggers, data types, and
functions.
2. Converting SQL scripts and cron jobs where there are incompatibilities (
e.g. sybase : isnull(...) :: postgres : coalesce(...) ).
3. There is an ancient GUI that we use to interface to sybase (it's based on
APT, I believe). The nice thing is it can run external commands, and
interfaces somewhat nicely with Kerberos. Is there any piece of middleware
(preferably GUI-based, though web-based may do) for postgres that can do
this?
Of course I can spend hours tracking down cron jobs, apps, and scripts,
painstakingly recreating triggers and functions, and write my own GTK-based
GUI, but if there's anything that can help me, please let me know.
Peter
From | Date | Subject | |
---|---|---|---|
Next Message | Phillip Smith | 2007-03-20 02:19:51 | Re: how to create field auto increas value |
Previous Message | August Zajonc | 2007-03-19 21:45:20 | Re: [Bulk] Re: Disconnecting non active (IDLE ) users |