ROI Scenarios

Three scenarios are presented below as a means of providing illustrative costs and savings in relevant situations. Each real-life situation differs in its specific requirements and it is not possible to provide exact figures for each potential variation. Further, the prices shown are subject to change without notice solely at the discretion of DB Best Technologies.

Scenario I: Simple database migration project..

Customer A (a manufacturing company) has a Visual Basic application with Oracle at the backend, which he's interested in porting to Microsoft SQL Server in order to cut costs. The database consists of 150 tables, and 300 stored procedures, functions and triggers, none of them packaged. The application communicates with the database through stored procedure calls. The estimated project length without using the DB Best solution is three months with two consultants; the consultant's fee is $100 per hour.

How to read this diagram:

• Effort distribution – shows a timeline for each project step and its relative part of the whole project. All steps combined (Schema, Business logic migration, Database testing and Application conversion) comprise 100% of the migration project.
• Cost without DB Best – provides the cost estimation of the particular project step when done manually.
• DB Best Effort Reduction – provides the percentage of the manual effort saved by using DB Best Migration Lifecycle Suite.
• Cost with DB Best – provides the cost estimation of the project step when using the DB Best Migration Lifecycle Suite.
• DB Best Cost Saving - based on the Consulting cost and DB Best Effort Reduction for a specific step, a dollar value of the estimated cost saving is provided.

Scenario II: Database migration without rewriting the application.

Customer B (a telecom company) has a 3-tier Java application with Oracle at the backend. Partner S is working on the project. The goal is to make the application run on Microsoft SQL Server. The database consists of 300 tables, and 2000 stored procedures, functions and triggers, most of them packaged. Nested tables, objects, and built-in packages are widely used. The application extensively uses dynamic SQL. The estimated project length without using the DB Best solution is six months with four consultants; the consultant's fee is $100 per hour.

The DB Best solution would be to provide the product (including the Runtime Query Converter) bundled with professional services and training to Partner S.

Scenario III:
Database migration including rewriting the application from Java to .NET

Customer C (a financial services company) has a complex distributed system with multiple applications (Java, VB, C++) talking to Oracle at the backend. The customer wants the Oracle database to be replaced with Microsoft SQL Server. The Java part of the application will be rewritten to .NET, and the other source code will be kept intact. The database consists of 700 tables, and 10,000 stored procedures, functions and triggers, most of them packaged. Performance is very important. Part of the entire application is a data warehouse. The estimated project length without using the DB Best solution is 10 months with 20 consultants; the consultant's fee is $100 per hour.

DB Best would accomplish this project alone, or by partnering with a system integrator or consulting firm. Under the partnering scenario, DB Best would provide the product, and the consulting services would be shared between DB Best and the partner, depending on resource availability.

Note: the significant effort in this example goes into rewriting an application from Java to .NET, where DB Best solution can't be fully leveraged. However, the savings from the database migration and testing components are very dramatic.