Sometimes, it just pays to do a little cost/benefit analysis on the things your trying to do. I was reminded of this today in a rather stark way.
I did some data entry in a web application that I was running on a Windows server. It took me about 4 hours to enter all of this data. I am in the process of trying to get rid of this server instance, however. So in an attempt to save work, I moved the web application and database over to my new Linux server. Here is what happened:
- It took approximately 2 hours to export all of the data from SQL Server and import it into my MySQL database.
- Another hour was spent configuring Apache for the web application and configuring the web application to talk to MySQL.
- I’ve now spent over 9 hours on porting all of the SQL statements and trying to fix all of the compatibility issues. There are a number of assumptions that were made (like what the path seperator character is) that were based on it being on a Windows server. I still have several required areas of the application that have not been ported yet.
- Research and download a new web application written specifically for Linux (Apache/MySQL). About an hour.
- Install said application. Another hour.
- Reinput all of my data from a print out made from the original application. Another four hours.