Content Summary : The goal was to have code that can be run identically on SQL Server or PostgreSQL. Changing only the DB connection string should be sufficient to change the database backend. There are a few differences between PostgreSQL and SQL Server that need to be accommodated in order to allow this to happen. Most of the important changes can be done in the database itself, but a few changes to the .asp code are necessary as well. Note that the following suggestions tend to implement functions in PostgreSQL that simulate existing functions in SQL Server. This could severely hurt performance. The emphasis is on creating cross­platform code so that there is no down time while databases are moved over to PostgreSQL.After the transfer is complete, then the code can be optimized for the PostgreSQL database. 1. Opening RecordSets must specify “select * from ” instead of simply providing “”.