38 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…
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…
1 vote -
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 -
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 -
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…1 vote -
Support object tables
CREATE TABE FOO of BAR
If 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 -
Synonym Handling w/ "Exclude Schema Names" option Enabled
With the “Exclude Schema Names” option enabled, SCO identifies false-positive mismatches for public synonyms.
In Oracle public synonym DDL w/o owner specified defaults the object owner to current user.
CREATE PUBLIC SYNONYM foo_bar FOR bar
/SELECT *
FROM allsynonyms
WHERE synonymname = 'FOO_BAR'
/SCO happily generates the Public synonym DDL w/o the owner specified (and it can be executed as such). However, on subsequent comparisons the underlying object’s qualified name is used and the public synonyms are all identified as being different.
e.g. CREATE OR REPLACE PUBLIC SYNONYM foobar FOR myschema.bar vs. CREATE OR…1 vote -
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 -
wildcard
Please add advanced filtering in Schema Compare. E.g. wildcard or regex matches to only show objects matching a certain criteria.
3 votes -
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…
4 votes -
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 -
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 -
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…
15 votes -
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 -
50 votes
We are working to make Redgate Change Control and Redgate Change Automation available on Mac OS. These are our new migrations-based solutions. Redgate Change Automation is available as a docker container. You can learn more about this at https://documentation.red-gate.com/dso.
-
portable installation
Oracle schema compare should install also in a portable way.
4 votes -
More control over file naming of source-controlled script files.
It would be good if generating source control files where would be control how files are named.
Data Compare does not allow joining related objects (like table with alias and indexes), so allowing to change alias name filenames and index filenames patterns would be nice (like prefix+tablename+fieldname for index)5 votes -
Concurrent user licensing
Add concurrent licensing system to the product so you can use it on Citrix Xenapp.
6 votes -
Constraints against other schemas
Include constraints that's against other schemas
4 votes
- Don't see your idea?