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

Be aware that there is a bug in the bulk loader in KETTLE. It works only upto Jan2014-SP1 release. http://jira.pentaho.com/browse/PDI-12278 Radovan On 02/24/2015 09:41 AM, Diethard Steiner wrote:

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 mailto: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.

Hi, for what it's worth, you might find the attached script inspiring or even useful. DISCLAIMER: -- NOTE: -- "MySQL-2-MonetDB.sh" is a very first very simple approach to -- automatically convert a MySQL SQL dump into a MonetDB SQL dump. -- There is no documentation other than the code itself. -- The script comes without any ambitions, let alone guarantees, of -- completeness or correctness. Some MySQL-specific features that -- diverge from or go beyond the pure SQL standard are not taken -- care of, yet, other than being recognized and dropped/ignored. -- So far, the script has been successfully tested and used with a single -- MySQL dump, only. Any feedback is more than welcome. Please share your -- feedback with users-list@monetdb.org . -- Please also be aware of the fact that loading a large DB dump via mclient -- is not the fastest/most efficient way to load large amounts of data into -- MonetDB. Alternatively, consider dumping only the DDL from MySQL as SQL, -- while dumping the data into CSV files. Then use (a variation of) this -- script to turn the MySQL DDL dump into a MonetDB DDL dump, use that to -- create your tables, etc. in MonetDB, and then load your data from the CSV -- files using MonetDB COPY INTO bulk data load; cf., -- https://www.monetdb.org/Documentation/Manuals/SQLreference/CopyInto -- Thanks & Enjoy, -- Stefan.Manegold@CWI.nl (http://www.cwi.nl/~manegold/) Best, Stefan ----- Original Message -----

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

-- | Stefan.Manegold@CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold/ | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |