Export Base Schema

Discuss the database features
Post Reply
User avatar
jeanmi2403
Posts: 29
Joined: Tue Jan 29, 2008 12:37 pm
Location: Sucy en Brie (France)

Export Base Schema

Post by jeanmi2403 »

Hello,
I can export the structure of an HSQLDB database with the SCRIPT 'File.sql' instruction.
Is there a way to do the same with a Firebird database?
Regards,
Jean-Michel
LibO 7.4.7 and AOO 4.1.14 on Windows 10 x64, Windows 11 & Ubuntu 22.04
LibO 7.5 on OpenSuse & Linux MX
Ratslinger
Posts: 34
Joined: Sun Mar 01, 2015 3:34 am

Re: Export Base Schema

Post by Ratslinger »

It appears you are talking of the Firebird embedded database. There is no direct command as you have for HSQLDB embedded. This post may be of help:

https://ask.libreoffice.org/en/question ... -id-236862
LibreOffice 7.0.2.2
OpenOffice 4.0.1
Ubuntu Mate 20.04.1
Mint 20.3
User avatar
jeanmi2403
Posts: 29
Joined: Tue Jan 29, 2008 12:37 pm
Location: Sucy en Brie (France)

Re: Export Base Schema

Post by jeanmi2403 »

Hello
I'm trying to do the same thing as the SCRIPT (HSQLDB) instruction, to transfer sample databases (integrated or external) that I use for the training I provide. But it seems that there is no possibility.
I followed your link, and installed FlameRobin, which allows some of the work to be done on an external database, but only allows working on one table at a time, and does not allow data to be extracted in the form of an SQL query (INSTERT INTO ....).
I think I will do it with a macro .... It will be a good exercise !
Thanks, Regards,
Jean-Michel
LibO 7.4.7 and AOO 4.1.14 on Windows 10 x64, Windows 11 & Ubuntu 22.04
LibO 7.5 on OpenSuse & Linux MX
Post Reply