26 results found
-
179 votes
This is now available in the final v3 release of Source Control for Oracle – available now
-
Data should be a part of the version control for metatables
Some tables are metatables involving data/information connected to the software releases. The Source Control utility should have a possibility of setting a switch on the tables, turning data compare on. This way you could include data for these tables in the version control.
131 votesWe just released static data support for Source Control for Oracle.
-
Options for underlying scripts
Allow us to specify options (like in Schema Compare for Oracle) when creating a Source Control for Oracle project (e.g. we'd like to include storage clauses in the table create scripts)
Note from Red Gate: If you vote on this feature request, it would also be helpful to know what options specifically you'd like to see.
47 votesStorage options are now available in the latest release of the tools.
There are a number of new “Include ..” storage options available in both the Schema Compare and Source Control tools.
To get to options in Source Control right click on the project in the start screen and selected “Edit comparison options”.
-
Filter objects added to source control
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)
39 votesThis is now available via check for updates or to be downloaded from our website.
This allows objects to be filtered based on type or substrings (both include and exclude).
-
Option to Check Out/Lock
When working on an object, we would like to see an option to check-out and/or lock the item it is mapped to in source control. Preferably, we would like this to happen when the item is edited and compiled. Again, this could be an XML config file option of some kind, or an option during check-in to lock the file for the user checking it in.
15 votesThis has been released in the latest versions of Source Control for Oracle. The upcoming release removes the clutter of locking partitons and lobs which can only be modified with the connecting table object.
-
Version public synonyms whose referenced objects are in my project
Our application has public synonyms that should be versioned along with our application, but Source Control for Oracle isn’t picking up the public synonyms that point to objects in our versioned schemas.
Would it be possible to look for public synonyms whose referenced object is in the list of schemas that are in the SC project? For example, if my project schemas were ‘MYSCHEMA1’ and ‘MYSCHEMA2’, then SC for Oracle would look to version any public synonyms with a query like this:
SELECT *
FROM allsynonyms
WHERE owner = 'PUBLIC'
AND tableowner IN ('MYSCHEMA1', 'MY…11 votesThis is now available in our latest release.
Enjoy.
-
Put package header and body in seperate files.
When a repository is created from the database, both the package header and the package body are placed in a single file. It would be more usable if the spec and body were in separate files in the same folder with a .pks or .pkb extension respectively.
9 votesthis will be in the next release of Schema Compare and Source Control for Oracle
-
Synonym support
Generate a script that contains all the synonyms that have been created to support the schema being version controlled.
9 votesI believe this is a request for public synonyms which has been implemented in the latest release.
Please let me know if that’s incorrect.
-
Allow us to choose the schema prefix
We noticed that all objects have a prefix in front of it.
The prefix happens to be the same as your folder name. I would prefer it if it was the same as the schema name, or NULL. Preferably give us the right to choose a prefix name.9 votesI believe you can do this in the latest version of Source Control.
Either you can make your schema name the same as the folder when you setup your project.
Or you can now access the options via right-click on the project on the projects page and select “Edit comparison options…” and use the option “Exclude schema names”
-
Implement (manually) sorting of projects in Source Control
Now the projects are listed in the order they were created. I would like to be able to sort them manually in a more logical order.
9 votesIn the upcoming release (this week hopefully) the projects are sorted by name on startup. Not quite the flexibility you were after but I hope this will satisfy you for now.
What sorting at startup means is that renaming a project will not move it in the project order until the tool is restarted.
-
Tool should have search capability to look for a particular Object in that scehma
As we have lot of objects in the schema, if we want to lok for a particular object we dont have search capability in the tool
5 votesThe latest versions of the tools have a filter capability on the check-in page to search particular objects.
(just doing a review of all uservoice requests)
-
Allow source control in sub-folders of repository
Allow for saving of database versioning in a sub-folder of the subversion repository rather than just the root of the repository.
4 votesThis should now be fixed in the beta released yesterday (21 Feb), please do let us know if there are still issues!
-
UI Improvements
Put a border around the application frame so it's eaier to detect on the screen with 20 other windows open...
Much more importantly you need to add a way to cycle through the differences in the source control diff window by allowing to move through the changes instead of having to scroll. The blue is very hard to see in the side bar, too. Allowing simple text search wouldn't hurt either.
3 votesThere is a border around the application. There’s also a “Previous” and “Next” button at the top of the differences pane near the bottom. This will jump you the Previous/Next difference within the script respectively.
-
SID is limited to 8 characters
The SID for my oracle instance is 10 characters. The connection wizard only allows 8 characters so can't use the product.
3 votesshipped via check for updates today
-
Add Versioning Support for Materialized Views and MV Logs
It would be nice if Source Control for Oracle could support versioning materialized views and materialized view logs.
3 votesThis has been complete in v1.0.0.755 of Source Control for Oracle, available via Help→Check for Updates
-
UserObjectPrivileges
It is not generating the UserObjectPrivileges scripts correctly, it is using the folder name of the repository instead of the schema name we are versioning:
Here is an example:
GRANT EXECUTE ON "branches/devl/db/devl".function TO user;
2 votesResolved as part of the beta 3 release
-
Refreshing the schema compare on demand
Source Control for Oracle - Please do not run the refresing automatically when the app is openned. Run on demand when user click Reresh.
1 voteThis is included in v5
-
Add support to ORACLE_LOADER and ORACLE_DATAPUMP access drivers
Add support to ORACLELOADER and ORACLEDATAPUMP access drivers to fix some bugs related to external tables (see http://www.red-gate.com/MessageBoard/viewtopic.php?t=16543)
1 voteexternal tables were included in v1.0.0.707
-
TFS client not found
I'm getting an error that TFS client not found. I don't see any documentation as to what the RedGate software is expecting to see as a "TFS client". Please advise.
1 voteAn alternative to needing Visual Studio installed is to use Team Explorer or Team Explorer Everywhere
-
1 vote
Thanks Leigh, this should now be the case in the latest beta release
- Don't see your idea?