Last week, one of our senior DBAs made a comment\u00a0 regarding our current migration. Essentially, he was referring to Oracle APEX (formerly HTML-DB) and whether we looked at Forms to APEX conversion.<\/p>\n
Management decided a while ago that we will be migrating to Oracle Forms 10g given that the in-house expertise is mostly Oracle Forms.<\/p>\n
<\/p>\n
I also did not think that APEX is a viable option for several reasons. One of them is the frustation I felt about two years ago when I ran some experiments on the 2.X version of APEX. At that time, some basic functionnalities already available in Forms (such as POST-QUERY) were lacking in APEX. One had to resort to Javascript-AJAX in order to get similar results.<\/p>\n
However, this week end I ran some queries on google to\u00a0 get some links to current work on Oracle Forms to Oracle APEX migrations.<\/p>\n
The most interesting ones are from the blog by David Peake, product manager for Oracle APEX. They can be found\u00a0 here<\/a> and here<\/a> .<\/p>\n So, it seems that the APEX team is finalizing a migration tool for those wishing to move from Forms to APEX.<\/p>\n From where I am sitting, I see some very conflicting options.<\/p>\n First, APEX is free and comes standard with the Oracle DB.\u00a0 Oracle Forms is NOT free and as a matter of fact is quite expensive.\u00a0 So, what is Oracle doing here ?<\/p>\n Is it encouraging its customers to move from a paid product to a free one ? Is it planning to kill Forms. Obviously, that is not an option since the SOD on OTN clearly states that Forms is going to be maintained for the foreseable future. There is even a Forms 11g version coming out very soon.<\/p>\n Second, APEX and Forms are two very different products. While APEX lives in the DB and requires Javascript and AJAX to provide the same functionnalities (I might be wrong here since I did not go thru the complete set of the current features), Forms on the other hand is quite a mature product and with the upcoming 11g version, will provide some additional needed functionalities (PROXY user and javascript support). But, the main drawback that might be working against APEX in the enterprise is its lack of version control (the last time I checked it was still missing).<\/p>\n Nonetheless, I will be testing the current version of APEX. My interest here being to get something similar to MouliForms for APEX. However, I will be using the JDAPI instead of the Forms XML converter as the main tool to get the objects from Forms to the ones in APEX.<\/p>\n","protected":false},"excerpt":{"rendered":" Last week, one of our senior DBAs made a comment\u00a0 regarding our current migration. Essentially, he was referring to Oracle APEX (formerly HTML-DB) and whether we looked at Forms to APEX conversion. Management decided a while ago that we will be migrating to Oracle Forms 10g given that the in-house expertise is mostly Oracle Forms.<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_newsletter_tier_id":0,"jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[1],"tags":[13,93,11],"jetpack_publicize_connections":[],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/phEMW-I","_links":{"self":[{"href":"https:\/\/degenio.com\/blog\/wp-json\/wp\/v2\/posts\/44"}],"collection":[{"href":"https:\/\/degenio.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/degenio.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/degenio.com\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/degenio.com\/blog\/wp-json\/wp\/v2\/comments?post=44"}],"version-history":[{"count":0,"href":"https:\/\/degenio.com\/blog\/wp-json\/wp\/v2\/posts\/44\/revisions"}],"wp:attachment":[{"href":"https:\/\/degenio.com\/blog\/wp-json\/wp\/v2\/media?parent=44"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/degenio.com\/blog\/wp-json\/wp\/v2\/categories?post=44"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/degenio.com\/blog\/wp-json\/wp\/v2\/tags?post=44"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}