59 results found

1. 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 vote

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  Delete…  ·  Admin →
   completed  ·  AdminStephanie (Product Manager, Redgate) responded

   When 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. 

2. 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 vote

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   1 comment  ·  Source Control  ·  Delete…  ·  Admin →
   completed  ·  AdminDavid Atkinson (Product Manager, Redgate) responded

   This is included in v5

3. 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 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   1 comment  ·  Delete…  ·  Admin →
   completed  ·  AdminStephanie (Product Manager, Redgate) responded

   In Source Control for Oracle, right click on the project and uncheck the ‘Refresh Automatically’ option.

4. 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 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   4 comments  ·  All Oracle  ·  Delete…  ·  Admin →
   completed  ·  AdminStephanie (Product Manager, Redgate) responded

   This was released in v 5.7.12.

5. 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 able to have different filters for different object types.

   · Also if I deselect an object that is a “+Create” change, it would be nice if it gave me the option to add the deselected object to the filters so I don’t have to manually add them.

   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… more

   18 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  All Oracle  ·  Delete…  ·  Admin →
   completed  ·  AdminStephanie (Product Manager, Redgate) responded

   Try 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!

6. 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 vote

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  Source Control  ·  Delete…  ·  Admin →
   completed  ·  Richard Mitchell responded

   We 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 tempora

   C:\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).

7. 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 vote

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  Source Control  ·  Delete…  ·  Admin →
   completed  ·  Richard Mitchell responded

   This 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

8. 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 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   4 comments  ·  Schema Compare  ·  Delete…  ·  Admin →
   completed  ·  Doerte responded

   Redgate tools for Oracle are now compatible with Oracle version 12c. Full 12c support for Schema Compare was released earlier this year.

9. 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 vote

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   5 comments  ·  All Oracle  ·  Delete…  ·  Admin →
   completed  ·  Richard Mitchell responded

   This has been released with the latest update 2.0.7.1937

10. 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 vote

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    3 comments  ·  Source Control  ·  Delete…  ·  Admin →
    completed  ·  Richard Mitchell responded

    Good 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.

11. 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 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    5 comments  ·  Schema Compare  ·  Delete…  ·  Admin →
    completed  ·  AdminStephanie (Product Manager, Redgate) responded

    Ignore 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

12. 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 vote

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Source Control  ·  Delete…  ·  Admin →
    completed  ·  Richard Mitchell responded

    Just 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/

13. 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 vote

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Source Control  ·  Delete…  ·  Admin →
    completed  ·  Richard Mitchell responded

    This is believed to be fixed in the upcoming release, hopefully in the next couple of days once we’ve finished release testing.

14. Support for Queue Tables

    Please add support or the ability to find Queue tables.

    12 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Schema Compare  ·  Delete…  ·  Admin →
    completed  ·  AdminStephanie (Product Manager, Redgate) responded

    This was released in V5.7.11

15. 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 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    4 comments  ·  Delete…  ·  Admin →
    completed  ·  Richard Mitchell responded

    This is now in the latest release available via download or check for updates

16. 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 LOGGING
    STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
    PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
    BUFFERPOOL DEFAULT FLASHCACHE DEFAULT CELLFLASHCACHE DEFAULT)
    TABLESPACE "XXTSTX_DATA" ) RETURN AS VALUE;

    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… more

    4 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    3 comments  ·  Schema Compare  ·  Delete…  ·  Admin →
    completed  ·  Richard Mitchell responded

    I’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.

17. Command line feedback

    Errorlevel is not updated by DCO32.exe if there are différences in data of two schémas.

    3 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    2 comments  ·  Data Compare  ·  Delete…  ·  Admin →
    completed  ·  Richard Mitchell responded

    In 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 :)

18. 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 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Schema Compare  ·  Delete…  ·  Admin →
    completed  ·  Richard Mitchell responded

    This 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.

19. 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 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Schema Compare  ·  Delete…  ·  Admin →
    completed  ·  Anonymous responded

    Hi 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

20. 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 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    1 comment  ·  All Oracle  ·  Delete…  ·  Admin →
    completed  ·  Richard Mitchell responded

    I’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”