59 results found
-
Source Control for Oracle v2.0.1.173 does not support default value oin INTERVAL column type
Source Control for Oracle v2.0.1.173 does not support default value on INTERVAL column type
This table column definition throws an error when Source Control for Oracle looks for changes..
...
"SUSPEND_DAYS" INTERVAL DAY (3) TO SECOND (3) DEFAULT INTERVAL '5' DAY NOT NULL ENABLE,
...); ---> RedGate.Shared.Utils.InvalidStateException: Parsing failed with message SyntaxError. Unexpected token ''5'' (Line 29, Col 62) symbol Id.
1 voteThis is believed to be fixed in the upcoming release, hopefully in the next couple of days once we’ve finished release testing.
-
Configure timeout settings on command line interface.
Currently there is a 60 second timeout on all script executions for SCO deployment. I have run into situations where indexes on large data sets or table rebuilds on large tables exceeds that time frame resulting in SCO prematurely exiting the script deployment. The recommendation was to invest in better hardware. Unfortunately, better hardware cannot solve this problem where large data sets are in play. Having the ability to adjust the timeout default could help avoid such situations.
See for reference issue: http://redgatesupport.red-gate.com/requests/16832
3 votesThis is now in the latest release available via download or check for updates
-
Support Table Type Columns
It appears that Schema Compare does not support table types as columns. I have a table that had a type type added to it on dev. I compared it with QA and it correctly detected the difference, however, the migration script did not include the storage clause necessary for deployment. The statement it created is this:
ALTER TABLE xxproduct.auditlog ADD (auditvalue xxproduct.auditvaluetab);
It should have created something along these lines:
ALTER TABLE xxproduct.auditlog ADD (auditvalue xxproduct.auditvaluetab)
NESTED TABLE "AUDITVALUE" STORE AS "AUDITVALUES"
(PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255…4 votesI’ve been working on this lately as although it could create a new table the migration scripts were very broken.
Let me know if you want a pre-release version to try the fix out.
This will included in the next release of the tools.
-
Command line feedback
Errorlevel is not updated by DCO32.exe if there are différences in data of two schémas.
3 votesIn the next release SDC should return 61 if there were differences or 62 if there were differences and the synchornization failed.
This hasn’t been thoroughly tested to any issues please let support@red-gate.com know.
By the way I can see you commenting on your own idea :)
-
Objects included in the results - CommandLine
Filter for object types in command line application (SCO.exe).
There are several cases when to apply only changes for specific object types (i.e. package, procedure, function) instead of all differencies. Such as in GUI.
7 votesThis can now be done via a filter file in the latest command line release. Although I appreciate that a separate filter file isn’t ideal.
These filter files are generated by Source Control for Oracle as object filters although they are a simple xml format if you want to generate them yourself.
-
Support an LDAP connection, so the server name is not required
Support an LDAP connection, so the server name is not required. We would like to use a server alias only, so that all developers don't have to know or update the server name locally.
10 votesI’ve got a working prototype that allow connections via LDAP. You will need to have the oracle client installed and in the TNS Connection – Network Alias field enter the ldap server alias.
I have now extended this to allow “OS Authentication” which seems to work on my very simple AD implementation.
This is now in our latest release via “Check for Updates”
-
The tool ignored the DDL differences between a partitioned table and a regular one! how is it possible? it is basic !
differences between a partitioned table and a regular one! how is it possible? it is basic !
3 votesHi Oshrat,
By default Schema Compare has an option on to “ignore storage” as many customers are comparing environments that have different storage options. You can however turn this off in the options tab before comparing.
Do let us know if it’s that option that is in fact not working properly for you, but otherwise I’ll mark this as completed in a few days.
Cheers,
Michael -
Option to Ignore External Table Location
When comparing an External Table from one environment to the next, a difference in LOCATION (or filename) that the table refers to triggers a difference. We use External Tables to read data into our warehouse and currently have to manually ignore or remove those location changes from scripts when the difference is discovered. Adding an option to "Ignore External Table Location" would be very convenient for us.
14 votesThis is now in code (yet to be tested) for the next release of the tool.
This is now in our latest release via “Check for Updates”
-
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.
-
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”.
-
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.
-
Create or replace
For procedures/packages etc. it would be great to be able to have a "script as CREATE OR REPLACE" option.
We would use this to generate scripts that could be kept under source control in Mercurial, and applied to the (shared) dev database as needed.
We could also then use the tool to compare whether the database is up to date with the latest changes in source control.
39 votesI’ve just put this into our latest code so that we always generate CREATE OR REPLACE where we can. Surprisingly all the integration tests passed so this should make it into the next release.
I don’t think there are any huge issues with always using the CREATE OR REPLACE syntax.
This is now in our latest release via “Check for Updates”
-
Package generation
A forward slash should be in the scripts so they are runnable via commandline without an extra step.
1 voteThis is complete in Schema Compare and Source Control for Oracle. Help→Check for Updates
-
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).
-
Rename column - instead of drop and create
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?
8 votesI’ve done the work for column rename detection. This will be a default option in the next release of Schema Compare and Source Control for Oracle.
It probably won’t be perfect but the option can be turned off if it causes problems.
-
179 votes
This is now available in the final v3 release of Source Control for Oracle – available now
-
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.
-
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.
-
Specify tables to compare up front
We frequently bring data from production databases to staging and development environments, it involves around 120 tables , but to start with we want to pick 3 or 4 huge tables(rows ~ 3 million) and see how much time it will take to do data comparison and deploy differences, instead of copying down entire tables.Also please see if you can develop the functionality of selecting a list of tables for comparison before registering entire databases.
21 votesYou can now use Ignore Rules to specify what tables to include/exclude in your comparison – https://documentation.red-gate.com/dco5/setting-up-the-comparison/using-ignore-rules.
You also have the ability to specify what tables and WHERE clauses, if needed:
- https://documentation.red-gate.com/dco5/setting-up-the-comparison/selecting-tables-to-compare
and
- https://documentation.red-gate.com/dco5/setting-up-the-comparison/filtering-the-comparison-with-a-where-clausePlease let me know if you have any questions. Thank you!
-
Bug in compare with virtual column
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 vendorportaluser.vendorcontacts ADD (dbupperusername VARCHAR2(30 BYTE) GENERATED ALWAYS AS (UPPER("DBUSER_NAME")));Which results in error:
ORA-54015: Duplicate column expression was specifiedThe correct syntax is:
alter table VENDORPORTALUSER.VENDORCONTACTS add dbupperusername as (UPPER(DBUSER_NAME));1 vote
- Don't see your idea?