Moving from mssql to postgres, advice needed

[boa]

We have a couple of MS SQL Server 2000/2005 databases with a bunch of
..NET clients written in C#, but may want to replace the dbserver with
postgres instead. The clients will still run on Windows, hopefully with
as few changes as possible.

We don't have any stored procedures or triggers, so all we need to port
are the tables/index definitions.

What are the most common issues/problems people run into on the client
side? My guesses are stuff like
- identity columns
- transaction handling(autocommited vs. implicit)
- date and datetime
- general error handling and error codes

Anything else?

I've googled for migration guides and howto's, but without success.
Pointers to such are appreciated.

Boa

[boa]

* boa wrote, On 26.08.2006 09:25:

We have a couple of MS SQL Server 2000/2005 databases with a bunch of
.NET clients written in C#, but may want to replace the dbserver with
postgres instead. The clients will still run on Windows, hopefully with
as few changes as possible.

We don't have any stored procedures or triggers, so all we need to port
are the tables/index definitions.

What are the most common issues/problems people run into on the client
side? My guesses are stuff like
- identity columns
- transaction handling(autocommited vs. implicit)
- date and datetime
- general error handling and error codes

Anything else?

I've googled for migration guides and howto's, but without success.
Pointers to such are appreciated.

Boa

Crap, that was definetely posted to the wrong news group. Sorry, guys.

Boa