Please add support for Microsoft Visual SourceSafe

Specifically, please allow exclusion of packages, as our DBAs have restricted access to the all_source table.

(If you vote on this idea please mention any specific or general rules you'd like to pre-filter by)

when migrating indexes in schema compare,bitmap indexes on a partitioned table fail - local clause missing

I would prefer if the generated script would use insert/update/delete commands for each records instead of execute immediate.

When I do a schema compare that has added a virtual column the alter table command that it generates has a bug in it.
The statement it generates is:
ALTER TABLE vendor_portal_user.vendor_contacts ADD (dbupper_username VARCHAR2(30 BYTE) GENERATED ALWAYS AS (UPPER("DBUSER_NAME")));

Which results in error:
ORA-54015: Duplicate column expression was specified

The correct syntax is:
alter table VENDOR_PORTAL_USER.VENDOR_CONTACTS add dbupper_username as (UPPER(DBUSER_NAME));

Please add a way of editing an existing project

Once created, there is no easy way to see which parameters were used (and none for things like username, and what the user connected as)

Please add support for IBM Rational ClearCase to Source Control for Oracle

When generating a deployment script in Schema Compare for Oracle you have the option to 'Exclude schema names in the deployment script'. Please could we have the same functionality in Data Compare for Oracle. This would be very useful when applying the script to different schemas.

Please add support for Serena PVCS Version Manager (PVCS VM)
http://www.serena.com/index.php/en/products/pvcs-vm/

It would be nice if SC for Oracle could add versioning support for directory objects and their privileges.

These are the directory objects that are created like this:

CREATE OR REPLACE DIRECTORY temp AS 'c:\temp';

and the list of directory objects comes from sys.all_directories and their permissions from all_tab_privs, like this:

SELECT all_tab_privs.*
FROM all_directories
JOIN all_tab_privs ON (all_tab_privs.table_schema = 'SYS' AND all_directories.directory_name = all_tab_privs.table_name);

If a column is renamed, Schema Compare for Oracle sees this as a drop and create, so during the table rebuild data is preserved asides from the “new” column.

Could you make this work similarly to SQL Compare and execute a rename instead?

It would be nice if Source Control for Oracle could support versioning materialized views and materialized view logs.

Please add the ability to revert my schema(s) to a previous from the history tab.

I understand this is currently possible by checking the version out to a folder, and using Schema Compare to deploy changes, but it would be much more convenient (and cheaper!) from within Source Control.

Please add the ability to undo changes to an object in the check in screen. They should be undone to the latest version in source control.

Much like this feature in SQL Source Control: http://www.red-gate.com/supportcenter/content/SQL_Source_Control/help/3.1/SSC_Undo

Please add support for versioning Java source code within the Oracle database, for example Java Stored Procedures

In our schema(s) there is a mixture of third party code that we don't touch, and our own code where we'll amend and add objects. Please add a way to filter out the third party objects.

(If you vote on this, please let us know if the objects concerned are named in a particular way that would make filtering easier)

With a maven plugin developers could easily automate deploys. The plugin should be configureable, but include the possibilites of first pulling from a developer database into svn. Then pushing the changes from svn (including other changes registered in SVN) towards a deploy test database.