SQL Server and PHP

Today was a big day for our Medialab. After a succeeded test we decided to port one of our applications from IIS, SQL Server and Coldfusion to Apache, MySQL and Coldfusion. The last was not very problematic. Only a couple of lines of code needed upgrading from the ancient version 4 where the application was written in to the current version 8. The most difficult part proved to be the transition from SQL Server to MySQL.
The only thing I could work with was a full database backup provided by our IT department. So I could only recreate the database in SQL Server. With the aid of MySQL Migration Toolkit part of the GUI tools I could transfer the database to MySQL. There was hwever a problem, the encoding. And no matter what I tried, there was always one token that did not translate well. So I decided to do the data by hand.

Syndicate content
thank you for watching  Creative Commons License