The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
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 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." (

The one trick is this page says "The database name must match the name in the backup" (

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