>>> On Fri, Jul 6, 2007 at 12:48 PM, in message
<468E8080(dot)4030901(at)demog(dot)berkeley(dot)edu>, Mary Anderson
<maryfran(at)demog(dot)berkeley(dot)edu> 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