Oracle Forms Migration Challenges- A Recap
I finally was able to complete a document that highlights the phases, challenges and solutions that we put in place during our migration from Forms 6i to 10g.
I would have hoped to have it before we embarked on the migration but here it is for those that might have to go through the same. Please do place your comments so I can improve it.
Download document: Challenges migrating Forms 10g
Make A Comment: ( 33 so far )
33 Responses to “Oracle Forms Migration Challenges- A Recap”
Grant
January 14th, 2009
Thanks for the comments Grant.
Yes, please you can link the paper from OTN.
I sent you an email with the details concerning the length of time it took us to migrate the modules.
Hafed
January 16th, 2009
Hi Hafed,
Well, I’m in a bit of a bind!
I have a client that needs to migrate from Forms 6i to Forms 10g… for obvious reasons! The migration is fairly straight forward, except for images. They store JPEG and TIFF images in the DB and on a Unix file system. Now, I’ve read contradicting blog entries about TIFF being supported or not… more on that later. For images, clarity and precision is a must, as it’s an intellectual property application. Furthermore, they need to zoom in, zoom out, rotate, etc… images, in other words, they need the “bells and whistles” in image manipulation!!
Ok, you’re going to say WebUtil!! That’s a no-go!! Performance is very poor (users query thru images) and it doesn’t provide with the “bells and whistles”. I’m currently investigating JavaBean but I’m battling with the concept. It is fairly new to me. What I’m looking here is for a concept. Am I on the right track??
I would sure appreciate if you could reply to my home email address. That would be appreciated!!
Thx!!
Steph
Stephane Vinette
January 16th, 2009
As far as your application is concerned, I don’t think webutil will help you.
The concept behind Forms javabean is extremely simple. I found it very hard to understand by going thru Oracle Forms help.
However, once I saw the light, it is a piece of cake.
As far as Java is concerned, it is not really required to be a hard core Java specialist. You need the basics in order to write a Forms javabean.
A good book that you can use for your Image application is Filthy Rich Clients by Chet Haase and Romain Guy. One of the best when it comes to Graphics with Java and some nice discussions there about image processing basics (scaling, stretching, processing etc.)
Hafed
January 17th, 2009
hi.. now I want to convert my form 6i to 10G, but I’m confuse about mouliforms..? can i download this tools free…? please your advise..
yongki
January 19th, 2009
I plan to make MouliForms available for download. I really did not have time to cleanup the code.
Too busy with the Rich text editor right now.
Hafed
January 20th, 2009
great job
i’m a newbie but i’m tryin to progress , now i’m workin on 2 projects migration from 6i to 10g i’m startin with java also as i see it’s helpful(jdapi) to have some idea about it to go through the migration , so thank u hafed , ur blog helps me a lot to understant my project. finaly i hope that u will share MOULIFORMS (with source if possible) 
thks
hoolako
February 3rd, 2009
@hoolako: glad you liked the material in this blog.
Hafed
February 3rd, 2009
Hello,
Just discovered this blog and it has a lot of useful information that I will soon need.
Did you share your MouliForms tool and/or code.
If yes can you please let me know where to get it from?
Thank you
Don
Don
May 1st, 2009
Hello,
Do you think you can share the migration code as is?
I will try to figure out what to do with my migration then.
Thank you
Don
June 11th, 2009
Hello Hafed,
Do you think you can share MouliForms with us as is?
Thank you in advance for your reply.
Don
June 16th, 2009
Thank you Hafed,
The executable of Muliforms is more than welcomed for me.
If you have my email, which is hidden to my posts, please email me the executable, otherwise I can post my email.
Thank you once more for your offer, help and this excellent blog.
Don
June 17th, 2009
Have you been able to share MouliForms? I am involved with a migration project and would be interested in using it/concepts from it.
Could you provide the executable if you have not yet shared it?
Thanks in advance
paddy
June 17th, 2009
There’s a more comprehensive tool out there for the Forms Migration call PITSS.converter (www.pitssamerica.com). This tool takes care of over 160 migration issues, which is much more then Migration Assistant or Mouli.
They can do a migration of 50-1000 in days.
Somethings like TEXT_IO still work, but they work on the App Server. Is tha OK? Do you want all TEXT_IO to occur on the AS or all on the Client. Those are generally your options with these other tools. PITSS.converter allows you to choose all, by form, by statement. It miraculoous.
There are a lot of other examples of things that need a more comprehensive approach then a batch file type of conversion.
Look them up
Dwight Shrute
June 17th, 2009
Correction. PITSS.converter can do much more then 1000 in days. It was a bad statement. They can do 50 forms, they could do 1000 forms, or even 10,000 forms in days. There is no limit
Dwight Shrute
June 17th, 2009
Hello Dwight,
The converter you mention is not for free, and here we have Hafed offering his work and expertise for free.
Therefore we are much appreciated to him.
This is not a Marketing and selling Blog for you to take advantage.
Hafed can you please email me the executable of Muliforms since I have not received it yet?
Thank you.
Don
June 18th, 2009
Hello Hafed,
We are currently investigating doing a migration
from Forms 6i to 10g as well and would be interested in
testing the MouliForms out as well. Could you send us the
executables in their current state?
Thanks!
Tim
June 18th, 2009
Thank you Hafed for your updates.
All you hard work and sharing with us is really appreciated.
Best regards
Don
June 22nd, 2009
Hello Hafed,
Any news on the MouliForms executable?
Thank you.
Don
June 29th, 2009
Hello Hafed,
Any news on the MouliForms executable?
Please reply to me whatever your decision is (positive or negative) in order to plan my migration accordingly.
I you can share the version with the French messages that is fine with me as well.
Thank you in advance for your reply.
Don
July 13th, 2009
Thank Hafed you for your prompt reply.
Don
July 13th, 2009
Hafed,
I am also interested in the free tool developed by you. Can you please share the executable. Please send it to my emailid which is hidden. Some notes on what is migrated with this tool will be really helpful.
Thanks in Advance
Narasimha K K
July 16th, 2009
Reminder
Hello Hafed, Since it is Sunday and you might have some free time can you please email us the muliform executable?
Thank you in advance for all your help.
Don
July 19th, 2009
Hello Hafed,
On Monday I am starting my migration.
Any chance to get the promised MuliForms executable?
Thank you.
Don
July 24th, 2009
Hafed, I admire your effort in building the tool. I have a requirement to convert 500+ forms in real short time. I used the Oracle supplied Forms Migration Assistant, but the tool is a waste one. It messed up my whole thing. I would really appreciate, if you can share the executables. I have very stringent timelines. Please help…
One suggesstion from my side – you can publish your tool under GPL (http://www.gnu.org/licenses/gpl.html)to get the world know about your technical expertise.
Awaiting your reply…
Thanks a ton !!!
Raj
October 7th, 2009
Hello Hafed, it’s a great tool that you have developed. It would be possible that you share Mouliforms? Could you please send me the executable?
thanks
Randall Aguirre
December 31st, 2009
Hi Hafed,
Thanks for the blog on forms conversion. I’m involved in a forms conversion from 61 t from 6i to 10g and would like to know the steps involved from a developers
perspective and how much of DBA work is involved. We have about 150 forms here and
I’m not sure about the length of time it would take based on the level of
customization in these forms. I would really appreciate your help on these as it
would help guide me. Thanks.
Satish
January 6th, 2010
Reallt interesting blog. Could you share the total time it took to migrate your 1200 modules?
Thanks
grant
(I’d also like to link this paper from OTN if thats ok with you)