>>> On Fri, Jul 6, 2007 at 12:48 PM, in message <[EMAIL PROTECTED]>, Mary Anderson <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings