Moving to MySQL

I’m currently involved in moving an application from SQL Server (2000) to MySQL.  The reasoning isn’t terribly relevant, but primarily it’s an open source v. closed source issue.  This (aging) J2EE app required a proprietary bridge between the application server (Java on Linux) and the database (SQL Server on Windows 2000 Server).  That odd adapter has caused us all stress over the years.  Being proprietary, we didn’t know exactly how it worked nor whether it would be around tomorrow. (continue reading…)