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