Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 474BB9FB669 for ; Tue, 10 Jul 2007 01:45:54 -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 65785-08 for ; Tue, 10 Jul 2007 01:45:49 -0300 (ADT) X-Greylist: delayed 00:06:39.144672 by SQLgrey-1.7.5 Received: from outbound-mail-63.bluehost.com (outbound-mail-63.bluehost.com [69.89.21.23]) by postgresql.org (Postfix) with SMTP id E8C9C9FB670 for ; Tue, 10 Jul 2007 01:45:49 -0300 (ADT) Received: (qmail 11112 invoked by uid 0); 10 Jul 2007 04:39:09 -0000 Received: from unknown (HELO box54.bluehost.com) (69.89.20.54) by mailproxy4.bluehost.com with SMTP; 10 Jul 2007 04:39:09 -0000 Received: from vdsl-151-118-147-91.dnvr.qwest.net ([151.118.147.91] helo=new-host.home) by box54.bluehost.com with esmtps (TLSv1:AES256-SHA:256) (Exim 4.63) (envelope-from ) id 1I87VE-0001ki-D2 for pgsql-admin@postgresql.org; Mon, 09 Jul 2007 22:39:08 -0600 From: Kevin Kempter To: pgsql-admin@postgresql.org Subject: Re: replicating postgresql database to ms-sql database Date: Mon, 9 Jul 2007 22:36:26 -0600 User-Agent: KMail/1.9.7 References: <468E8080.4030901@demog.berkeley.edu> <20070706191122.GI27590@it.is.rice.edu> In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200707092236.26329.kevin@kevinkempterllc.com> X-Identified-User: {840:box54.bluehost.com:kevinkem:kevinkempterllc.com} {sentby:bopbeforesmtp 151.118.147.91 authed with ossfusion.com} X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/78 X-Sequence-Number: 26059 On Sunday 08 July 2007 16:21:42 Ben Kim wrote: > 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 > > ---------------------------(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 Have a look at dbi-link on the pg foundry