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@xxxxxxxxxxxxxx so that your > message can get through to the mailing list cleanly Have a look at dbi-link on the pg foundry
