data dump from MS SQL to POSTGRESQL to start our migration…
Posted by Adrian on Mar 11, 2007 in Open Source | 0 commentsWell 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.
