Porting Approach

dhruv
2003-11-22
2004-01-13
  • dhruv

    dhruv - 2003-11-22

    Hi,
    Can I make a suggestion. If we move all the business logic into Java instead of using stored procedures and stick to the bare minimum for insert delete and update. Store all the querys strings in a database table. Making a switch from one database
    would not be a problem.

    That way you can still have your core source code  in Oracle.But a group could convert the strings. Testing should also not be a problem.

    We could use one test script to test all builds.

    Using ANTLR we could write rules to convert Oracle PL SQl to other SQL databases

    Dhruv

     
    • Marco LOMBARDO

      Marco LOMBARDO - 2004-01-13

      I don't know... it's not the same thing: create a store procedure let you control esecution, privileges, you get less network traffic.

      More interesting would be design store procedure with a meta language.

      In addition PostgreSQL have a language for store procedure very similar to Oracle, and MaxDB database is compatible with Oracle 7.

      Mar

       

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks