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 <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 <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