Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id C7A629FB2C0 for ; Tue, 20 Mar 2007 00:39:41 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 00823-01 for ; Tue, 20 Mar 2007 00:39:36 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.251]) by postgresql.org (Postfix) with ESMTP id E4FAA9FB2A6 for ; Tue, 20 Mar 2007 00:39:36 -0300 (ADT) Received: by an-out-0708.google.com with SMTP id c24so1421780ana for ; Mon, 19 Mar 2007 20:39:35 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type; b=Ld/g4w55kl1Vve3cg+jAvXVVWHCj5BloE8a6BYzdlzS8M4JF6cgOONTyItKfyRO12P87VN+jIAARqOclUNr4cbjKSd0mGznGHOZ8MTXQDSD89lVpnRVHDIHKHpbt/6ciReKkN9OL2v14h362wntpAsejW+YJ/9S4BXqAoVpsWyI= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type; b=sf2D6Hqn2BzUxqy6cXxxQ2ijnM3XX9QG+Ks8CwyjxKkoaDAls4BJdqFJz8rgxbo9EAqqkOoG1WxgbrSuYuxEDotVIEUXZ+km9nG7WhmYWM7luEP2y5dq9weE4Td6nSf5h6shpfO9BC4ZM9ie+kz0Pw5whTTH9UEdz/ympxA+3kA= Received: by 10.100.138.2 with SMTP id l2mr4428704and.1174361975795; Mon, 19 Mar 2007 20:39:35 -0700 (PDT) Received: from ?192.168.0.95? ( [216.72.195.87]) by mx.google.com with ESMTP id c28sm341730anc.2007.03.19.20.39.33; Mon, 19 Mar 2007 20:39:35 -0700 (PDT) Message-ID: <45FF5765.9070003@gmail.com> Date: Mon, 19 Mar 2007 21:39:17 -0600 From: Cesar Alvarez User-Agent: Thunderbird 1.5.0.10 (Windows/20070221) MIME-Version: 1.0 To: Peter Koczan CC: pgsql-admin Subject: Re: converting from Sybase to Postgres References: <4544e0330703191703v374bfa72ma75e146096e68c4f@mail.gmail.com> In-Reply-To: <4544e0330703191703v374bfa72ma75e146096e68c4f@mail.gmail.com> Content-Type: multipart/mixed; boundary="------------000100050001060701010400" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/129 X-Sequence-Number: 24953 This is a multi-part message in MIME format. --------------000100050001060701010400 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit 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 --------------000100050001060701010400 Content-Type: text/x-vcard; charset=utf-8; name="c.alvarezx66.vcf" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="c.alvarezx66.vcf" begin:vcard fn:Cesar Alvarez n:;Cesar Alvarez title:Web Development Asesor and Software Enginner version:2.1 end:vcard --------------000100050001060701010400--