Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

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

edited November 4 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?

Tagged:

Answers

Leave a Comment

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.