Running MS SQL / Coldfusion on IIS / Windows 2003
We currently have a dedicated development server with our company's host (not hostgator) in which we are charged a decent amount to have on a yearly basis. I was looking to cut down costs and wanted to see if it would be feasible to have a windows box we have in the office setup as our development server. We would install windows 2003 on it along with anything else we need. The current development server is hosted under a IIS 6 / Windows 2003 / CF 7 Environment. If it is doable, what kind of problems would we run into vs having it on a real server? It would only have at the most 3-4 connections possibly once or twice a week so speed is not a huge deal.
Also, how tedious is installing, setting up and migrating everything over for the MSSQL database going to be?
Any input would be appreciated.
“Intelligence is not to make no mistakes, but quickly to see how to make them good.” - Bertolt Brecht