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.

Best regards,
Diethard

On 24 Feb 2015, at 08:04, Vijay Krishna <vijayakrishna55@gmail.com> 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 <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

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
https://www.monetdb.org/mailman/listinfo/users-list


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

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