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.
Posted
Updated 7-Feb-17 3:02am
v2

1 solution

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

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