My office grew over time and I now want to move all the databases we are using to a dedicated server in my office. I want to use the server also for storing all business files.
I have 5 Windows (XP and VISTA) workplaces that need to connect to the server.
3 Databases will be running.
1 x MySql Database (inventory management system) 2 x Sybase iAnywhere Databases (DHL shipment database and Accounting Software)
Does anybody have an idea what would be a good solution? Should I get a "real" server or simply get a normal Desktop PC with Windows and use this as server.
On the one hand I want a fast solution, but on the other hand I do not want to pay a lot of money for a server solution where I could connect a thousand clients when I only have five. For example: I don't want to get a Quad Core server when three of the processors never even kick in since there are only one or two connections at a time.
What do you use in your small business office? Any suggestions?
A decent 'desktop PC' should be suitable for your needs except I wouldn't run XP or Vista, instead Windows Server 2003 or 2008, IMO. If you plan on expanding or using these dbs for anything web related, you might want to reconsider the 'real server' option.