Copy entire Vertica database or restore backup into database of different name
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?
Answers
I think schema replication would help your scenario. Please visit the below link for more information
https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/AdministratorsGuide/BackupRestore/ReplicatingtoanAlternateCluster.htm
@Pieter_Sheth-Vo : You are welcome