For some constraints the Schema Compare shows a difference in "columns" but double clicking on it will show in the side-by-side viewer that there are no differences.
As an example create the table and constraint below in two databases and them compare them:
CREATE TABLE testCompare
(
ID NUMBER (10) DEFAULT (0) NOT NULL,
FIRSTSENT DATE,
LASTSENT DATE
)
TABLESPACE users;
ALTER TABLE testCompare
ADD (
CONSTRAINT CK_testCompare CHECK
(LASTSENT >= FirstSent)
ENABLE VALIDATE);
The schema compare will report them as a different but they are exactly the same.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center