This discussion is archived
5 Replies Latest reply: May 21, 2012 4:51 PM by 84959 RSS

Access 2003 migration to APEX with a lots of reports and macros

cosytec Newbie
Currently Being Moderated
Hello, dear Oracle fans,

I have to evaluate the workload of migrating an existing Access 2003 application (130 tables, 30 reports to keep, a few macros to load txt and xls files).
My ideal target is Oracle + APEX (rather than SQL Server)

I have read carefully:
http://www.oracle.com/technetwork/developer-tools/apex/application-express/tutorial-090294.html
and:
http://www.ukuug.org/events/seminars/databases/APEXforUUG2.pdf (very enthousiastic)


I am still wondering about the time necessary to terminate and adjust the migration of reports (as well as XLS connections: odbc loader?).

Is there a version of the Northwind/Southwind DB including 5 or 10 Access reports with tricky joins or format comparisons?
What would be an other feasible approach?

I would need to have a realistic estimation of time before proposing it to our end-users and administration team.


Thanks in advance
Xav

Edited by: cosytec on 16 mai 2012 12:25
  • 1. Re: Access 2003 migration to APEX with a lots of reports and macros
    mkirtley-Oracle Expert
    Currently Being Moderated
    Hi Xav,
    The following URL has details on how to move the Access data to Oracle using the SQL*Developer Migration Workbench -

    Migrating from Microsoft Access to Oracle -
    http://www.oracle.com/technetwork/products/migration/access-084991.html

    However, if your main concern is in migrating reports to APEX then it may be better to open a thread in the Apex forum -

    Forum: Application Express

    Application Express

    Very often the time for these migrations really does depend on the complexity of the reports so it isn't always possible to give a timescale.

    Regards,
    Mike
  • 2. Re: Access 2003 migration to APEX with a lots of reports and macros
    cosytec Newbie
    Currently Being Moderated
    Hello Mike,

    Thanks for your answer.
    Well, we may need an APEX+Migration subforum ..
    The point is that I am quite conscious that report migration is hard to estimate.
    I would like to try to migrate a reduce set of reports (3, 5,10) in order to have a better estimation.

    Has somebody seen an MS Access version of the Southwind or Northwind DB, including reports ready to be migrated and tested?
  • 3. Re: Access 2003 migration to APEX with a lots of reports and macros
    mkirtley-Oracle Expert
    Currently Being Moderated
    Hi Xav,
    I think you are more likely to find someone who has experience of migrating reports in the Application Express forum than here, as the report migration is different from migrating just the data.
    Try there and if they aren't able to help then get back here.

    Regards,
    Mike
  • 4. Re: Access 2003 migration to APEX with a lots of reports and macros
    cosytec Newbie
    Currently Being Moderated
    OK, Mike. I'll do it anyway.
  • 5. Re: Access 2003 migration to APEX with a lots of reports and macros
    84959 Explorer
    Currently Being Moderated
    Hello

    You can download a sample Ms access northwind database from here : http://www.microsoft.com/en-us/download/details.aspx?id=19704. If you just google it, you will find it. I have not load it myself but it has reports/forms.

    With respect to estimating the effort involved in migrating the access reports to APEX, you can also check out this article on OTN: http://www.oracle.com/technetwork/developer-tools/apex/application-express/mig-index-095631.html and http://www.oracle.com/technetwork/developer-tools/apex/application-migration-workshop-167993.HTML. At least it can give you an idea on what the process might look like.

    But overall the complexity of the migration will depend on:

    1. Number of reports
    2. Complexity of the reports in terms of MS access features that are not available in oracle
    3. Features that cannot be converted by Migration workbench.

    There is a partner that has developed good expertise to migrate to APEX in case you need external assistance.

    Regards

    Prakash

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points