On Fri, Jul 06, 2007 at 10:48:48AM -0700, Mary Anderson 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?
As a pull option, it's also possible to use MS SQL's DTS tasks. You can define complex import tasks and (I believe) run the task regularly using the windows scheduler.
Massaging can be done by custom conversion scripts, in perl or vb, within the task definition.
My 2 cents. Regards, Ben K. Developer http://benix.tamu.edu
