Oracle Database Project Version 2 Project Folder

This section covers the following topics:

How Oracle Database Project Version 2 Project Folder Works

You can view the Oracle Database Project Version 2 in Visual Studio Solution Explorer.

When source control is enabled, project menus contain applicable source control operations.

To perform actions on an Oracle Database Project Version 2 project node, right-click the node and from the menu choose the appropriate command. To view the node's properties, select the node and/or click Properties in the nodes menu.

Menu Options

Menu Option Description

Add New Item

Opens the Add New Item dialog box to add a new script to the project. See Adding New Scripts.

Add Existing Item

Opens the Add Existing Item dialog box to add an existing item to the project. See Adding Existing Scripts.

Add SQL Script

Opens Add New Item dialog, which selects SQL Script project item template by default.

New Folder

Creates a new folder.

Import Schema

Opens the Import Schema Dialog. You can provide a source Server Explorer Oracle Database Connection or create a new one. One SQL script per schema object will be generated into the Oracle Database Project Version 2. Imported SQL scripts will always include a schema name. An Import Schema operation may be repeated to import additional schemas into the project, but only one import per schema is allowed for the lifetime of an Oracle Database Project Version 2 project. Additional scripts may be added to the project via the Schema Compare tool, or using the Add Existing Item menu item. See the Visual Studio output window for error messages and warnings related to the import.

Oracle Schema Compare

Opens the Schema Compare tool.

Paste

Paste scripts or folders which have been cut or copied.

Cut

Copies selected Oracle Database Project Version 2 to the clipboard and prepares the node to be removed after a paste operation.

Remove

Removes the project from the solution.

Rename

Rename the project.

Save ProjectName

Save the project.

Properties

Displays the properties window.

Properties

Property Name Description

Name

The name of the Oracle Database Project Version 2 project Node.

Build Output File Name

When the Build menu item is chosen, the Build deployment script will use this name.

Build Output Path

The path or partial path relative to the project where the Build deployment script will be stored.

Database Project Version

Version of the database project (currently Version 2).

Default Database Reference

The default database reference for the project, or blank if there is none.

File Name

Full path specification of the project file.

Imported Schemas

List of the schema names that have been imported into this project.

Target Platform

The database version (or later) that the scripts in this project are compatible with. This value is set when the schema is imported and may be changed by the user. Errors will result if scripts contain SQL not compatible with this database version.