Firebird SQL differences?

[UncleRobin]

After finding out how to export an odb as an sql file
SCRIPT ‘path/filename.sql’
I’ve exported my own current odb and the one one @Renel very kindly gave me, to study them and see how I can build my new one in SQL rather than in the GUI.

I have also done the same with Medien_ohne_Makros_Hsqldb from the German Handbook for Base 7.2. Hoever, as I plan to build my next DB as a non-embedded Firebird, I’d love to export the Medien_ohne_Makros_Firebird , but trying the same script generated an SQL error.

I half expected this, and it’s related to another question I have - is there a published list somewhere of SQL dialect differences between Firebird and LO’s HSQL? And, in this specific example, what SQL should I enter in LO’s SQL command window to export any of the sample Firebird DBs to sql files, for study and comparison?

[RobertG]

For functions in HSQLDB and Firebird: Appendix B Comparison of HSQLDB and Firebird

Don’t know any function in Firebird to export the content of a database as SQL code.

If you have exported “Medien_ohne_Makros_HSQLDB” this is the original of the database. “Medien_ohne_Macros_Firebird” is migrated by the wizard and the functions, which are different to HSQLDB, have been added by me.

[UncleRobin]

Thanks @RobertG - with that appendix, I’m sure I can use the HSQLDB as reference and lookout for the differences. Much appreciated!