Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id D26F89F9FAF for ; Fri, 6 Jul 2007 14:48:18 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 77647-01 for ; Fri, 6 Jul 2007 14:48:15 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from transition.DEMOG.Berkeley.EDU (DEMOG.Berkeley.EDU [128.32.93.50]) by postgresql.org (Postfix) with ESMTP id 677049FB418 for ; Fri, 6 Jul 2007 14:48:15 -0300 (ADT) Received: from transition.DEMOG.Berkeley.EDU (localhost.localdomain [127.0.0.1]) by transition.DEMOG.Berkeley.EDU (Postfix) with ESMTP id 8B3BE1394C for ; Fri, 6 Jul 2007 10:48:13 -0700 (PDT) Received: from [192.168.1.202] (unknown [192.168.1.202]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by transition.DEMOG.Berkeley.EDU (Postfix) with ESMTP id 50C6113944 for ; Fri, 6 Jul 2007 10:48:13 -0700 (PDT) Message-ID: <468E8080.4030901@demog.berkeley.edu> Date: Fri, 06 Jul 2007 10:48:48 -0700 From: Mary Anderson User-Agent: Thunderbird 2.0.0.4 (Windows/20070604) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: replicating postgresql database to ms-sql database Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: ClamAV using ClamSMTP X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/63 X-Sequence-Number: 26044 Hi list, I have been asked if it is possible to asynchronously replicate a postgresql database to ms-sql. My answer is yes, provided postgresql ORM features aren't used in the design of the database. One does an ascii dump of the tables and then bulk loads them into MSSQL. The database in question will be about 10G. Is there a sane way to do this? I am hoping the slony can be instructed to produce an ascii transaction log which can then be massaged and applied to the MS-SQL database. (This is a database of population statistics which is relatively static. It will be read only on the ms-sql node) I think it is much better to have both databases running postgres, by the way. mary anderson