Click here to Skip to main content
15,905,232 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hai all,

At present I am using the ORACLE in my application. But we have some small scale companies as a clients so we planned to use MYSQL for those clients. So would like to get some suggestions to generalize the existing queries which can be executed in both ORACLE and MYSQL.

Thanks in Advance

What I have tried:

I started to replace the syntax like EVL to IFNULL, but we can not replace all the syntax like this.
Updated 7-Feb-17 3:02am

1 solution

All what you need is to write portable Data Access Layer. See: Writing a Portable Data Access Layer[^]
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900