pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / 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>
  2007-03-20 03:39 ` Re: converting from Sybase to Postgres Cesar Alvarez <c.alvarezx66@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 00:03 converting from Sybase to Postgres Peter Koczan <pjkoczan@gmail.com>
@ 2007-03-20 03:39 ` Cesar Alvarez <c.alvarezx66@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:

c.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
^ permalink raw reply [nested|flat] 2+ messages in thread


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