Import Mysql database into Ingres datbase

[ramzigheath]

I'am trying to import our current database (MySql) into ingress database to check Ingres database features and performance ... any help ?

[Bodo]

An ETL tool that supports both DBMS could be helpful, e.g. Talend Open Studio (Talend - Open Source Data Migration)
or a conversion tool like "eva/3 Universal Database Converter" (.:: optadata.com: eva/3 Customer Relationship Management ::.)

[clach04]

Originally Posted by ramzigheath

I'am trying to import our current database (MySql) into ingress database to check Ingres database features and performance ... any help ?

You have a few options, whilst there are no specific mysql to Ingres guides/tool kits there are lots of pieces available to help assist.


DataTypeComparisons - Ingres Community Wiki
Creating Ingres DDL from MySQL db - Ingres Community Wiki

Or even ETL tools like Talend and Kettle.

RE performance, there are many things you can do to influence performance. If you are new to Ingres check out this great presentation http://www.rationalcommerce.com/uploads/tuner.zip that was given at the IUA this year by Roy.

[tallgru]

Talend Open Studio seems to be a good solution for your needs. It is an open source ETL tool for data integration and migration experts. It's easy to learn for a non-technical user. It allows the user to get a graphical and functional view of integration processes.

Once you have performed your migration, you can then use the tool as an extract, transform and load software. You can try it by downloading it freely.

Here's the download page: Talend - Download

[david.postle]

We have recently posted a new set of resources to the Ingres Wiki to cover this whole 'migration to Ingres from product X' area, including MySQL.

The tools page is here: Ingres Migration Tools Projects - Ingres Community Wiki and among the tools listed is a description of how to use an Open Source tool called Druid to migrate from a range of source databases (including MySQL, SQL Server and Oracle) to Ingres. There is an Ingres module now available to connect Druid to Ingres and hence allows a database schema to be migrated from one product to the other.

Talend and the other products major on the data movement part of the exercise, and Druid is more more focused on migrating the schema (though it works fine for migrating small data sets too), but it might fit your needs.

We're working on another tool to migrate Stored Procedures too, but that's not going to be ready for release for a few weeks yet. That's not likely to be such an issue for MySQL anyway.