New Features for Oracle Developer Tools for Visual Studio Release 12.1.0.2.4

Oracle Developer Tools for Visual Studio release 12.1.0.2.4 includes the following:

• Support for Microsoft Visual Studio 2015

  Oracle Developer Tools for Visual Studio now supports Visual Studio 2015.

• Oracle Database Project Version 2 project type (BETA)

  The Oracle Database Project Version 2 project type is introduced in this release. It allows you to import your database schema into this project as a set of standardized SQL scripts which can be checked into source control.

  Note: The Generate Create Script to Project Server Explorer menu item is not supported with the Oracle Database Project Version 2 project type. Instead, use Import Schema or Add Existing Item menu items on an Oracle Database Project Version 2 project folder, or use the Schema Compare tool. Functionality involving this beta feature may change in a future release.

• Schema Compare supports comparisons against Oracle Database Project Version 2 project type (BETA)

  The Schema Compare tool has also been enhanced to allow schema comparisons, diff script generation, and updating between Oracle Database Project Version 2 projects and live database instances or between two different Oracle Database Project Version 2 projects. Functionality involving this beta feature may change in a future release.

• Schema Compare toolbar changes

  New Update Target toolbar button and Generate Script toolbar button have been added to Schema Compare.

  Note: The Add to Database Project and Export to Editor toolbar items have been removed.

• Schema Compare support for partial script generation or partial target update

  An Action checkbox in the Schema Compare output window allows you to generate diff scripts or update targets for certain schema objects or schema object types, for example all tables and views only, or the EMPLOYEES table only.

• New Schema Compare options

  A Drop objects not in source option has been added to the Schema Compare Source and Target Dialog Advanced Options.

• Schema Compare supports additional schema object types

  Schema Compare now supports materialized views, XMLType tables/views and Index Organized Tables.

• Generate Create Script supports additional schema object types

  Server Explorer menu items Generate Create Script and Generate Create Script to Project now supports materialized views, XMLType tables/views and Index Organized Tables.

• Server Explorer changes for Tables, Views, Indexes and Triggers nodes

  Triggers Node and Indexes Node are now top level nodes and contain all triggers and indexes present in the database schema. The Triggers node contains category nodes of several types including Table Triggers Node, View Triggers Node, Schema Triggers Node, and Database Triggers Node.

  The Tables Node now contains category nodes Relational Tables Node, Object Tables Node, and XML Tables Node. Similarly the Views Node has been modified to contain category nodes Relational Views Node, Object Views Node, XML Views Node, and Materialized Views Node.