Re: Migration from MySQL to MonetDB

Hi, The open source tool Pentaho Data Integration (Kettle) is an excellent choice. It also has a dedicated MonetDB Bulk Loader step. You can download it from here http://sourceforge.net/projects/pentaho/files/Data%20Integration/. Best regards, Diethard

On 24 Feb 2015, at 08:04, Vijay Krishna wrote:

Thanks a lot Martin.

Guys, if anyone has used any such ETL tools for migration from MySQL to MonetDB, please suggest me.

Thanks in advance.

Thanks & Regards,

Vijayakrishna.P. Mobile : (+91) 9500402305.

On Tue, Feb 24, 2015 at 1:21 PM, Martin Kersten mailto:Martin.Kersten@cwi.nl> wrote: Hi

Indeed, no database system speaks the same version of SQL See e.g. http://en.wikibooks.org/wiki/SQL_Dialects_Reference http://en.wikibooks.org/wiki/SQL_Dialects_Reference

Intra database porting is commonly addressed by ETL tools.

regards, Martin

On 24/02/15 08:46, Vijay Krishna wrote: Hi,

I have been trying to migrate my databases as a whole from MySQL to MonetDB. I tried out dumping from MySQL and restoring to MonetDB. But I received a lot of syntax errors due to the mismatch between MonetDB dump file recognition and MySQL dump file.

Is this migration as a whole possible? Any ideas on how to do this?? Has anyone tried this out?? If not possible, what is the easiest way to copy a database as a whole from MySQL to MonetDB?

Any help much appreciated. Thanks in advance.

With Regards, Vijay.

_______________________________________________ users-list mailing list users-list@monetdb.org mailto:users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list https://www.monetdb.org/mailman/listinfo/users-list

_______________________________________________ users-list mailing list users-list@monetdb.org mailto:users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list https://www.monetdb.org/mailman/listinfo/users-list

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list