Please excuse my general lack of knowledge in regards to I.T related issues. I am doing work for a Property Company setting up a rather complex (roughly 50 relational tables) internal database created which holds information about the properties that we currently own and prints out reports e.t.c.
I currently have a short list of companies that are going to create the database for us and I am open to what technology they use to do so but I wanted to make sure there are no suprises down the track and the that the technology is suitable for the project (as my knowledge in this area is somewhat lacking). I'm hoping that the database (backend and frontend) will sit on the company servers (which are operating Windows Server 2003) rather than the clients desktop and I'm hoping that installation will be simple and am looking for something that has no ongoing cost.
Currently the 5 companies on my short list have told me that they are planning on using:
* CakePHP & MySql
* Smart Client Desktop application, developed in C# and .Net Framework 3.5 using MS SQL Express database
* ASP & MSQL Server 2005
* PHP & MySQL
* Microsoft Visual Basic 6 & SQL Express Edition 2005
Can anyone see any problems that may arise with these technologies or point any technologies which would be much more suitable for my situation?
Any help will be tremendously appreciated.