This topic explains how to build and deploy a project.
After you have edited your database project, you should build it to create a script that will deploy all the project changes to the database on the server. A project can be built to a single ready-to-deploy script or a set of scripts with a batch to run it in the Oracle Command-Line Tool.
To build a project:
Project building is enhanced with the following features:
Before building the project, you can set project options to customize build results.
Actual document look may slightly vary from the above image, depending on the product you use.
You can deploy either the entire project or only the changes in the project to the database on your server.
Project files can be deployed only if a connection was assigned to the project.
To deploy an entire project, click Deploy the Project on the Build menu.
Use the Always re-create a database option to guarantee database integrity.
When you want to deploy only the changes from your project to the server, you should compare your project with the database on the server and create a special schema synchronization script. The script will deploy only required changes to the server.