>>> On Fri, Jul 6, 2007 at 12:48 PM, in message <468E8080.4030901@xxxxxxxxxxxxxxxxxx>, Mary Anderson <maryfran@xxxxxxxxxxxxxxxxxx> 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? Look at pg_dump and the switches to cause it to generate INSERT statements instead of COPY statements. That has worked for me. -Kevin
