Toad World® Forums

Compare Objects dropping schema name


I was comparing a trigger that is owned by schema A but is for a table owned by schema B. The comparison removed the tables owner so it looked like the table upon which the trigger was based was owned by the owner of the trigger. I didn’t see this initially, copied the script/text from the compare window and then couldn’t figure out why it didn’t work.



[ Attachment(s) from John Dorlon included below]

Single object compare or schema compare?

If Schema compare,

Go to “Object type specific options” and check “parse for
schema names”

Go to “misc options” and check “include schema name in
migration ddl” option