data dump from MS SQL to POSTGRESQL to start our migration…

Well I thought that this would be easy, but its not.  Rich has been working on this for a few days, and it seems that there are 2 migration routes:

  1. use the MS SQL download tool, that dosnt work very well
  2. write a PHP script that imports every parameter from the MSSQL database into a variable, and write it into PostgreSQL.

The problem is, that PostgreSQl dosnt like null fields, and its a bit of a game to import. 

Just for your information, it takes time.