129 results found
-
Edit a project
Please add a way of editing an existing project
116 votesIn Source Control for Oracle v5.7, you can update your database credentials – https://documentation.red-gate.com/soco/release-notes-and-other-versions/source-control-for-oracle-5-7-release-notes.
In 2019, we released Redgate Change Control, which is our migrations-based solution for versioning database changes. We are working towards merging these 2 tools into 1 tool for all your database versioning needs. At this time, we’ll hope to have a better way to edit other project information.
Please let me know if you have any questions. Thank you!
-
78 votes
The Linux cmdlines for Schema Compare for Oracle, Data Compare for Oracle, and Code Analysis for Oracle are now available on Linux. These can be downloaded from https://documentation.red-gate.com/dso.
We are also working on merging our Source Control for Oracle tool (our state-based database versioing tool) with Redgate Change Control (our mibrations-based database versioinng tool) to handle all your database versioning needs. This will be available on Linux. More information about Redgate Change Control is available at https://documentation.red-gate.com/dso/redgate-change-control/getting-started-with-redgate-change-control.
Please let me know if you have any questions. Thank you!
-
Provide a merge option for conflicts
Instead of take database version, or take source control version, we sometimes wish to merge the two changes.
(If you vote on this idea please also mention any tools you use for merging files in source control)
54 votes -
Make Working With Many Schemas Easier in the Project Creation Wizard
We have dozens of schemas in our shared test database, and they're all part of the same project, so they would be versioned together.
The current flow of the project creation wizard makes adding all these schemas one at a time to the new project a real pain.
So, at the moment, when creating the project, we have to choose a single schema from Step 3 (Choose a Schema), then type in the name of the schema to serve as the folder name in Step 4 (Choose a Folder), then click "Add another schema..." and do the same thing again…
53 votesIn Redgate Change Control, our migrations-based versioning tool, users can specify multiple schemas in a comma separate list. We’re working to merge these tools together and have 1 tool for versioning database changes. When we do this, we’re hoping to make working with multiple schemas easier.
Please let me know if you have any questions about this.
-
50 votes
We are working to make Redgate Change Control and Redgate Change Automation available on Mac OS. These are our new migrations-based solutions. Redgate Change Automation is available as a docker container. You can learn more about this at https://documentation.red-gate.com/dso.
-
Share project with others
It would be convenient to be able to share source control projects with other users. Without this you either have to only have one person managing the sync between the database and source control system or each person has to create a project on their machine with the same settings.
47 votesIn 2019, we launched Redgate Change Control, our migrations-based versioning tool, which has a way to Open a project that you get from version control. We’re working to merge these tools together and have 1 tool for versioning database changes. When we do this, we’re hoping to make sharing projects with others easier.
Please let me know if you have any questions about this. Thank you!
-
Support jobs
The tool does not support object type : JOBS .
The job belongs to the selected schema and the " schema compare / Source Control " ignores this type of object.45 votes -
Maven plugin
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.
36 votes -
Add database objects to source control
Please allow us to add database level objects to source control (schemas/roles/profiles/quotas/objects)
30 votes -
Allow schema comparison from a specific revision of the repository
When your source or destination is an SVN repository allow to select a specific revision of the repository.
It is true that there are workarounds for this but it would save time to do it automatically in the tool because now either you have to checkout or update to an specific revision from the svn or you have to create tags in your repository for each version.
29 votes -
Source Control for Oracle: Option to Resolve All Conflicts
Currently we have to select if each conflict should be resolved using the database or source control version individually. In our environment we always apply changes to the database so it is always the master. Would be very useful for us to be able to say resolve all conflicts using the database copy.
24 votes -
Connection global for all Tools
Why i must create the same connection in each tool again? Please save connection strings global for all your tools and let me select the connection i need from a list within each of your tools.
24 votes -
Add support for Git Push and Pull requests
Add the ability to perform push and pull requests through the Source Control for Oracle GUI
23 votesIn our new migrations-based solution, Redgate Change Control, we treat Git as a Distributed Version Control system with Push and Pull capabilities.
We are working towards merging these tools into 1 tool to meet all your database versioning needs. At that point, we should be able to provide push and pull for Git for state-based projects.
For more information about version control in Redgate Change Control, see https://documentation.red-gate.com/dso/redgate-change-control/version-control.
Please let me know if you have any questions. Thank you!
-
Option to automate check-ins
We would like to have an option to enable automated check-ins. Basically, this should poll the database after every "x" minutes and see if there are any pending changes and use a automated comment like -
"Changed these objects on [date/time] by [xyz] -
table1,
view1,
package1,
package2
function1"(Please add any more relevant data you feel would be necessary)
Ideally, we would want to check in every script as soon as it is deployed in the database. But since, for doing that you would need an extension in our IDE, automated polling would be sufficient as well. The aim…
21 votes
Richard Mitchell
responded
I’m not sure how generally useful this feature would be. I’m trying to understand your use case to see what problem you’re trying to solve.
Could you give me more details?
-
Show change date/time.
If changes can occur in both the source and on the database directly, it would be helpful to know which was updated last and when.
16 votes -
Filter objects by user custom text filter
I have multiple different objects between schema and i nedd to compare only onjects (filter objects) that corespond to a more complex criteria (not just by name). I would filter for example by creation date (in a certain interval), object type, eventually the name, and other custom criteria.
It would be very nice that in the project properties (or near the filter by name) user could have an edit box to edit the custom criteria.
For example, criteria could look like:
(objectname like 'TR%' or objectname like '%BN') and objecttype in ('VIEW', 'TABLE') and createddate>sysdate-3)The…
15 votes -
Exclude schema name in deployment script for Data Compare 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.
14 votes -
Source control for oracle polling interval should be configurable in UI while creating project
Source control for oracle polling interval should be configurable in UI like minutely/hourly/daily/weekly. This will help us reduce the burden in environments like test/uat/prod, where we don't this to become a performance issue.
14 votes -
snapshot
Create snapshot options should be similar to those in the SQL Server tool. We are currently limited to snapshot only from TNS and manual connection. We should have the options to create a snapshot from script file or source control. This is vital to our build automation
13 votesRichard Mitchell
responded
You can do this once you have performed a comparison the UI. I presume you mean using the “Create snapshot” in the start menu.
-
Add Versioning Support for Database Links
It would be nice if SC for Oracle could have support for versioning both public and private database links.
For private db links, because only the schema owner can create them, you might need to version them, but not expect to be able to create/replace them via the SC for Oracle interface, because the person logged into version control may not be the owner of the schema (and thus, couldn't create them). If nothing else, you could at least let us know when they differ from what's in source control, and we can manually (outside of SC for Oracle) adjust…
13 votes
- Don't see your idea?