Derby vs mysql

Replies to This Discussion

Permalink Reply by Charlie Arehart on August 1, 2008 at 2:43am

Brendon, sorry I didn't reply to this sooner. I must have missed the email notice that you'd written it. I'll say that I've addressed your question in the resource I've mentioned elsewhere here in the group. In my resource called, "Getting Started with the Apache Derby Open Source Database in CF8", I specifically address the question, "Why use Derby database verses using something like MySQL?".

As for converting data from Derby to MySQL, I don't know of a direct solution, though I wouldn't be surprised if such existed. Someone else would need to chime in (or you should ask in some of the many more generic Derby resource sites I mention in the page above). But I can tell you that I have another resource, listing several hundred tools and resources in over 100 categories, and in it I have a category called, "Database Migration Tools". Hope that helps.

▶ Reply to This