Deploying Designs Manually

If you choose not to have Database Designer deploy your design at design time, you can deploy the design later using the deployment script:

  1. Make sure that you have a database that contains the same tables and projections as the database on which you ran Database Designer. The database should also contain sample data.
  2. To deploy the projections to a test or production environment, use the following vsql command to execute the deployment script, where design‑name is the name of the database design:

    => \i design-name_deploy.sql