CA ANNOUNCES WINNERS OF THE INGRES MILLION DOLLAR CHALLENGE

Computer Associates International, Inc. (NYSE: CA) today announced the winners of its Ingres Million Dollar Challenge. The winners delivered migration toolkits from Oracle, Microsoft SQL Server and MySQL to CA's Ingres r3 open source platform.

The Challenge was designed to leverage the global talent pool of the open source community, while providing substantial financial compensation to those who successfully met its requirements. Under its terms, open source developers were invited to create solutions that enable users of popular databases to migrate to Ingres. Qualifying solutions were eligible for cash awards up to $400,000, with a total purse of $1 million.

The winning projects were: Shift2Ingres, submitted by Harsh Azad, Rohit Gaddi, Achal Rastogi, Geetanjali Bahuguna and Ashutosh Upadhyay of New Delhi, India, won the largest prize of $400,000; EzyMigrate, submitted by Danes John and Varghese Jacob of Kerala, India, was awarded a prize of $100,000; and DbConverter, submitted by Bipin Prasad of New York, was awarded a prize of $50,000.

“We are grateful for the hard work and creativity of the open source developers who participated in our Challenge, and we will continue working with the open source community to develop migration tools for Ingres,” said Tony Gaughan, senior vice president of development at CA. “With these tools, organizations can easily and cost-effectively transition away from proprietary databases to take advantage of Ingres' highly scalable, feature-rich open source database platform.”

Submissions were judged by Robin Bloor, partner at Hurwitz & Associates; Tony Gaughan, senior vice president of development at CA; Gavin King, Hibernate founder and JBoss, Inc. architect; Alan Runyan, founder and lead architect of the Plone content management system; and Dr. Michael Stonebraker, founder of Ingres, and founder and chief technology officer of StreamBase Systems.

Qualifying solutions had to be capable of interfacing with applications based on the selected databases to ensure unmodified interoperability with Ingres. Submissions were registered on SourceForge and were subject to testing in order to assess their validity.

Shift2Ingres

Shift2Ingres is a schema, data and application migration toolset for Oracle databases and applications, including those that use PL/SQL. It uses a superbly designed, easy-to-use Java GUI to configure and perform the migration of tables and their underlying data, views, grants, sequences, PL/SQL procedures and functions, triggers and other schema objects from Oracle to Ingres r3 databases. To enable the migration of data stored in Oracle proprietary data types and applications that rely on Oracle proprietary scalar functions, the Shift2Ingres team took advantage of the Ingres Object Management Extension ( OME ) interface — which allows user-written extensions to be added to the Ingres r3 database server. The toolset also includes a customized version of the Ingres r3 JDBC driver, which implements a "reverse gateway" that captures and transforms Oracle-specific SQL and converts it to Ingres-compliant SQL at runtime. The application is architected in a modular, extensible and scalable fashion that can potentially add support for other databases and applications by implementing additional defined Java interfaces. The toolset also provides extensive and professionally presented on-line documentation.

Shift2Ingres is available for public use under the BSD Open Source License and can be downloaded at http://www.sourceforge.net/projects/shift2ingres.

EzyMigrate

EzyMigrate is a database migration tool for Microsoft SQL Server that exploits ODBC to connect to the source and target databases. The tool discovers database tables resident in the source database and displays the table definitions to the end user through a web-based front-end. The interface can be used to make modifications to the table definitions. The tool then creates and populates the tables in the target database. The tool allows individual table migrations to be selectively performed and provides multiple models for data migration, including drop-and-replace, delete-and-replace, and append. It effectively handles BLOB data and performs a variety of other data type transformations. In addition, it contains a sample Java application that works identically on both the source and target databases — allowing users to validate their migration.

EzyMigrate is available for public use under the CATOSL and can be downloaded at http://www.sourceforge.net/projects/ezymigrate.

DbConverter

DbConverter is a database migration program capable of converting tables, views, synonyms, indexes, triggers, constraints, groups, roles, users, permissions, sequences and other schema components from MySQL. The program includes a well-designed user interface written in Java that allows the user to select components for migration and to select from an extensive number of options — for example, to perform the migration directly into the target database or to generate an SQL script and relevant output files so that the migration can be performed externally. DbConverter facilitates application migration with plug-ins that can be written to parse and convert associated applications. A sample plug-in is provided to demonstrate this capability. The program also provides extensive HTML documentation including release notes, installation and use instructions, software dependencies, examples and test scripts.

DbConverter is available for public use under the Common Public License Version 1 and can be downloaded at http://www.sourceforge.net/projects/dbcvt.

Full details of the Challenge eligibility and the official rules are available at http://ca.com/ingres/challenge.

About CA

Computer Associates International, Inc. ( NYSE:CA ), one of the world's largest management software companies, delivers software and services across operations, security, storage, life cycle and service management to optimize the performance, reliability and efficiency of enterprise IT environments. Founded in 1976, CA is headquartered in Islandia, N.Y., and serves customers in more than 140 countries. For more information, please visit http://ca.com.


© 2005 Computer Associates International, Inc. One Computer Associates Plaza, Islandia, N.Y. 11749. All trademarks, trade names, service marks, and logos referenced herein belong to their respective companies.