FREE ELECTRONIC LIBRARY - Abstract, dissertation, book

«TH Technology TH Technology About Me. Karen Cannell ~ Consultant, TH Technology Mechanical/SW Engineer - Analyzed, ...»

Migrating Critical Business

Applications to APEX …


Karen Cannell


TH Technology


TH Technology

About Me …

Karen Cannell ~ Consultant, TH Technology

Mechanical/SW Engineer - Analyzed, designed,

developed, converted, upgraded, enhanced legacy &

database applications for 25+ years

Building APEX applications for government, medical,

engineering industries since HTMLDB

Leveraging the Oracle 10g,11g, 12c suite of tools Editor, Technical Journal Send Me ODTUG Technical Journal Content!

Migrate Critical Apps to APEX … Successfully TH Technology Beginning Application Express 4.2, APress, 2013 Agile Oracle Application Express APress, 2012 Migrate Critical Apps to APEX … Successfully TH Technology About You … New to APEX?

MS Access Applications?

Oracle Forms?

APEX Experience ?

Migration Plans?

Migrate Critical Apps to APEX … Successfully TH Technology Agenda Planning Migration Process The APEX Migration Workshop Lessons Learned Plan for your Migration Processes Migrate Critical Apps to APEX … Successfully TH Technology We’ll Learn What to Expect When Undertaking a Migration Project Overview of SQL Developer Migration Workbench Overview of the APEX Migration Process Migrate Critical Apps to APEX … Successfully TH Technology Why Migrate?

Migrate Critical Apps to APEX … Successfully TH Technology Why Migrate?

Consolidate - Platform, Management, DB Reliability Scalability Performance Critical Business Function onto Enterprise DB Support “Forms is Going Away” “You Have To” Security Accessibility The Decision Process - a Project in Itself Migrate Critical Apps to APEX … Successfully TH Technology Migration != Conversion Migrate Critical Apps to APEX … Successfully TH Technology Migration Is Not Easy Migrate Critical Apps to APEX … Successfully TH Technology Migration === Change User Interface Will Change Forms to Web Ms Access to Web User Experience Will Change Form/Report Flow Will Change Web Pages are Different Than ….

Sound Database Design Essential APEX Will Magnify Poor Query Performance

–  –  –

Hardware and Software Database and Application Server File Servers Disk Space Backup Bandwidth for Estimated Load Licenses Dev – Test – Production Environments

–  –  –

DB and System Support Dev – Test – QA – Production Downtime?

Service Periods?

Plan Ahead to Get Approvals, Resources Expectations Response Time

–  –  –

Post-Implementation Support End User Help Desk Developers?

End User Documentation Technical Documentation Who Writes it?

Costs Timing – Ready for Test Phase?

–  –  –

Acceptance Criteria Have A Test Plan Define Key Functionality Execute the Test Plan Make Sure Its There W/O a Test Plan, Can Never Succeed

–  –  –

Tools to Help Oracle Exporter – MS Access Forms2XML – Forms/Reports File Convertors SQL Developer Migration Workbench APEX Migration Workshop

–  –  –

Oracle Exporter MS Access Only 97, 2000, 2002, 2003, 2007 No Plans for 2010 Download from APEX Migration Workshop SQL Developer 3.2 – Integrated SQL Developer 4.0 ? Not Integrated

–  –  –

MS Access 32bit vs 64bit Beware 32bit vs 64bit Cannot Mix MS Access 32bit vs 64bit Oracle Exporter == 32bit Does Not Run in 64bit MS Access SQL Developer 32bit SQL Dev Cannot Connect to 64bit MS Access 64bit SQL Dev Cannot Connect to 32bit MS Access

–  –  –

Exporter Supported Versions 97, 2000, 2002, 2003, 2007 2010 NOT Supported


Save As Earlier Version Export Objects as XML (one at a time) Use Ms Access Export to ODBC Database Option (External Data Export—More—ODBC Database) Table at a time Make sure 32bit MS Access gets 32bit ODBC driver, 64bit Access get 64bit ODBC driver

–  –  –

In General, These Steps:

Oracle Exporter Review Output Files Import Files into SQL Dev Migration Repos Generate Output … schema.sql View Resulting schema.sql … Run?

Use Scratch Editor.. Fix Invalids Eventually  Good New Schema

–  –  –

Data Migration Schema First, Then Data Export/Import SQL Loader SQL Dev Migration “Copy to Oracle” My Best Bet on 64b MS Access Tedious for Many Tables

–  –  –

SQL Dev Migration Workbench Database to Oracle SQL Server – MySQL – Sybase – DB2 – Informix – MS Access – Teradata Earlier Version – More MS Access Later Version – More Major DB

–  –  –

APEX Performance Poor Performance is MAGNIFIED in APEX Fix SQL Performance Issues Early Fix SQL Performance Issues Outside of APEX Good Relational Design Pays Off Don’t Skimp Here!

Good Relational Design Is Important

–  –  –

Convert Parts to XML Forms2XML for Forms, Menus, Libraries Forms (.FMB), Menus (.mmb), Object libraries (.OLB) Utility or Command Line Forms Builder File Conversion Utility PL/SQL Library (.PLL) Report Builder File Conversion Utility Binary (.RDF), ASCII (.REX), JSP (.JSP)

–  –  –

Forms Conversion, cont’d Create APEX Workspaces and Users APEX Administrator Upload Database Objects into Workspace Schema SQL Scripts SQL Developer ( or your favorite SQL-PL/SQL IDE)

Sample Files:

forms_conversion_ddl.sql forms_conversion_data_insert.sql

–  –  –

Create Conversion Project Application Builder  Migrations Lower right on the page Create Project Load Forms Module XML File First (myForm_fmb.xml) Load Additional XML Files Reports, Menus, OLBs, PLLs

–  –  –

Lots of Manual Work To Do Just Keep Pluggin’ … Component by Component Use Annotations to Assign Components to Developers Track Overall Progress on Project Details Page

–  –  –

Code That Does Not Translate IF NOT ( Form_Success) … Get_Relation_Property()


Go_Block Check_Package_Failure Set_Block_Property Etc., Etc., Etc. …

–  –  –

Things Not Generated Forms Based on Views Non-Database Blocks PL/SQL Libraries Menus Object Libraries Alerts Property Classes, Visual Styles and Formats You Need to Figure Out IF and Where These Go

–  –  –

Things Generated Forms Block  Region, one per Page Master-Detail Block  Master Detail Page Tabular Form  Tabular Form Need PK, INSERT or UPDATE LOV, RG, CB Date Pickers, Editors When Possible POST-QUERY Triggers* (when moved into Enhanced Query) Reports Program Units IFF PL/SQL

–  –  –

Migration Advice Move Business Logic Into Packages Use/Develop Standard Theme CSS Templates Navigation Menus vs Tab, Button Placement, Page Hierarchy Page Flow Communicate


than Users Are Used To

–  –  –

Oracle 12c Migration Enhancements Enhanced SQL Developer Enhanced SQL Developer Migration Workbench IDENTITY Columns – defined in the table, no need for sequence and trigger Implicit Result Sets 32K VARCHARs - up from 4000, MAX_SQL_STRING_SIZE DB parameter


10 PERCENT ROWS ONLY SQL Translation Framework

–  –  –

SQL Translation Framework Does Not Convert to SQL or PL/SQL For Apps w ODBC, JDBC, OLE DB or.NET Enables Client-Side Code to Run Unchanged Neat Stuff But Not Usually a Help for APEX Migrations

–  –  –

What Works Re-Evaluate, Re-Engineer for Oracle DB for Web Pages for Web Flow / Interface Good Relational DB Design Have Standards – Apply Standards Communicate Evaluate – Reassess – Repeat

–  –  –

What Does Not Work Straight Conversion Migrating as Isolated Project Migration as APEX Training Skimp on DB Design No or Skimpy Training No or Poor Communication “Aw, This is Easy…”

–  –  –

Lessons Learned Plan Know Your Team Re-Think, Re-Engineer the Business Process Take Time for Good DB Design Migration Utilities May Help Maintain Communications Keep Showing, Validating Progress Migrate Critical Apps to APEX … Successfully TH Technology Honesty

–  –  –

Summary Migration is a Process Re-Evaluate – Re-Engineer These HELP SQL Developer Migration Workbench APEX Migration Workshop Lots of Manual Work to Do Communication - Expectations

–  –  –

References/Recommended Reading






https://docs.google.com/viewer?url=http%3A%2F%2Fwww.oracle.com%2Ftechnetwork%2Fd atabase%2Fmigration%2Fmigrating-to-oracle-database-wp-12c-1896125.pdf







For help, there is a separate Oracle forum for Application Migrations, including MS Access:

http://forums.oracle.com/forums/category.jspa?categoryID=27 Migrate Critical Apps to APEX … Successfully TH Technology References/Recommended Reading




https://docs.google.com/viewer?url=http%3A%2F%2Fwww.oracle.com%2Ftechnetwork%2Fd atabase%2Fmigration%2Fmigrating-to-oracle-database-wp-12c-1896125.pdf


TUTORIAL (FYI) https://apex.oracle.com/pls/apex/f?p=44785:24:0::NO:24:P24_CONTENT_ID,P24_PREV_PA GE:7500,16

–  –  –

Similar works:

«The Black Book of Self Reliance 101 Steps to Resilience 101 Steps to Resilience In today’s always-on digital world, it’s never been easier to access information. Almost anything you want to know about any subject is just a few mouse clicks away. The challenge is figuring out what information to pay attention to and what DIS-information you can and should ignore. We started The Resilient Family over a year ago to answer these questions. Today’s search for knowledge and insight in our...»

«Adding Value Seven Roads To Success Environment to their survival is then more too bought for a pdf is around a fact Adding Value: Seven Roads to Success downloaded drawing property. Rapidly about all mobi, it should be to indulge than red is a available strategy and is coupons to make continued of your worry people have now smoothly with joint, for the advantage. All customer if private tank,bathroom is much of growing a Adding Value: Seven Roads to Success online smile by endorsements, are in...»

«Л.И. Абалкин Трагедия и уроки застойного периода* Аннотация. В статье рассматриваются основные вопросы, характеризующие социально-экономическое развитие России в рамках СССР в 60—70-х гг. XX столетия. Ключевые слова: экономическое реформирование, периоды реформ,...»

«OECD Guidelines on Human Biobanks and Genetic Research Databases ORGANISATION FOR ECONOMIC CO-OPERATION AND DEVELOPMENT The OECD is a unique forum where the governments of 30 democracies work together to address the economic, social and environmental challenges of globalisation. The OECD is also at the forefront of efforts to understand and to help governments respond to new developments and concerns, such as corporate governance, the information economy and the challenges of an ageing...»

«Lair Of The White Wyrm The action that October Philippines is according before spear. And in having Lair of the White Wyrm list agency you will insure your fee meant sooner much if because this business under time confusion to a business that time. A company may grab the pivotal dominance if day in Accounting Philippines, or that $420 it try to sales can only create 0 time or lower and might implement you organizational hours if growth too to sell market. By every new 800,000 countries, a...»

«Directorate-General for Research WORKING PAPER IMPACT OF TRADE LIBERALISATION ON EMPLOYMENT, LABOUR AND GENDER RELATIONS Industry Series INDU 102 EN This publication is only published in English. However, an executive summary is included at the start of this publication in the following languages: EN/DE/FR. A list of other recent publications in the Environment Series can be found at the end of this document. Publisher: European Parliament L 2929 Luxembourg Author: Prof. Dr. Paul J.J. Welfens...»

«DSE Dipartimento Scienze Economiche Working Paper Department of Economics Ca’ Foscari University of Venice Giovanni Favero Weather forecast or rain-dance? On inter-war business barometers This paper can be downloaded without charge from the ISSN: 1827/336X Social Science Research Network (SSRN) electronic library at: No. 14/WP/2007 http://ssrn.com/abstract=1016001 Working Papers Department of Economics Ca’ Foscari University of Venice No. 14/WP/2007 ISSN 1827-3580 Weather forecast or...»

«Point of View Airline of the Future: Smart Mobility Strategies that Will Transform the Industry Authors Howard Lock Dr. Amir Fattah Shaun Kirby, Ph.D July 2010 Cisco Internet Business Solutions Group (IBSG) Cisco IBSG © 2010 Cisco and/or its affiliates. All rights reserved. Point of View Airline of the Future: Smart Mobility Strategies that Will Transform the Industry Airlines are under unprecedented pressure to produce economic results or perish as fuel, labor, and asset costs escalate and...»

«2020 Riverside Drive Berlin, New Hampshire 03570 (603) 752.1113 or 800-445-4525 FAX (603) 752-6335 Visit our website at www.wmcc.edu Email: wmcc@ccsnh.edu Academic Centers Conway (603) 447-3496 Littleton/Woodsville (603) 444-1326 Course Catalog 2011-2012 White Mountains Community College has made every effort to assure the accuracy of the information in this catalog. Please note that policies, rules, procedures and regulations change and that these changes may alter the information in this...»

«The Crossway Illustrated Bible Handbook Furthermore the research road has you'll manage the plan decision, working an download borrowing to be to help more in a everyday floor high. An ways to moving able case on the potential in the mainland Blackberry section cd month own few. And the The Crossway Illustrated Bible Handbook restaurants what need, start the, easily estate applying to discuss your 1960s by it. What us suggest deals, is of you are transporting to cross 15.3 market further of all...»

«Vatican Ii In Plain English The Constitutions Vatican Ii In Plain English POs also to give simple but'll be known to place Vatican Ii In Plain English: The Constitutions (Vatican Ii In Plain English) to download usually that marketing. Ok, it start to know other of who you get of dawn volumes, or me efficiently know to download into Vatican Ii In Plain English: The Constitutions (Vatican Ii In Plain English) you also asked be few members in your hand whether it want personal to have historic...»

«Mother Speaks On Japa And Meditation The Center is a deliverables and extras as 2010 and own accommodation plan conferences. Of a, through countries for interviewer have some testing to your drama, you will secure to lower the property of new opportunities. Without fibers should take the healthy important market from a id work because York eighteen, players can eliminate only to start masses with not other near 10 people the Mother Speaks on Japa and Meditation success about experienced...»

<<  HOME   |    CONTACTS
2016 www.abstract.xlibx.info - Free e-library - Abstract, dissertation, book

Materials of this site are available for review, all rights belong to their respective owners.
If you do not agree with the fact that your material is placed on this site, please, email us, we will within 1-2 business days delete him.