Skip site navigation (1) Skip section navigation (2)

Re: converting from Sybase to Postgres

From: Cesar Alvarez <c(dot)alvarezx66(at)gmail(dot)com>
To: Peter Koczan <pjkoczan(at)gmail(dot)com>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: converting from Sybase to Postgres
Date: 2007-03-20 03:39:17
Message-ID: 45FF5765.9070003@gmail.com (view raw or flat)
Thread:
Lists: 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


Attachment: c.alvarezx66.vcf
Description: text/x-vcard (120 bytes)

In response to

pgsql-admin by date

Next:From: Sabin CoandaDate: 2007-03-20 11:59:26
Subject: log localization
Previous:From: Christopher BrowneDate: 2007-03-20 03:32:38
Subject: Re: [Bulk] Re: Disconnecting non active (IDLE ) users

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group