pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
converting from Sybase to Postgres 2+ messages / 2 participants [nested] [flat]
* converting from Sybase to Postgres @ 2007-03-20 00:03 Peter Koczan <pjkoczan@gmail.com> 0 siblings, 1 reply; 2+ messages in thread From: Peter Koczan @ 2007-03-20 00:03 UTC (permalink / raw) To: 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: converting from Sybase to Postgres @ 2007-03-20 03:39 Cesar Alvarez <c.alvarezx66@gmail.com> parent: Peter Koczan <pjkoczan@gmail.com> 0 siblings, 0 replies; 2+ messages in thread From: Cesar Alvarez @ 2007-03-20 03:39 UTC (permalink / raw) To: Peter Koczan <pjkoczan@gmail.com>; +Cc: pgsql-admin have you try a Sybase manneger ? http://www.sqlmanager.net/ they use to have a lite version maybe can help.. Peter Koczan wrote: > 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 Attachments:^ permalink raw reply [nested|flat] 2+ messages in threadc.alvarezx66.vcf (text/x-vcard, 118B) download
begin:vcard fn:Cesar Alvarez n:;Cesar Alvarez title:Web Development Asesor and Software Enginner version:2.1 end:vcard
end of thread, other threads:[~2007-03-20 03:39 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2007-03-20 00:03 converting from Sybase to Postgres Peter Koczan <pjkoczan@gmail.com> 2007-03-20 03:39 ` Cesar Alvarez <c.alvarezx66@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox