- or
1 result found
-
Support for Queue Tables
Please add support or the ability to find Queue tables.
12 votesThis was released in V5.7.11
129 results found
-
Ignore SQL script files that fail to parse
Add an option to ignore SQL files that fail to parse when the target is a Scripts Folder.
I would like this, such that the tool can do autonomous exports without it crashing if the target contains valid but unsupported SQL like
"DROP VIEW viewname
CREATE OR REPLACE viewname"1 vote -
Option ILM POLICY
Help, please, I compare tables but do not see ILM POLICY.
The ILM POLICY option is enabled.Script:
CREATE TABLE salesado
(PRODID NUMBER NOT NULL,
CUSTID NUMBER NOT NULL,
TIMEID DATE NOT NULL,
CHANNELID NUMBER NOT NULL,
PROMOID NUMBER NOT NULL,
QUANTITYSOLD NUMBER(10,2) NOT NULL,
AMOUNTSOLD NUMBER(10,2) NOT NULL)
PARTITION BY RANGE (timeid)
( PARTITION salesq12012 VALUES LESS THAN (TODATE('01-APR-2012','dd-MON-yyyy')),
PARTITION salesq22012 VALUES LESS THAN (TODATE('01-JUL-2012','dd-MON-yyyy')),
PARTITION salesq32012 VALUES LESS THAN (TODATE('01-OCT-2012','dd-MON-yyyy')),
PARTITION salesq42012 VALUES LESS THAN (TO_DATE('01-JAN-2013','dd-MON-yyyy'))
);ALTER TABLE salesado MODIFY PARTITION salesq1_2012
ILM ADD POLICY ROW STORE COMPRESS ADVANCED ROW
AFTER 30 DAYS OF NO MODIFICATION;
COMMIT;ALTER TABLE salesado MODIFY PARTITION salesq2_2012
ILM ADD POLICY ROW STORE COMPRESS ADVANCED SEGMENT
AFTER 3 MONTHS OF NO MODIFICATION;
COMMIT;ALTER TABLE salesado MODIFY PARTITION salesq3_2012
ILM ADD POLICY ROW STORE COMPRESS ADVANCED GROUP
AFTER 6 MONTHS OF NO MODIFICATION;
COMMIT;Help, please, I compare tables but do not see ILM POLICY.
The ILM POLICY option is enabled.Script:
CREATE TABLE salesado
(PRODID NUMBER NOT NULL,
CUSTID NUMBER NOT NULL,
TIMEID DATE NOT NULL,
CHANNELID NUMBER NOT NULL,
PROMOID NUMBER NOT NULL,
QUANTITYSOLD NUMBER(10,2) NOT NULL,
AMOUNTSOLD NUMBER(10,2) NOT NULL)
PARTITION BY RANGE (timeid)
( PARTITION salesq12012 VALUES LESS THAN (TODATE('01-APR-2012','dd-MON-yyyy')),
PARTITION salesq22012 VALUES LESS THAN (TODATE('01-JUL-2012','dd-MON-yyyy')),
PARTITION salesq32012 VALUES LESS THAN (TODATE('01-OCT-2012','dd-MON-yyyy')),
PARTITION salesq42012 VALUES LESS THAN (TO_DATE('01-JAN-2013','dd-MON-yyyy'))
);ALTER…
1 vote -
more features to add in interactive report html
Hi, i have a question about interactive html report file. Maybe it is possible to add buttons in it like in schema compare for jumping between changes, because now its not really comfortable to navigate, when you have to scroll and find one change on big file. And finally you find that there is the difference only on space or tab. Also maybe it is possible to have alignment of code not on left side, but like in database - that spaces, tabs wouldn't be removed.
Here is the link where i got answered to this question. But he just said to register this question here:
https://forum.red-gate.com/discussion/comment/168797#Comment_168797
Hi, i have a question about interactive html report file. Maybe it is possible to add buttons in it like in schema compare for jumping between changes, because now its not really comfortable to navigate, when you have to scroll and find one change on big file. And finally you find that there is the difference only on space or tab. Also maybe it is possible to have alignment of code not on left side, but like in database - that spaces, tabs wouldn't be removed.
Here is the link where i got answered to this question. But he just…
1 vote -
object history
I would like to have the option (like in TortoiseSVN) to be able to check all revisions in which the indicated object was changed (either by name or by click). The history of the specified object would be very helpful.
1 voteCurrently, in the tool, we only show all the history. If you use TortoiseSVN or another VCS client or command line, you can see the history for a particular object by locating that object's file in the repository and viewing that file's history.
-
Add support for ANALYTIC VIEWS objects
Currently the Schema compare for ORACLE doesnt support the below objects.
1. ATTRIBUTE DIMENSION
2. HIERARCHY
3. ANALYTIC VIEWThese have been available since Oracle12c. It would be nice for redgate to support all the Oracle object types from the latest database versions.
1 vote -
Locking and unlocking the objects in Oracle
Hi Team,
Lock and unlock the objects in oracle. Anyone can unlock and lock the objects, but our requirement it's should be configurable. some admin or some user has control to unlock the objects.
For example, User ABC Locked the EMP tables currently anyone can unlock the objects but it's should either ABC user need to unlock or give some admin user to unlock the objects. We need to some control required to maintain the locking and unlocking the objects and there is no audit info as well.
3 votes -
Virtual Columns Should Be Ignored By Default
Since you can't update the values, why compare them in the first place?
3 votes -
Add the ability to build without a target database
The Azure DevOps extensions for SQL Server allow you to build the solution on check-in of new code without needing a target database to build against. Having similar extensions with this ability for Oracle to match what we can do with SQL Server would be fantastic.
3 votes -
Add support for DBMS_RLS objects such as Packages and Contexts
We use DBMSRLS to filter data based on the Oracle Context object. The context is set using a login script which is then used as part of a table policy. More information is available at https://docs.oracle.com/cd/E2469301/appdev.11203/e23448/d_rls.htm#i1004716.
1 vote -
Foreign Keys not included in comparison if referenced table is excluded by the Ignore Rules Filter
This presents a problem for fully capturing table DDL definitions that are selected for the comparison
It is not immediately clear, and may be difficult to detect that FKs are excluded / failed to be captured, unless a full / unfiltered schema comparison is performed.
There is no indication that the FKs are suppressed and no setting will include them.
Are there any Schema Compare for Oracle and / or Source Control for Oracle users who would like to see the FK keys that reference Ignored Tables to be included in the deployment script or recorded in the DDL for the table? Or at least be warned that the referencing object is listed in the Ignore Rules?
This presents a problem for fully capturing table DDL definitions that are selected for the comparison
It is not immediately clear, and may be difficult to detect that FKs are excluded / failed to be captured, unless a full / unfiltered schema comparison is performed.
There is no indication that the FKs are suppressed and no setting will include them.
Are there any Schema Compare for Oracle and / or Source Control for Oracle users who would like to see the FK keys that reference Ignored Tables to be included in the deployment script or recorded in the DDL for…
4 votes -
Include option to create refresh groups (like Refresh Group X)
Would be nice to be able to include projects into fresh groups -- so group or similar projects could be refreshed together.
Individual refreshes may become tedious, and the Refresh All may be too broad.
Alt as a simpler implementation provide the ability to exclude projects from a bulk (Refresh All) -- e.g. by marking a project as inactive.
Example:
If I have 15 projects total:
- 5 defined as belong to Group A,
- 4 belong to Group B,
- 4 are unaffiliated
- 2 are inactiveWould like to be able to:
- refresh Group A (project count: 5)
- refresh Group B (project count: 4)
- Refresh All (project count: 13)Would be nice to be able to include projects into fresh groups -- so group or similar projects could be refreshed together.
Individual refreshes may become tedious, and the Refresh All may be too broad.
Alt as a simpler implementation provide the ability to exclude projects from a bulk (Refresh All) -- e.g. by marking a project as inactive.
Example:
If I have 15 projects total:
- 5 defined as belong to Group A,
- 4 belong to Group B,
- 4 are unaffiliated
- 2 are inactiveWould like to be able to:
- refresh Group A (project count:…3 votes -
Comparison Options: Add a Ignore option for Sequence Increment By
Sometimes in non-PROD environmens vs prod we may want to have different increment by clauses on sequences.
e.g. increment by 3 on non-Prod but increment by 1 on Prod
Would be be nice to be able to ignore differences in the increment by clause as an ignore options (similar to the ignore option for sequence current value)
3 votes -
Project Display Order
Allow for manual ordering (e.g. drag and drop and/or move up / move down functionality) for Source Control Projects (vs. by name only)
3 votes -
QA department demand, according GMP rules, for proof of same data export-import
Our QA department will need proof to show that the exported Oracle 11 data is the same when imported to Oracle 12 due to the strict GMP regulations that we need to be compliant with as pharmaceutical production facility.
As the Oracle database is part of software from a vendor we don’t do any development with Oracle. We only need the Oracle data compare tool for making sure that with the upgrade of software, the Oracle 11 data is the same as the imported data in Oracle 12 (before the new software will be installed).
The Oracle compare tool has a main focus on developers, but we need it as QA compliant compare tool.A minor issue is when a table only has 1 column and that column is data type “Blob” than it is not able to compare (as also no comparison key can be set).
Redgate's standpoint:
For Data Compare for Oracle to be able to compare rows of data in tables it requires a comparison key so it can unique identify each row. In regards to 'BLOB' and 'CLOB' data, the size of data for a single row can be ridiculously large in size, therefore it is not good idea to use 'BLOB' and 'CLOB' data column as a comparison key. Hence why you cannot use 'BLOB' and 'CLOB' columns as the comparison key.To make the Redgate tool QA and GMP compliant we wish to see these types of tables also to be comparable without the need of a comparison key (and maybe a special licensed version without all the great developer tools/options as we will not use those in this case).
Our QA department will need proof to show that the exported Oracle 11 data is the same when imported to Oracle 12 due to the strict GMP regulations that we need to be compliant with as pharmaceutical production facility.
As the Oracle database is part of software from a vendor we don’t do any development with Oracle. We only need the Oracle data compare tool for making sure that with the upgrade of software, the Oracle 11 data is the same as the imported data in Oracle 12 (before the new software will be installed).
The Oracle compare tool has…3 votes -
DataMasker for Oracle - Improvement for Range Split rules
Hi,
When Using a Range Splitted Rule and one wants to auto generate the different ranges, damasker is launching following query (I will write just an example):
Select MIN(NUMERICFIELD) from MyTableToBeSplitted
UNION ALL
Select MAX(NUMERICFIELD) from MyTableToBeSplittedThis will involve reading table twice (being the default plan through FULL TABLE ACCESS or INDEX).
Talking about big tables (which are the favourite target for Range Splitted Rules), this is too much time.Instead, perhaps query could be changed to the following:
Select MIN(NUMERICFIELD) , MAX(NUMERICFIELD) from MyTableToBeSplitted
This will improve time spent, reducing it by a 50% as table will only be read once.
Thanks in advance,
Hi,
When Using a Range Splitted Rule and one wants to auto generate the different ranges, damasker is launching following query (I will write just an example):
Select MIN(NUMERICFIELD) from MyTableToBeSplitted
UNION ALL
Select MAX(NUMERICFIELD) from MyTableToBeSplittedThis will involve reading table twice (being the default plan through FULL TABLE ACCESS or INDEX).
Talking about big tables (which are the favourite target for Range Splitted Rules), this is too much time.Instead, perhaps query could be changed to the following:
Select MIN(NUMERICFIELD) , MAX(NUMERICFIELD) from MyTableToBeSplitted
This will improve time spent, reducing it by a 50%…
1 vote -
Grants are not detected correctly when logged in as proxy user.
Please support proxy users. They allow people to impersonate another user which is useful for all kinds of purposes regarding security and auditing.
So, I got this user called MyUserName which can act as a proxy user for OurSchema. To log in, I useMyUserName[OurSchema]as the username (and my own password). Then I can make modifications to OurSchema and basically work as if I'm logged in as OurSchema.
This works well in any tool. In Schema Compare it almost works, but there seems to be an issue with the grants. The grants are not detected, so when I run SC with a proxy user, I suddenly get about 3000 differences.Please support proxy users. They allow people to impersonate another user which is useful for all kinds of purposes regarding security and auditing.
So, I got this user called MyUserName which can act as a proxy user for OurSchema. To log in, I useMyUserName[OurSchema]as the username (and my own password). Then I can make modifications to OurSchema and basically work as if I'm logged in as OurSchema.
This works well in any tool. In Schema Compare it almost works, but there seems to be an issue with the grants. The grants are not detected, so when I run…1 vote -
constraints are not treated as seperate objects in oracle schema compare
constraints are not treated as separate objects in oracle schema compare,
without that, how can we compare constraints alone in a database ?
1 vote -
Support object tables
CREATE TABE FOO of BARIf I create a table (FOO) of an object type (BAR), this table is not picked up by schema compare. This is probably because it's not listed in USERTABLES, but in USEROBJECT_TABLES.
1 vote -
Add Error Handling to PL/SQL Blocks
Currently when using Data Compare for Oracle 4 if any INSERT/UPDATE throws an error in a PL/SQL block the entire block fails. Because of this the company I work for will not use the software for DML deployments. If Redgate could code error handling for each table or each block where the script will continue to update/insert SQL data even in the event of an error the software would be much more usable, robust, and practical. Thank-you for reading this. :) Please add error-handling to the DML code that is generated in the diff/sync scripts.
1 vote -
Multi-Select for conflict resolution
Ability to tick multiple items and resolve when faced with lots of conflicts
1 vote
- Don't see your idea?