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.
Note
Your computer might show different names or locations for some of the Visual Studio user interface elements in the following instructions. These elements are determined by your Visual Studio edition and settings. For more information, see Visual Studio Settings.
Project building is enhanced with the following features:
Before building the project, you can set project options to customize build results.
Right-click the Solution Explorer pane and select the Properties option, or on the Project menu, click Properties. The Project Properties window opens. It contains three tabs: Build, Build Order, and Database.
Use the Build tab to define the settings for the generated SQL file with project changes. For example, you can select whether to generate a single SQL script file or a batch script file, etc.
The Build Order tab lets you manage the order of files in the build script and deploy execution. You can manage dependencies between objects in different files using build order.
To deploy a project, choose project configuration, and click Deploy the Project from the project shortcut menu.
Note
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 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.