Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 394369FB9B6 for ; Fri, 6 Jul 2007 15:16:07 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 14394-07 for ; Fri, 6 Jul 2007 15:15:56 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from gwmta.wicourts.gov (gwmta.wicourts.gov [165.219.244.99]) by postgresql.org (Postfix) with ESMTP id A09039FB4E1 for ; Fri, 6 Jul 2007 15:16:03 -0300 (ADT) Received: from Courts-MTA by gwmta.wicourts.gov with Novell_GroupWise; Fri, 06 Jul 2007 13:16:02 -0500 Message-Id: <468E407C.EE98.0025.0@wicourts.gov> X-Mailer: Novell GroupWise Internet Agent 7.0.2 Date: Fri, 06 Jul 2007 13:15:40 -0500 From: "Kevin Grittner" To: "Mary Anderson" , Subject: Re: replicating postgresql database to ms-sql database References: <468E8080.4030901@demog.berkeley.edu> In-Reply-To: <468E8080.4030901@demog.berkeley.edu> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/65 X-Sequence-Number: 26046 >>> On Fri, Jul 6, 2007 at 12:48 PM, in message <468E8080.4030901@demog.berkeley.edu>, Mary Anderson wrote:=20 >=20 > I have been asked if it is possible to asynchronously replicate a=20 > postgresql database to ms-sql. My answer is yes, provided postgresql=20 > ORM features aren't used in the design of the database. One does an=20 > ascii dump of the tables and then bulk loads them into MSSQL. The=20 > database in question will be about 10G. Is there a sane way to do this? =20 Look at pg_dump and the switches to cause it to generate INSERT statements instead of COPY statements. That has worked for me. =20 -Kevin =20