127 results found

1. Synonym Ignore bug

   When entering ignore mask into PublicSynonym section, the ignore does not work - all public synonyms are still compared. But if the same ignore mask is entered into Synonym section, public synonyms are affected.

   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  ·  Schema Compare  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

2. wildcard

   Please add advanced filtering in Schema Compare. E.g. wildcard or regex matches to only show objects matching a certain criteria.

   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  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

3. Exclude system-generated interval partitions from comparison and DDL

   For background on Oracle's interval partitioning feature, see chapter 4 of Oracle Database Concept for release 12.2.

   Our practice is to create interval-partitioned tables with the minimum number of partitions necessary to create the table (usually just one partition), and let Oracle create all others as data arrives requiring them. Between test, QA, and production databases, data arrives at different times, giving rise to automatic creation of different partitions. But because these differences are only a side-effect of different contents, they are not relevant, in the same way that differences in system-generated constraint names are not relevant. Changing the partition key or the interval size would require a rebuild.

   Any time there is a CREATE TABLE command for an interval-partitioned table, the command should be limited to only those partitions that are needed to establish the table. In other words, exclude those partitions where DBATABPARTITIONS.INTERVAL='YES', because they are system-generated. The CREATE TABLE command should explicitly list only those partitions where INTERVAL='NO';

   An an example, I have an interval-partitioned table named FMEMBERTENUREMMSNAPSHOT. These are the partitions in my test database:
   C911233@TCRDS_SACRDSD2R.ssdc.kp.org> l
   1 select partitionname, partitionposition, highvalue, interval
   2 from dbatabpartitions
   3 where tablename='FMEMBERTENUREMMSNAPSHOT'
   4 and tableowner='COBIDM'
   5* order by partitionposition
   C911233@TCRDSSACRDSD2R.ssdc.kp.org> /

   PARTITIONNAME PARTITIONPOSITION HIGH_VALUE INTERVAL

   ---

   PARTEMPTY 1 190001 NO
   SYSP937 2 201310 YES
   SYSP968 3 201311 YES
   SYSP966 4 201312 YES
   SYSP973 5 201313 YES
   SYSP933 6 201402 YES
   SYSP970 7 201403 YES
   SYSP967 8 201404 YES
   SYSP931 9 201405 YES
   SYSP932 10 201406 YES
   SYSP935 11 201407 YES
   SYSP977 12 201408 YES
   <skipping many lines for brevity>
   SYSP3318 63 201811 YES
   SYSP3554 64 201812 YES

   If there is a need to generate a CREATE TABLE command, all I really need is shown below, because it is sufficient to establish the table as indicated by INTERVAL='NO' in the query above:

   CREATE TABLE cobidm.rgtemp11090455980 (
   fmbrtenuremmsnpshtik NUMBER NOT NULL,
   dmbrprmyhrnik NUMBER NOT NULL,
   <many columns omitted>
   crdsprcscntlupdid NUMBER NOT NULL,
   CONSTRAINT RGTEMP11090455981 PRIMARY KEY (fmbrtenuremmsnpshtik) USING INDEX (CREATE UNIQUE INDEX cobidm.rgtemp11090455982 ON cobidm.rgtemp11090455980(fmbrtenuremmsnpshtik)
   NOCOMPRESS
   TABLESPACE cobimediumindex),
   CONSTRAINT RGTEMP11090455983 UNIQUE (srcmbrprmyhrnid,srcsnpshtmmnb) USING INDEX (CREATE UNIQUE INDEX cobidm.rgtemp11090455984 ON cobidm.rgtemp11090455980(srcmbrprmyhrnid,srcsnpshtmmnb)
   NOCOMPRESS
   TABLESPACE cobimediumindex)
   ) TABLESPACE cobihcc
   PARTITION BY RANGE (dsnpshtmmik) INTERVAL (1)
   (PARTITION partempty VALUES LESS THAN (190001)
   INDEXING ON
   TABLESPACE cobi_hcc COLUMN STORE COMPRESS FOR QUERY LOW)
   PARALLEL 4;
   ;

   What I am getting today is shown below. This has the effect of forcing the creation of all of these partitions whether I have data that needs them or not, which therefore does not follow my model definition. I have to edit the script to remove the unnecessary partitions.

   --

   -- Script generated by Schema Compare for Oracle 4.0.10.528 on 16/11/2018 07:34:27

   SET DEFINE OFF
   SET SQLBLANKLINES ON

   CREATE TABLE cobidm.rgtemp11090455980 (
   fmbrtenuremmsnpshtik NUMBER NOT NULL,
   dmbrprmyhrnik NUMBER NOT NULL,
   <skipping columns for bevity>
   crdsprcscntlupdid NUMBER NOT NULL,
   CONSTRAINT RGTEMP11090455981 PRIMARY KEY (fmbrtenuremmsnpshtik) USING INDEX (CREATE UNIQUE INDEX cobidm.rgtemp11090455982 ON cobidm.rgtemp11090455980(fmbrtenuremmsnpshtik)
   NOCOMPRESS
   TABLESPACE cobimediumindex),
   CONSTRAINT RGTEMP11090455983 UNIQUE (srcmbrprmyhrnid,srcsnpshtmmnb) USING INDEX (CREATE UNIQUE INDEX cobidm.rgtemp11090455984 ON cobidm.rgtemp11090455980(srcmbrprmyhrnid,srcsnpshtmmnb)
   NOCOMPRESS
   TABLESPACE cobimediumindex)
   ) TABLESPACE cobihcc
   PARTITION BY RANGE (dsnpshtmmik) INTERVAL (1)
   (PARTITION partempty VALUES LESS THAN (190001)
   INDEXING ON
   TABLESPACE cobihcc COLUMN STORE COMPRESS FOR QUERY LOW,
   PARTITION VALUES LESS THAN (201310)
   INDEXING ON
   TABLESPACE cobimediumdata NOCOMPRESS,
   PARTITION VALUES LESS THAN (201311)
   INDEXING ON
   TABLESPACE cobimediumdata NOCOMPRESS,
   PARTITION VALUES LESS THAN (201312)
   INDEXING ON
   TABLESPACE cobimedium_data NOCOMPRESS,

   <skipping many lines for brevity>

   PARTITION VALUES LESS THAN (201811)
   INDEXING ON
   TABLESPACE cobimediumdata NOCOMPRESS,
   PARTITION VALUES LESS THAN (201812)
   INDEXING ON
   TABLESPACE cobimediumdata NOCOMPRESS)
   PARALLEL 4;

   For background on Oracle's interval partitioning feature, see chapter 4 of Oracle Database Concept for release 12.2.

   Our practice is to create interval-partitioned tables with the minimum number of partitions necessary to create the table (usually just one partition), and let Oracle create all others as data arrives requiring them. Between test, QA, and production databases, data arrives at different times, giving rise to automatic creation of different partitions. But because these differences are only a side-effect of different contents, they are not relevant, in the same way that differences in system-generated constraint names are not relevant. Changing the partition… 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…)
   1 comment  ·  Schema Compare  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

4. Pre-script introduction in the scheme compare deployment script.

   Hi , I am trying to understand how to introduce a pre-script ALTER SESSION SET CURRENT_SCHEMA = <> SQL statement in the top of the deployment script which is generated during the schema compare either between source DB vs target DB or TFS vs Target DB.

   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  ·  All Oracle  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

5. Modify Oracle Data Compare to display table name when /verbose option is used on the command line

   The current command line option runs but produces no output until the entire compare is completed, the GUI tells you what table it is on and the % complete. The batch process should be able to do the same.

   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  ·  Data Compare  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

6. Extend SQL parser to read scripts generated by other tools

   If the SQL parser could read DDL generated by other tools (e.g. data modeling tools), then the schema comparison could find differences between the schema as defined by those tools versus a database.

   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  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

7. DB or Version Control URL update functionality

   There is no functionality to update an existing project GIT repository or DB URL.

   I have to update it under :

   ConnectionStore.xml and LinkedDatabase.xml

   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 →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

8. Sorting Database Objects in Sync script

   When we create a syncronization script we have diffrent order of objects from time to time. It is not very good for us, because it is hard to find out changes.
   Could you please make that the order does not change (for example in alphabetical order).

   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…)
   2 comments  ·  Schema Compare  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

9. BUG!!!!

   This has been an issue with Oracle tools for some time.

   A table with a Generated column has a bug which inserts an extra right parentheses in its definition. Can be seen in Source Control as well as Schema Compare.

   ColumnName NUMBER(1) GENERATED ALWAYS AS (NVL2("ForeignKey",0,1)) NOT NULL,

   tool generates:

   ColumnName NUMBER(1) GENERATED ALWAYS AS (NVL2("ForeignKey",0,1))) NOT NULL,

   2 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  ·  All Oracle  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

10. separate type spec and type body

    Please separate type specifications and type bodies. (e.g. "CREATE TYPE FOO AS OBJECT" and "CREATE OR REPLACE TYPE BODY FOO"). Most of the time our changes are only to the body but Schema Compare will try to recreate the spec on deployment even if the spec has not changed.

    This will fail if it has dependencies and make automated builds fail when using the Deployment Suite for Oracle with a build system.

    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…)
    0 comments  ·  Schema Compare  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

11. Integrate the Oracle Tools with Oracle SQL Developer

    Looking for feedback from our Oracle Users if they would like integration with Oracle SQL Developer.

    Launch the tools from within the IDE.
    Or Perform Source Control for Oracle Check-in or Get Latest process from within the IDE.

    Please comment or vote on this topic.

    11 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  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    under review  ·  AdminDavid Atkinson (Product Manager, Redgate) responded

    As well as your votes, please also add a comment to the issue describing your need in more detail so we understand what the integration should entail.

12. When installing Source Control for Oracle, be able to set / configure where the WorkingBases and Transients folders are created.

    By default, Source Control for Oracle creates the WorkingBases and Transients (along with other associated files and folders) in the users Windows profile (C:\Users<user name>\AppData\Local\Red Gate\Source Control for Oracle).

    In some environments the C: drive is configured to be minimal size (just OS and some required applications).

    Being able to configure the paths where the WorkingBases and Transients (along with other associated files and folders) would to free up disk space in environments where the C:\ is configured to minimal disk space.

    11 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 →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

13. 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 list of coulumn names should be listed in help in orde to be used in the internal select of SOCO.

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

    15 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  ·  Schema Compare  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

14. 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 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  ·  Source Control  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    under review  ·  AdminStephanie (Product Manager, Redgate) responded

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

15. Please add ssuport for oracle CONTEXT object

    The Oracle CONTEXT object is not seen by Source Control.

    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…)
    1 comment  ·  Source Control  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

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

    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  ·  Schema Compare  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

17. Include support for ignoring ignored items in subversion

    Include support for ignoring ignored items in subversion

    This is NOT the same as filtering out objects. Once an object is in the svn:ignore it is supposed to be dead to subversion until revived.

    2 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  ·  Source Control  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

18. Selecting TABLES list from Excel / Text file ?

    If the source schema has around 1000 tables and we want to compare only 500 tables. Its a very tedious job to select all the 500 tables manually in the TABLES options tab. If we have all the 500 tables list stored in an excel sheet,csv,txt format. It would be good if data compare tool GUI (or) command line utility has a way to read all the user defined tables list from the excel/txt/csv sheet.

    13 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  ·  Data Compare  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

19. Merge grants (or similar)

    Here is the issue we are having.

    Two developers are working on different instances of the same database schema. If both of them add grants to the same user or role to different objects an issue arises when trying to commit to the repository.

    The user that commits second will have a conflict.

    If they choose the repository's grants for that user, they will lose their changes on their instance.
    It they choose the database's grants for that user, they will overwrite the other user's changes in the repository.

    It would be really nice to have one of these options when dealing with grants:

    1) Treat grants as an attribute of the schema object.
    
    2) Be able to merge grants
    3) Be able to choose individual grants to bring across, and not revoke any.

    Here is the issue we are having.

    Two developers are working on different instances of the same database schema. If both of them add grants to the same user or role to different objects an issue arises when trying to commit to the repository.

    The user that commits second will have a conflict.

    If they choose the repository's grants for that user, they will lose their changes on their instance.
    It they choose the database's grants for that user, they will overwrite the other user's changes in the repository.

    It would be really nice to have one of these options… more

    5 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  ·  Source Control  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

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

    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 →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close