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
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center