59 results found
-
eduardo.torres@deinos.com.ar
descargo el data compare for oracle en version trial...
no me funciona porque algun motivo, entiendo que puede ser que necesite la version de 64 bits, pero no la encuentro por ningun lado...entonces les escribo y no me deja enviarle la solicitud porque me dice que tengo que poner una licencia...
es trial amigo...como hago....les agradeceré si se pueden poner en contacto conmigo...
gracias.1 voteWhen you install Data Compare for Oracle, it should install both the 32 and 64 bit versions. You should see them in the Start Menu. If you are still having issues, please contact our support team.
-
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
-
Source Control for Oracle should allow projects to not auto refresh.
For example, if I have several projects with multiple schemas in several databases, the Source Control for Oracle Tool may take several minutes to refresh the projects when the program opens. If I am only working on one database, I should be able to set the other projects to not auto refresh.
4 votesIn Source Control for Oracle, right click on the project and uncheck the ‘Refresh Automatically’ option.
-
Separate the Include Storage Option - “tablespaces and partitioning” into two options
With the release of Schema Compare for Oracle V3.1.3, the one Ignore Storage Option was split into 7 separate options (plus the Include All Storage Options). One of the 7 separate options is the “tablespaces and partitioning”.
Please consider splitting the option into two separate options one for "tablespaces' and the other for 'partitioning'.
9 votesThis was released in v 5.7.12.
-
Add the ability to use a simple wild character when configuring a filter in Source Control for Oracle
The filtering limitation to just “contains” is really frustrating and very time consuming.
· How hard can it be to use one simple wild card (“” or “%”) to define patterns? That way I can specify a specific object name, i.e. “s” or all objects starting with, i.e. “s”, or any object containing, i.e. “s”, or any object ending with, i.e. “*s”. This would add so much for so little. This seems to be an enormous oversight and by far my single biggest frustration with the tool.
· Not as important but useful would be being…
18 votesTry using the new ignore rules feature and regular expressions to limit your comparisons – https://documentation.red-gate.com/dco5/setting-up-the-comparison/using-ignore-rules.
Please let me know if you have any questions. Thank you!
-
Local git repository - a documented example
Could you post somewhere an example of Source Control with a local git repo? I have done "git init --bare" but sitll get this:
Git directory must be an existing bare repository, for example 'git init --bare'1 voteWe did have an issue that we fixed in the latest release to do with using a file uri rather than a path. But I don’t think this is your issue.
So eg
C:\>cd temporaC:\tempora>mkdir test
C:\tempora>cd test
C:\tempora\test>git init —bare
Initialized empty Git repository in C:/tempora/test/Then link to “c:\tempora\test” in the first box and leave the second box empty or not and it works (for me anyway).
-
Why/where I can't use "Schema Compare for Oracle" tool Option (Behavior, Ignore) and Filter Setup in Source Control for Oracle?
Why/where I can't use "Schema Compare for Oracle" tool Option (Behavior, Ignore) and Filter Setup in Source Control for Oracle? Two tools behave like same and give same structure
1 voteThis is actually available via the right-click menu on the project list screen in Source Control for Oracle.
We’re aware this is a bit hidden and we’re working to improve it’s discoverability currently.
http://documentation.red-gate.com/display/SOCO3/Filtering+objects
-
When will Schema Compare support Oracle 12c?
Things like lack of support of JSON objects, default on null on columns statements, and table compression statements cause us to use script rather than moving through the tool. The tool works great for things that have full support and would love to be running everything through it.
46 votesRedgate tools for Oracle are now compatible with Oracle version 12c. Full 12c support for Schema Compare was released earlier this year.
-
Connection dialog data entry fields too short in some cases - particularly for database+instance
It is not possible to see the entire database name in Schema Compare (and I think elsewhere)... The text fiield is too short. Have a screenshot if desired.
1 voteThis has been released with the latest update 2.0.7.1937
-
The DATABASE listing on Source Control for Oracle just shows the host name and no instance
REviewing the list of Source Control projects, the database name is just the IP address/host name. It should include the SID and/or SERVICE to be useful.
1 voteGood point. As I’ve got two lines for information I’ve added that to the next release.
I’ll also include the port number if it’s not 1521.
To see full information if it’s truncated simply hover.
-
Need the filter capability that SQL Compare currently has
SQL Compare allows the user to use a customized filter to exclude specific objects, object types, or objects with a certain named pattern.
This would be extremely useful in the Oracle tool as well.
39 votesIgnore Rules were implemented in v5.2 for Schema Compare, Data Compare, and Source Control for Oracle. More details can be found at https://documentation.red-gate.com/ddfo/other-resources/list-of-released-features. We hope this meets your needs and looking forward to hearing your feedback.
Thank you!
Stephanie Herr
Product Manager, Database DevOps -
NEXT /*1:Days*/ sysdate + 1 in Materlized View in Database not in Source Control SVC
Bug, /1:Days/ in Database Version, not in SVC therfore always x number of mv objects to check in and when try to check in will not update matrialized views
1 voteJust tested this in our latest release and it seems fine. The comment is stripped when inserting into the database by Oracle.
When reporting a bug it’s best to use http://www.red-gate.com/documentation/
-
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.
-
Support for Queue Tables
Please add support or the ability to find Queue tables.
12 votesThis was released in V5.7.11
-
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.
-
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 -
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”
- Don't see your idea?