About hallkbrdz

hallkbrdz · ‎02-15-2019

I saw that on one conversion that the Migration code noticed that there was both uppercase and lowercase objects and then decided to create two seperate schemas for EDB to hold them.That's not a huge deal for me, but it does require a bit of work to search/replace and get everything into upper as intended. Since Oracle ignores case (unless you put the names in quotes) by default and uses uppercase, it would be nice to have a "ignore schema case" checkbox for use when we know that it isn't important and just force every schema name to upper.

hallkbrdz · ‎02-12-2019

For Oracle materialized views, I'm getting a 0% sucess rate with a result of ""mv_name" is not a materialized view Hint: Use DROP TABLE to remove a table." I'm assuming the tool doesn't know what to do with MV's?

hallkbrdz · ‎02-12-2019

Our source database (vendor code) has several triggers like the following flagged as incompatible with EDB11. How could these be re-written for EDB? CREATE OR REPLACE TRIGGER FCOWNER.FC_DENSITOMETER_BEFORE_INS_UPD BEFORE INSERT OR UPDATE ON fcowner.FC_densitometer FOR EACH ROW WHEN (old.densitometer_index IS NULL OR new.densitometer_number <> old.densitometer_number OR new.densitometer_name <> old.densitometer_name OR (new.densitometer_name IS NOT NULL and old.densitometer_name IS NULL) OR (new.densitometer_name IS NULL AND old.densitometer_name IS NOT NULL) OR new.system_index <> old.system_index) BEGIN :new.last_modified := SYSDATE; END; /

hallkbrdz · ‎02-12-2019

I ran an assesment on one of our databases that makes use of many partitioned tables (just one level deep). I noticed almost all the resulting errors were due to references to these partitiioned tables, such as "relation "table_name" does not exist". This is for tables, indexes, constraints, and views. I don't see that as an issue so long as the resulting DDL is ordered correctly, but I wanted to point this out to improve the tool.

About hallkbrdz

Suggestion: Add a ignore-case in schema names opti...

Materialized Views 0%

Oracle trigger with OLD references

Partitioned Tables in Oracle creating multiple err...