1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Migrate applications from Microsoft Access to Oracle Application Express

Discussion in 'Other Development Tools' started by sameer, Sep 9, 2008.

  1. sameer

    sameer Forum Advisor

    Messages:
    105
    Likes Received:
    6
    Trophy Points:
    240
    Migrate applications from Microsoft Access to Oracle Application Express

    Business organizations use Microsoft Access for many of their desktop database applications but Microsoft Access is suitable only for applications where only small number of users will use the application. Whenever the data becomes sensitive, needs web interface or has a large number of users, Microsoft Access is not anymore a suitable option. Now if you want to migrate Microsoft Access applications to Oracle Application Express you will have to use Oracle Application Express Application Migration Workshop.

    Oracle Application Express Application Migration Workshop helps to meet all Access migration requirements by utilizing SQL Developer Migration Workbench. Firstly, all the data and schema definitions are migrated using the Migration Workbench. Then all the forms and reports of the corresponding data and schemas are migrated with the help of Oracle APEX Application Migration Workshop. At the last step of migration, your application is refined to benefit from all the features and advantages of Oracle APEX. Steps to migrate your applications from Microsoft Access to Oracle APEX using Oracle APEX Application Migration Workshop are as follows:

    [​IMG]
    • Use Oracle Exporter to extract application definition and data from your Microsoft Access database.
    • A single Microsoft Access file would result in two files, one with *.xml extension and the other with *.sql extension.
    • Use Oracle Migration Workbench to convert Microsoft Access *.xml Files into Oracle Database data and objects.
    • Load the Microsoft Access *.sql files that contain application definition on the Application Express.
    • To refine application definition for Oracle APEX you need to use Oracle Application Express Application Migration Workshop.
    • Once you refine all your application definitions and data model, you are ready to utilize all the features and advantages of Oracle APEX.
    • Now you can run your migrated applications easily on the web browser.
    Oracle Application Express Application Migration Workshop works on the principle of migrating design of Microsoft Access applications and then generates Oracle APEX applications by analysis of Microsoft Access data or schemas. It is not possible to migrate every type of logic code from Microsoft Access application to Oracle APEX applications. You can easily compare the results of schema migration by viewing the Microsoft Access application metadata.

    It is also very easy to identify invalid Microsoft Access queries, Oracle views, tables that do not have primary keys, checking syntax of Access reports based on SQL query, etc. in Oracle Application Express Application Migration Workshop. You can select the Microsoft Access objects to migrate and deal with the dependencies on that object. Additionally, you will also get a maintenance application, which have all the forms and reports about the data files and applications that have been migrated.

    With Oracle APEX, you can use your applications in a complete web browser environment and still avail the benefits of an Oracle Database. Level of security, scalability and performance is same as that of Oracle database.