I am a relative RDBMS newbie, having only written serious SQL only Microsoft Access. I choose to do much of my relational operations in Matlab. My experience in both are from work.
In my non-work world, I've had no need to develop data skills until I've moved from Windows 7 to 10. I decided that paying more than half a grand (Canadian) for desktop Outlook is too much. As I want to avoid the cloud, I looked at EssentialPIM, which uses Firebird. I don't want to spend a lot of time getting to know more than one DBMS strongly; hence, if I go with EssentialPIM and Firebird, it would be worthwhile spinning up on MariaDB, which comes with Cywin (which I'm very much attached to).
This plan is only good if there is a free way to migrate data between Firebird to MariaDB. I've found commercial products online, but was wondering if a free (and not too involved) way?
I've received autogenerated MySQL SQL source code that creates tables and inserts data literals. There is lots and lots of code that is specific to the source environment. Converting it to Access took a lot of conferring with the most esoteric clauses of the SQL language references for the two environments. Consequently, I don't consider SQL source code dumps to be a welcome solution.
Related note #1: In case a SQL dump is the only free way ahead,
is that what is generated by Firebird's
gbak backup utility? All
my googling hasn't been able to answer this. The most relevant detail
transportable parameter, but it doesn't really specify
the form of the backup file.
Relevant note #2: In case the migration is too arduous, I looked into using Firebird itself. Since the EssentialPIM database will be local to my non-administrator account, I believe that I'm interested in the embedded server Firebird. But man, it still looks a ton more complicated than Access (which is admittedly a low bar) and even MySQL (based on my short stint with that). Afternote: Looks like I was right about the greater involvement. When the embedded server page says "Embedded Server is a Superserver engine plus client rolled into one library", I missed the word "library" and thought that it rolled in a command line client. Back to figuring out the setup in a more general way.