DBeaver is a great tool, but if you "copy" and "paste" a schema it does not include the tables.
If you backup the whole database using the backup tool, restore will overwrite the DB, you cant specify a new database or schema name, which is a significant limitation. Also backup creates a .sql script, but restore expects a .backup script which is odd.
We cant use database CLI tools as we don't have direct access to the DB (it's RDS).
There is an "export data" option at the table level, but we want to copy the entire schema, not just tables (so include all functions, sequences, views, sequences etc, etc.)
Asked by John Little
(223 rep)
Jul 16, 2024, 09:43 AM
Last activity: Sep 16, 2024, 02:05 PM
Last activity: Sep 16, 2024, 02:05 PM