Reports Migration
Methodsoft specialises in migrating/upgrading reports from Reportwriter 1.1, Reports 2.5/3.0 and SQL*Report (RPT) to the latest versions (Reports 6i , 9i and 10g). High productivity migration tools ensure a rapid and very cost effective upgrade is possible. If you have legacy reporting tools, please contact us so we can provide you with a quotation for upgrading them.
Versions that we upgrade.
Most of the upgrades we see are Sql*reportwriter version 1.1 or Reports 2.5 both of which usually upgrade very easily. Occasionally we find clients with RPT (also called SQLReport) which requires a more difficult upgrade. We have used tools to upgrade RPT in the past with varying levels of success. If you have RPT then please ask about the issues and the options.
As mentioned above, currently the most popular destination for upgrades is Reports10g. The reports are run using the Reports Server that is part of the Application Server platform.
Upgrading Reports6i
Reports 6i is very easy to upgrade. The choice of output does make a difference - with PDF format our preferred choice. We have library routines to make the migration quick and painless with high quality output in the chosen format. The resulting 10g reports run through the reports server using the Methodsoft call library. You get all the source code and can modify it (if needed) to meet your site's specific/particular requirements.
Upgrading Oracle RPTs (Sql*report)
This is conversion from the oldest version of Oracle's reporting tools. Methodsoft offers two possible upgrades for this to pl/sql with HTML output or migration to Reportsd 10g/11g.
Conversion to PL/SQL
This is an Automation Tool that is used as part of our SQL*Report Conversion Service. It allows SQL*Report's RPT to be converted with 100% accuracy into PL/SQL Stored Procedures. The output files generated from the conversion can then be compiled within the desired Oracle Database version for subsequent deployment as PL/SQL Reports for versions 8 and higher.
Report output generated is an exact identical match to the original and can be in Text, HTML or PDF format. HTML Reports can be further customized to make full use of HTML Tags, CSS, etc. The converted reports can be called from any front-end application such as Oracle Forms applications, which will display the generated output of these reports within the same application or in a separate web browser window, when deployed as part of a Client/Server or Web-based application. Instead of manual conversion that can take up to 1 day per RPT program, the use of this Parser allows thousands of programs to be converted in just a few hours to expedite the entire process of subsequently transforming these "legacy" applications into the latest, modernized and user-friendly Client/Server or Web-based applications.
The conversion takes place with NO change to existing functionality and business logic of the original RPT programs. The entire migration process strictly adheres to Oracle's Best Practices and in conformance to our well-proven methodology for upgrading SQL*Report applications. The migrated PL/SQL code can be maintained by the client for future enhancements and modifications.
Conversion to Reports 10g/11g
With our RPT->PL/SQL Parser, we are able to quickly transform any RPT program into the latest, modernized and user-friendly Client/Server or Web-based Oracle Reports program. Hundreds of character-mode reports written in RPT can be quickly converted into PL/SQL procedures, from which we can quickly transform these old legacy Report programs to the latest web-based Oracle Reports using our own in-house tools. Reports generated will be an exact match to the original and can be output in the desired format that the customer is looking, eg, HTML, PDF, Excel, RTF, XML, etc.
Upgrading Pro*C and other 3GLs
We have excellent experience of upgrading Pro*C code to work with Oracle 10g. We have performed this process for several clients and the resulting migrations have been quick and cost-effective. The testing involved post-migration is the most time-consuming aspect of the migration, and we have generally performed testing utilising a partnership approach, sharing the effort between ourselves and the client. This has produced excellent results as well as a significant reduction in the costs of the upgrade.
FREE Trial
We offer a Trial Evaluation Service FREE of CHARGE to you for an evaluation of the Professional Quality & Speed of our Conversion/Migration/Transformation processes as mentioned above. You should provide us with 3 Samples of your existing Source Files that we will transform to the desired newer version to allow you to assess the work that we have performed.
With Total Automation that is provided by our Tools for Conversion/Migration/Transformation Services, we can transform your application(s) a number of times until Full Customer Satisfaction is gained. This is Our Guaranteed Success to you for 100% Confidence with our Automated Tools, Processes & People.