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




---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings