I am running a schema compare and have it selected so that constraints are being compared. When I do this, it does not show the same differences when running the compare in both directions. The sync script does not show any drop statements for the contstraints, only create statements.
I need the compare to show me the differences regardless of which direction the compare is doing. The script should show drop statements for the constraints if a constraint needs to be dropped to make the schemas the same.
Here is the scripts that I get when doing the two compares:
--------------------------------------------------------------------------
-- Play this script in TESTB@CHAD92.PROD.QUEST.CORP to make it look like TESTA@CHAD92.PROD.QUEST.CORP
--
-- Please review the script before using it to make sure it won't
-- cause any unacceptable data loss.
--
-- TESTB@CHAD92.PROD.QUEST.CORP Schema Extracted by User TESTB
-- TESTA@CHAD92.PROD.QUEST.CORP Schema Extracted by User CHAD
WORKAROUND:
None
STATUS:
Waiting for fix to be released in a future version of Toad for Oracle.
This has been fixed in v11.0 beta version, which can be downloaded by going to http://toadfororacle.com/beta.jspa.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy