From: Cesar Alvarez <c.alvarezx66@gmail.com>
To: Peter Koczan <pjkoczan@gmail.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: converting from Sybase to Postgres
Date: Mon, 19 Mar 2007 21:39:17 -0600
Message-ID: <45FF5765.9070003@gmail.com> (raw)
In-Reply-To: <4544e0330703191703v374bfa72ma75e146096e68c4f@mail.gmail.com>
References: <4544e0330703191703v374bfa72ma75e146096e68c4f@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: c.alvarezx66@gmail.com, pjkoczan@gmail.com
Subject: Re: converting from Sybase to Postgres
In-Reply-To: <45FF5765.9070003@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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