Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id CFFAF9FB2BE for ; Tue, 24 Oct 2006 17:48:28 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 47313-07 for ; Tue, 24 Oct 2006 17:48:22 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.237]) by postgresql.org (Postfix) with ESMTP id 864F29FB2BB for ; Tue, 24 Oct 2006 17:48:22 -0300 (ADT) Received: by wx-out-0506.google.com with SMTP id t13so2110448wxc for ; Tue, 24 Oct 2006 13:48:21 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=H76XUlJUNPAv4CCdUwpafGxrNfWwDsVRoLQKTilBZ6ExW+HRgYPXXbvlcpS0bM3lK1g0qwOydS6Xw10IkCR2lzF5MlyVcJPq9ZdemsfM1KHYW4seceHqq6c83uLZBQ32pQq2jZOUW4d21Ix4bii7rFXShA/yVBhQuwiMuuoJzNQ= Received: by 10.70.49.12 with SMTP id w12mr3695269wxw; Tue, 24 Oct 2006 13:48:21 -0700 (PDT) Received: by 10.70.73.6 with HTTP; Tue, 24 Oct 2006 13:48:21 -0700 (PDT) Message-ID: <1d219a6f0610241348o6ad7d685sca6c7b5244372db2@mail.gmail.com> Date: Tue, 24 Oct 2006 16:48:21 -0400 From: "Chris Hoover" To: "pgsql-admin@postgresql.org" Subject: Sql Anywhere to PostgreSQL? MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_16991_6868575.1161722901414" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.052 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, HTML_00_10, HTML_MESSAGE, SPF_PASS X-Spam-Level: * X-Archive-Number: 200610/155 X-Sequence-Number: 23458 ------=_Part_16991_6868575.1161722901414 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Has anyone ever done a conversion from Sql Anywhere to PostgreSQL? I have a task to investigate what this would take. Also, the Sql Anywhere database stores image files in the database as long binary types. What would be the best format to store these in PostgreSQL? Also, while all of my current PG clusters are on RH linux, if this project went forward, it would have to run on Windows 2k. Will the windows version of PG run on 2k, and are there any special caviates running on this platform? Thanks, Chris PG 8.1.3 RH 4.0 AS ------=_Part_16991_6868575.1161722901414 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Has anyone ever done a conversion from Sql Anywhere to PostgreSQL?  I have a task to investigate what this would take.

Also, the Sql Anywhere database stores image files in the database as long binary types.  What would be the best format to store these in PostgreSQL?

Also, while all of my current PG clusters are on RH linux, if this project went forward, it would have to run on Windows 2k.  Will the windows version of PG run on 2k, and are there any special caviates running on this platform?

Thanks,

Chris

PG 8.1.3
RH 4.0 AS
------=_Part_16991_6868575.1161722901414--