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 [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly > ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
