SQL Server to Postgres

Question

I am doing some research on migrating away from Microsoft sql server to postgresql and am looking for the best tools to get the job done.

Specifically looking for a tool similar to MySQL Migration Toolkit, I did a test migration of our databases to MySQL and had each one under way in under an hour.

It looks like pgAdmin will do most of what were doing with Sql Server Management Studio and the pg_stat tables will be good enough for performance tuning.

So what are the other key tools that everyone uses when developing for and working with postgresql ?

Answer 1

Maybe these links / tools would be useful?

http://wiki.postgresql.org/wiki/Microsoft_SQL_Server_to_PostgreSQL_Migration_by_Ian_Harding

http://www.swissql.com/products/datamigration/data-migration.html

http://codebetter.com/blogs/karlseguin/archive/2009/10/22/migrating-to-postgresql-with-my-friend-nhibernate.aspx

http://www.enterprisedb.com/products/postgres_plus_as/overview.do