Server and db Question
I did not know where to post this question so I thought it best to post it here.
I was fortunate to get a new system board, processor, and memory for my desktop computer (gaming). This lets build a new server based on the old system components they are sitting happily in a case waiting a new power supply on pay day :-)
I'm looking at windows server 2008 x64
Has anyone installed MySQL, Oracle, and MS SQL on the same box, may be not running the services at the same time but install them to run when needed. I understand the core issues involved here memory, disk space, etc...
Some experiential advice would be helpful.
If you have enough disk space you can install them in same machine. As far as I aware MySQL and MS SQL service are not able to run at the same time. If you want you can install them in different partitions as well. I wonder what's the reason to use all of them?
I want to write connection strings and statements for each dbms so I know the differences. MS's is installed in windows but to connect Oracle or MySQL you have to have a client on the machine.