Mysql had been the only database we were supporting for a long time.This had served the company very well for a long time but was falling short for some potential customers as they did not support mysql in their data centers.
So we decided to support SQL server in addition to mysql. I will blog about the various issues we faced when adding new database support, the differences in sql syntax and how we were able to accomplish the support for SQL server in a relatively short time.
Our application is a three tier application with middleware being developed in java. The application server connects through jdbc to the database for DML operations. This helped us in supporting the new database vendor as we could intercept all the sql's passing through the jdbc driver and manipulating most of the sql's to conform with SQL server syntax.
No comments:
Post a Comment