I'm about to commit to EssentialPIM for all of my personal information management. It uses Firebird, and I was debating on whether to (i) spin up on Firebird or (ii) spin up on MySQL (and find a way to migrate between the two RDMSs).
For option (i), I haven't been able to find online examples of what a session looks like from built-in client of the Embedded Server configuration. In particular, the kind of SQL that is used. Can someone please point to an online example of this SQL?
For option (ii), I haven't been able to find examples of what the sQL output of FBExport looks like. That determines how much code surgery is needed to make the exported SQL ingestible by MySQL. Can someone please point to an online example of this SQL as well? (For the import direction, the only option that has been suggested to me is Clever Components's Interbase DataPump, but I'm open to suggestions that are simpler e.g., by not needing ODBC.)