Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 6D0EF9FB36C for ; Sun, 8 Jul 2007 19:23:09 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 89415-07 for ; Sun, 8 Jul 2007 19:23:01 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from coe.tamu.edu (edsun.coe.tamu.edu [165.91.232.6]) by postgresql.org (Postfix) with ESMTP id 6EE0B9FB4B6 for ; Sun, 8 Jul 2007 19:23:05 -0300 (ADT) Received: (from root@localhost) by coe.tamu.edu (8.11.7p3+Sun/8.12.11) id l68MMsN24735 for pgsql-admin@postgresql.org; Sun, 8 Jul 2007 17:22:54 -0500 (CDT) Received: from coe.tamu.edu (coe.tamu.edu [165.91.232.6]) by coe.tamu.edu (8.11.7p3+Sun/8.12.11) with ESMTP id l68MLgt24700; Sun, 8 Jul 2007 17:21:42 -0500 (CDT) Date: Sun, 8 Jul 2007 17:21:42 -0500 (CDT) From: Ben Kim To: pgsql-admin@postgresql.org cc: Mary Anderson Subject: Re: replicating postgresql database to ms-sql database In-Reply-To: <20070706191122.GI27590@it.is.rice.edu> Message-ID: References: <468E8080.4030901@demog.berkeley.edu> <20070706191122.GI27590@it.is.rice.edu> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: by AMaViS 0.3.12 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.259 tagged_above=0 required=5 tests=AWL=0.649, BAYES_05=-1.11, SARE_SPEC_REPLICA=0.72 X-Spam-Level: X-Archive-Number: 200707/69 X-Sequence-Number: 26050 On Fri, Jul 06, 2007 at 10:48:48AM -0700, Mary Anderson wrote: > 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? As a pull option, it's also possible to use MS SQL's DTS tasks. You can define complex import tasks and (I believe) run the task regularly using the windows scheduler. Massaging can be done by custom conversion scripts, in perl or vb, within the task definition. My 2 cents. Regards, Ben K. Developer http://benix.tamu.edu