Mangus Hagander has a detailed how to for replicating from MS SQL Server to PostgreSQL. It certainly isn’t perfect, but for those willing to go through the work this would be a very interesting way to add PostgreSQL to a SQL Server shop. I don’t plan on using this right now, but I’m definitely going to file this away as something with potential.
April 11th, 2006 at 9:33 am Adam Kalsey
It would also be a good way to port your product to Postgresql. You could have a live testing environment synced with an existing DB.