Deploying a design

After running Database Designer to generate a deployment script, Vertica recommends that you test your design on a non-production server before you deploy it to your production server.

Both the design and deployment processes run in the background. This is useful if you have a large design that you want to run overnight. Because an active SSH session is not required, the design/deploy operations continue to run uninterrupted, even if the session is terminated.

Database Designer runs as a background process. Multiple users can run Database Designer concurrently without interfering with each other or using up all the cluster resources. However, if multiple users are deploying a design on the same tables at the same time, Database Designer may not be able to complete the deployment. To avoid problems, consider the following:

• Schedule potentially conflicting Database Designer processes to run sequentially overnight so that there are no concurrency problems.

• Avoid scheduling Database Designer runs on the same set of tables at the same time.

There are two ways to deploy your design:

• Deploying Designs Using Database Designer

• Deploying Designs Manually