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:
- use the MS SQL download tool, that dosnt work very well
- 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.