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.
Categories
One reply on “Replicating from MS SQL Server to PostgreSQL”
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.