Copy entire Vertica database or restore backup into database of different name

edited November 2020 in General Discussion

I'd like to separate a database into two, so that all certain schemas belonging to, say, US entities goes into one database, and all tables, schemas, users for EU entities goes into another independent database.

The simplest approach i think is to backup the first database, restore into a second, then drop US schemas, tables, users from one, and drop EU users, schemas, tables, etc. from the other.

This post suggests that might be possible, "Most of the time it's just easier to create a new database and re-load it." (https://forum.vertica.com/discussion/239473/renaming-a-view#latest)

The one trick is this page says "The database name must match the name in the backup" (https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/AdministratorsGuide/BackupRestore/RestoringFullDatabaseBackups.htm)

Is it possible to restore one database into another?



Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file