Export Base Schema

Discuss the database features

Export Base Schema

Postby jeanmi2403 » Mon Nov 30, 2020 1:07 am

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
LibreOffice 6.4.7 and OpenOffice 4.1.8 / Windows 10/Ubuntu /Opensuse
User avatar
jeanmi2403
 
Posts: 18
Joined: Tue Jan 29, 2008 12:37 pm
Location: Sucy en Brie (France)

Re: Export Base Schema

Postby Ratslinger » Tue Dec 01, 2020 4:47 am

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
Ratslinger
 
Posts: 27
Joined: Sun Mar 01, 2015 3:34 am

Re: Export Base Schema

Postby jeanmi2403 » Tue Dec 01, 2020 12:44 pm

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
LibreOffice 6.4.7 and OpenOffice 4.1.8 / Windows 10/Ubuntu /Opensuse
User avatar
jeanmi2403
 
Posts: 18
Joined: Tue Jan 29, 2008 12:37 pm
Location: Sucy en Brie (France)


Return to Base

Who is online

Users browsing this forum: No registered users and 6 guests