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. |