Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 623019FB278 for ; Wed, 25 Oct 2006 22:38:49 -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 48683-02 for ; Thu, 26 Oct 2006 01:38:41 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from news.hub.org (news.hub.org [200.46.204.72]) by postgresql.org (Postfix) with ESMTP id A57CF9FB265 for ; Wed, 25 Oct 2006 22:38:41 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id k9Q1cW3Z077930 for ; Wed, 25 Oct 2006 22:38:32 -0300 (ADT) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id k9Q1Hc8N073022 for pgsql-admin@postgresql.org; Wed, 25 Oct 2006 22:17:38 -0300 (ADT) (envelope-from news) From: ljb X-Newsgroups: pgsql.admin Subject: Re: Sql Anywhere to PostgreSQL? Date: Thu, 26 Oct 2006 01:17:38 +0000 (UTC) Organization: Hub.Org Networking Services Lines: 11 Message-ID: References: <1d219a6f0610241348o6ad7d685sca6c7b5244372db2@mail.gmail.com> X-Complaints-To: usenet@news.hub.org X-No-Archive: yes User-Agent: slrn/0.9.8.1 (Linux) To: pgsql-admin@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=UNPARSEABLE_RELAY X-Spam-Level: X-Archive-Number: 200610/170 X-Sequence-Number: 23473 > Has anyone ever done a conversion from Sql Anywhere to PostgreSQL? I have a > task to investigate what this would take. Biggest problem areas I see would be stored procedures and the many SQL differences. If you use stored procedures, they will need to be completely rewritten. The SQL differences will get you too; someone who knows both SQLA and PostgreSQL will have to review line-by-line. Stuff like SQLA's "current timestamp" vs PostgreSQL "current_timestamp". Or, limiting returned rows (SQLA: SELECT TOP 10 * FROM ... vs PostgreSQL: SELECT * FROM ... LIMIT 10). Just two examples. Where standards exist, PostgreSQL is much more standard than Sybase.