Re: Converting Oracle Forms & PL/SQL APPS

>From: Madison Pruet <mpruet1@verizon.net> > >Upsidedown Head wrote: > > Hi all, > > > > Does anyone have any experience or pointers they can give on > > converting Oracle Forms based and PL/SQL based applications to other > > environments so they could be used with Informix IDS for instance ? > > Are there any third party tools out there which would help with > > conversions ? > > Have any of you done this type of work - how painful was it ? and was > > it successful ? > > > > If you need more specific details of the application(s) involved I can > > supply this detail also. > > > > Thanks for any information you can provide. > > > > Upsidedown Head > > >IBM has a conversion tool (MTK) which should help with this. > Pain is going to be relative. Your success is going to be based on how complex your Oracle PL/SQL is to start with. IDS 11 does add some "Oracle-esque" brain dead features that would make things easier. The MTK will help, however you'll probably also have to manually do some rewrites on the more complex things. When doing the migration, you should first consider the type of database, size and redo its layout to take advantage of IDS's features. Then when you get to the pl/sql stored procedures, you'll have to take each one at a time and test it. (The MTK is a tool, its not a silver bullet.) I would strongly recommend that during the migration process, you review your business requirements and determine if it makes sense to refactor anything that you have in place. The key is that YMMV based on your environment. You can ping me and we could talk. HTH, -Mikey _________________________________________________________________ http://imagine-windowslive.com/hotmail/?locale=en-us&ocid=TXT_TAGHM_migration_HM_mini_2G_0507