Hi,
I am trying moving a database from postgresql to MS SQL. Can anyone advice me how to do this in a reliable way?

Thank you.

Have a look at this or this.

Why are you migrating away from PostgreSQL? Reliable, good information, helpful community, unmatchable price/quality, works on Windows and Unix ...

Thanks for your reply, Wim.
Because my boss wants to migrate our database from Postgresql to SQL Azure, there is a three months free trail on windows Azure. He want to try it.

Thank you for the replay again.

I Got error msg:
USE statement is not supported to switch between databases. Use a new connection to connect to a different Database.

Anyone know how to solve this problem?

Thank you.

There is a difference in mindset between SQL Azure and previous versions... Since the SQL instance is "cloud hosted" your code can no longer use the USE statement to switch databasse connections. You'll need to create a new ADO connection for each database that your code needs to access.

-PatP