Rather than try to provide the functionality of a RDBM tool like
omero db script command helps to generate SQL scripts for building
your database. You can then use those scripts from whatever tool is most
comfortable for you:
$ omero db script --password secretpassword
Using OMERO5.4 for version Using 0 for patch Using password from commandline Saving to /home/omero/OMERO5.4__0.sql
If you do not specify the OMERO root password on the command line you will be prompted to enter it.