Moving from mssql to postgres, advice needed

Giganews Newsgroups
Subject: Moving from mssql to postgres, advice needed
Posted by:  boa (boase…@gmail.com)
Date: Sat, 26 Aug 2006

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

Replies