Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id D1EFC9FB465 for ; Fri, 6 Jul 2007 16:11:30 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 42348-03 for ; Fri, 6 Jul 2007 16:11:21 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from is.rice.edu (is.rice.edu [128.42.42.24]) by postgresql.org (Postfix) with ESMTP id 4C83A9FB2A7 for ; Fri, 6 Jul 2007 16:11:24 -0300 (ADT) Received: from scan2.mail.rice.edu (scan2.mail.rice.edu [128.42.59.161]) by is.rice.edu (Postfix) with ESMTP id 485D841877; Fri, 6 Jul 2007 14:11:23 -0500 (CDT) Received: from is.rice.edu ([128.42.42.24]) by scan2.mail.rice.edu (scan2.mail.rice.edu [128.42.59.161]) (amavisd-new, port 10024) with ESMTP id 18567-07; Fri, 6 Jul 2007 14:11:22 -0500 (CDT) Received: by is.rice.edu (Postfix, from userid 18612) id 8BEA641876; Fri, 6 Jul 2007 14:11:22 -0500 (CDT) Date: Fri, 6 Jul 2007 14:11:22 -0500 From: Kenneth Marshall To: Mary Anderson Cc: pgsql-admin@postgresql.org Subject: Re: replicating postgresql database to ms-sql database Message-ID: <20070706191122.GI27590@it.is.rice.edu> References: <468E8080.4030901@demog.berkeley.edu> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <468E8080.4030901@demog.berkeley.edu> User-Agent: Mutt/1.4.2i X-Virus-Scanned: by amavis-2.2.1 at scan2.mail.rice.edu X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/66 X-Sequence-Number: 26047 Mary, I believe that you can use FreeTDS with dblink to set up your on replication process. I agree with you that having both databases be PostgreSQL would be preferrable. Ken On Fri, Jul 06, 2007 at 10:48:48AM -0700, Mary Anderson wrote: > 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly >