129 results found
-
Selecting TABLES list from Excel / Text file ?
If the source schema has around 1000 tables and we want to compare only 500 tables. Its a very tedious job to select all the 500 tables manually in the TABLES options tab. If we have all the 500 tables list stored in an excel sheet,csv,txt format. It would be good if data compare tool GUI (or) command line utility has a way to read all the user defined tables list from the excel/txt/csv sheet.
13 votes -
Integrate the Oracle Tools with Oracle SQL Developer
Looking for feedback from our Oracle Users if they would like integration with Oracle SQL Developer.
Launch the tools from within the IDE.
Or Perform Source Control for Oracle Check-in or Get Latest process from within the IDE.Please comment or vote on this topic.
12 votesAs well as your votes, please also add a comment to the issue describing your need in more detail so we understand what the integration should entail.
-
Formatting...
Without wishing to start a religious war, am I really alone in disliking all-caps formatting for keywords? I don't want to be shouted at when looking at scripts ... and in our modern era of editors with colour coding it's unnecessary.
And the use of quotes for column names when it's not necessary?
And the inclusion of "NULL" for table columns when it could be left out?
And, for readability, I normally format table creation scripts (and others) so the column names line up, the column types line up, the "not null" clauses (if present) line up, etc.
And any…
12 votes -
Sorting Database Objects in Sync script
When we create a syncronization script we have diffrent order of objects from time to time. It is not very good for us, because it is hard to find out changes.
Could you please make that the order does not change (for example in alphabetical order).12 votes -
Use Insert, Update, Delete commands instead of execute immediate
I would prefer if the generated script would use insert/update/delete commands for each records instead of execute immediate.
12 votes -
When installing Source Control for Oracle, be able to set / configure where the WorkingBases and Transients folders are created.
By default, Source Control for Oracle creates the WorkingBases and Transients (along with other associated files and folders) in the users Windows profile (C:\Users<user name>\AppData\Local\Red Gate\Source Control for Oracle).
In some environments the C: drive is configured to be minimal size (just OS and some required applications).
Being able to configure the paths where the WorkingBases and Transients (along with other associated files and folders) would to free up disk space in environments where the C:\ is configured to minimal disk space.
11 votes -
Right-click on column to exclude it from comparison
I can exclude columns in the project settings Tables & Views tab, but it would be very handy if I could right-click on a column in the detail comparison window and exclude it right there. This would save me having to go back to the project settings, waiting for the refresh, finding the table I want to modify, and deselecting the columns in the drop-down. Most of the time I start by comparing all columns and then I want to whittle it down from looking at the results in the detail window.
10 votes -
Please add ssuport for oracle CONTEXT object
The Oracle CONTEXT object is not seen by Source Control.
9 votes -
New option is needed to compare mviews as just tables (ignore mview definition)
Due to DML-only replication requirements target schema might contain only tables for related mview in source schema. In this case current configuration of SC shows difference: mview exist only on source and tables exist only on target. This is not correct if compare tables only.
9 votes -
Display who made each change in the check-in screen
In a shared development database, all users can see every change, but not who made each one. Please show who made each change, and consider hiding those not made by me (or de-selecting them for check-in by default).
9 votes -
Add Versioning Support for Directory Objects
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.alldirectories and their permissions from alltab_privs, like this:
SELECT alltabprivs.*
FROM alldirectories
JOIN alltabprivs ON (alltabprivs.tableschema = 'SYS' AND alldirectories.directoryname = alltabprivs.table_name);8 votes -
Add database-level objects to schema (database?) compare
I'd like the ability to compare schema, role and other database level objects for deployment. Most notably schemas (users) and roles.
8 votes -
Add support for command line execution under Mono
From research performed by an existing customer, who believes "you just need to have the command line utility create registry entries if they're missing when it starts. You could add a flag instead if you would prefer not to do that automatically.
I need this because I'm trying to automate the build of an application that must be compiled on Linux. At the moment, I have SCO.EXE running as a separate build configuration running on a separate agent on a Windows machine, but that is burning a configuration and a build agent that could be better utilized if each agent…
7 votes -
compare columns with different names
I am comparing two versions of a vendor application db, and sometimes they change columns names (even when not necessary). The tool needs a way to bind these two together.
It could be done with a simple mechanism under the hood, like simply creating a (new) common field alias name between the two queries.
It would be good if it could be implemented to allow general sql field query/conversion logic (where meaningful). For instance, sometimes even when keeping the name identical, other aspects of the field might have been changed which could lead to false positives for changes.
e.g. a…
7 votes -
Support versioning Java within the Oracle database
Please add support for versioning Java source code within the Oracle database, for example Java Stored Procedures
7 votes -
7 votes
-
Create a command line interface for Source Control for Oracle
It would be nice if there were a command line interface for Source Control for Oracle so that I could commit all change to a database to source control.
7 votes -
Undo changes before they are checked in
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
7 votesFor any objects that are CREATE OR REPLACE, highlight the code under “Source Control” in the check-in screen and execute it in your schema to get back to the version in source control.
This will not work for tables and please keep voting/commenting here if you need this.
-
Spilt the 'Ignore Constraint names' option into 5 separate options.
The following suggestion is from a customer I performed a remote desktop session with.
Current in Schema Compare there is a single option to ‘Ignore constraint names’ when comparing objects. The constraints are still deployed. The option covers Primary Key, Foreign Key, Check, Default and Unique constraints.
Could this option be spilt up and replaced by the following 5 options:
• Ignore Foreign Constraints when comparing and deploying.
• Ignore Check Constraints when comparing and deploying.
• Ignore Default Constraints when comparing and deploying.
• Ignore Unique Constraints when comparing and deploying.
• Ignore Primary Key Constraints when comparing and…7 votes -
Add support for Vault to Source Control for Oracle
Please add Vault support
7 votes
Richard Mitchell
responded
You can now use any source control system in the v3 release of the tool by using “Working folder” which saves changes to disk and allows you to use external tools to commit and retrieve your changes.
- Don't see your idea?