Converting MS Access to Oracle® Application Express

Organizations use Microsoft Access for many purposes from desktop database applications with small numbers of users to business applications for small and mid-size enterprises. Yet applications that contain sensitive data, have larger user communities, need complex reporting or could benefit from a Web interface may benefit from migrating to Oracle and Application Express.

Services Inquiry Request

Please fill out our inquiry form to be contacted by a CipherSoft representative.
Services Inquiry Form

CipherSoft’s automated migration tool provides a total solution for migrating Microsoft Access applications to Oracle Application Express. Once your application is converted to Oracle APEX, you can make modifications and enhancements.

The solution is focused on recovering the design of existing Access applications and generating Oracle APEX applications based on the findings. This sometimes requires manual intervention after the migration tools perform the bulk of the migration work. You can also take advantage of the opportunity to improve the migrated Access database schema, which can yield significant benefits to the resulting Oracle APEX applications.

Features of the Access to APEX conversion process include:

  • A view into all application metadata captured from Access, thus enabling comparison with the results of the schema migration
  • Identification of tables without primary keys or Oracle APEX UI Defaults (used to default the new application)
  • Identification of invalid Oracle views or Access queries that the workbench failed to parse
  • Option to include only those Access objects that you are interested in migrating with the additional benefit that the Workshop will understand the dependencies between those objects. For example, if you exclude a view (Access Query) then any Access reports based on that view are also excluded
  • Syntax check of SQL query-based Access reports
  • Optional generation of a "maintenance application" consisting of a report and form for every table and view selected
  • Generation of an application based on your selected Access forms and reports
  • Supports migration from Microsoft Access 97, 2000, 2002, and 2003

Why Migrate with CipherSoft?

Migration is the best option to leverage the application’s competitive strengths and the existing knowledge embedded in the applications. In today’s fast paced market, software migration creates an advantage as it requires little re-training, manages risks and takes full advantage of the new technology. CipherSoft is the market leader in converting legacy applications to the Oracle environment. Our mission is to make the migration process easier, faster and more cost efficient.