Migration from SQL Server to PostgreSQL

[Shrikant S Kulkarni]

Hello All

One of our clients is at very initial stage of migration from SQL 2000 to PostgreSQL. It’s not been finalized and some research is going on. Since I am new to PostgreSQL, I don't have any knowledge about it. Can any one focus on migration difficulties from SQL Server 2000 to PostgreSQL? I know some of it can be Case Sensitivity, Syntactical differences between SQL and PostgreSQL, Security etc.

Thanks
Shrikant

[michaelb]

I don't have a knowledge of problems specific to this migration, but if you google for "migration to postgresql" you may find some helpful tips and also some third-party tools (SQL Manager and others), which can make migration easier.