I have a new Boss who is an anti-Microsoft fanatic. He wants to setup a Java/MySQL environment in the middle of a MS stronghold. It's up to us to decide on the platform. We can isolate it from the rest of the network.
It's crucial that we can at least port our database to a Linux platform after development.
I'm trying to lead him away from MySQL onto SQL Server. On reading the literature, MS SQL is tops on price/performance. MySQL doesn't submit itself for benchmarking. MS SQL has stored procedures and DTS. MySQL doesn't support stored procedures. SQL Server is built for transaction processing, MySQL isn't. locally, we have a load of suport for MS SQL, nobody is developing in MySQL.
I believe Java can run on Windows and connect to SQL Server, and so can Linux.
Can anyone give me some leverage on the topic to head him in the right path, especially around portability to Linux.
It's crucial that we can at least port our database to a Linux platform after development.
I'm trying to lead him away from MySQL onto SQL Server. On reading the literature, MS SQL is tops on price/performance. MySQL doesn't submit itself for benchmarking. MS SQL has stored procedures and DTS. MySQL doesn't support stored procedures. SQL Server is built for transaction processing, MySQL isn't. locally, we have a load of suport for MS SQL, nobody is developing in MySQL.
I believe Java can run on Windows and connect to SQL Server, and so can Linux.
Can anyone give me some leverage on the topic to head him in the right path, especially around portability to Linux.