Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 4BEA69FB2C4 for ; Wed, 25 Oct 2006 05:45:21 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 06840-10 for ; Wed, 25 Oct 2006 08:45:03 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from ash25e.internode.on.net (ash25e.internode.on.net [203.16.214.182]) by postgresql.org (Postfix) with ESMTP id 4AD509FB28B for ; Wed, 25 Oct 2006 05:45:02 -0300 (ADT) Received: from [192.168.8.200] (ppp247-71.static.internode.on.net [203.122.247.71]) by ash25e.internode.on.net (8.13.6/8.13.5) with ESMTP id k9P8itDQ061658; Wed, 25 Oct 2006 18:14:56 +0930 (CST) (envelope-from pgsql@007Marketing.com) Message-ID: <453F2407.3070608@007Marketing.com> Date: Wed, 25 Oct 2006 18:14:55 +0930 From: Shane Ambler User-Agent: Thunderbird 1.5.0.7 (Macintosh/20060909) MIME-Version: 1.0 To: Chris Hoover CC: "pgsql-admin@postgresql.org" Subject: Re: Sql Anywhere to PostgreSQL? References: <1d219a6f0610241348o6ad7d685sca6c7b5244372db2@mail.gmail.com> In-Reply-To: <1d219a6f0610241348o6ad7d685sca6c7b5244372db2@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.012 tagged_above=0 required=5 tests=BIZ_TLD, SPF_HELO_PASS X-Spam-Level: ** X-Archive-Number: 200610/159 X-Sequence-Number: 23462 Chris Hoover wrote: > 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? That would be bytea or blob depending on your exact needs. > 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? PostgreSQL 8.0 and above runs on windows and is available in a pre-configured windows installer package to install like other software. The main catch is the windows version is somewhat newer and less tested than the *nix versions. (previous versions on windows where the *nix source built on top of cygwin) -- Shane Ambler pgSQL@007Marketing.com Get Sheeky @ http://Sheeky.Biz