Oracle Database Project Version 2 is a Visual Studio project type that enables you to manage a set of automatically generated standardized SQL scripts representing one or more Oracle Database schemas, one SQL script per schema object. It also allows you to use the Schema Compare tool to perform schema comparison, updates, and deployment script generation between the database project and other database instances. The Oracle Database Project Version 2 can be added to source control once you have installed a Visual Studio source control plug-in.

After adding a Oracle Database Project Version 2 to your solution, you can select the Import Schema menu item on the Project Folder. After providing a Server Explorer Oracle Database Connection as a source, a set of SQL scripts - one for each schema object - will be automatically generated into the project. Imported SQL scripts always include the schema name for each object. 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.

You may then edit the SQL scripts manually in the Oracle SQL Script editor or you may also add your own SQL scripts for new schema objects as long as they conform to the standard of only one CREATE statement per SQL script (any additional SQL statements beyond the single CREATE statement are ignored).

You can execute individual scripts from the Oracle Database Project Version 2 project or from the Oracle SQL Script Editor. SQL*Plus syntax is fully supported.

You can use the Schema Compare tool to visually compare the Oracle Database Project Version 2 project to Server Explorer Oracle Database Connections or to other Oracle Database Project Version 2 projects. You can also generate a deployment script, a diff script, that can be used to upgrade the target database schema to match the source schema (for Oracle Database connection targets only). You can also tell Schema Compare to update the target directly without generating a script (For either Oracle Database connection or Oracle Database Project Version 2 target types).

Note: The Generate Create Script to Project menu item on Server Explorer nodes is not supported with this project type. Use the Import Schema menu item on the Project folder. Or you can use the Generate Create Script menu item on Server Explorer nodes to generate a SQL statement into a file, and then manually add the file into the Oracle Database Project Version 2. A third option is to use the Schema Compare tool to update the project.