Compare data bases lists table as different, thought they are the identical
When comparing databases, we constantly get the tables with no differences. And final script doesn't have any alter statements.
Ex.: the table
CREATE TABLE SecurityContextXSiteGroup (
SecurityContextId INT NOT NULL,
SiteGroupId INT NOT NULL
)
ENGINE = INNODB,
CHARACTER SET utf8mb4,
COLLATE utf8mb40900ai_ci;
ALTER TABLE SecurityContextXSiteGroup
ADD UNIQUE INDEX SecurityContextXSiteGroup_UN(SecurityContextId, SiteGroupId);
ALTER TABLE SecurityContextXSiteGroup
ADD CONSTRAINT SecurityContextXSiteGourp_FK FOREIGN KEY (SecurityContextId)
REFERENCES SecurityContext(SecurityContextId) ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE SecurityContextXSiteGroup
ADD CONSTRAINT SecurityContextXSiteGourpFK1 FOREIGN KEY (SiteGroupId)
REFERENCES SiteGroup(SiteGroupId) ON DELETE CASCADE ON UPDATE CASCADE;
The other table ("differs"):
CREATE TABLE SecurityContextXSiteGroup (
SecurityContextId INT NOT NULL,
SiteGroupId INT NOT NULL
)
ENGINE = INNODB,
CHARACTER SET utf8mb4,
COLLATE utf8mb40900ai_ci;
ALTER TABLE SecurityContextXSiteGroup
ADD UNIQUE INDEX SecurityContextXSiteGroup_UN(SecurityContextId, SiteGroupId);
ALTER TABLE SecurityContextXSiteGroup
ADD CONSTRAINT SecurityContextXSiteGourp_FK FOREIGN KEY (SecurityContextId)
REFERENCES SecurityContext(SecurityContextId) ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE SecurityContextXSiteGroup
ADD CONSTRAINT SecurityContextXSiteGourpFK1 FOREIGN KEY (SiteGroupId)
REFERENCES SiteGroup(SiteGroupId) ON DELETE CASCADE ON UPDATE CASCADE;
The generated update script:
-- Disable foreign keys
/*!40014 SET @OLDFOREIGNKEYCHECKS=@@FOREIGNKEYCHECKS, FOREIGNKEY_CHECKS=0 */;
SET NAMES 'utf8';
--
-- Set default database
USE client_sol;
--
-- Enable foreign keys
/*!40014 SET FOREIGNKEYCHECKS=@OLDFOREIGNKEY_CHECKS */;
-
AdminDevart (_, Devart) commented
Dear User,
Thanks for your patience!
We would like to inform you that a new version of the Studio has now been released, it includes a lot of features and fixes, including the issue you described.
We kindly ask you to update to the latest version of the Studio and check the implementation of the functionality you described in this post. If the issue is still relevant, please let us know in detail by filling out the form on the company’s website (https://www.devart.com/company/contactform.html) or write directly to support@devart.com
Best,
Devart Team -
Support Team commented
Hi,
Thanks for your patience!
Kindly note that in order for us to help you as quickly as possible, we need more detailed information from you:
- versions of sourcing and target servers
- tool version
- DDL of compared objects
- settings you choose
- specify the change difference to be displayedIt would be great if you could get a full description of each step with a screenshot, but a screen recording would be even better.
Please note that the more detail you describe the situation and allow us to reproduce it on our side, the faster our team will be able to analyze and identify the problem and help you.
Thanks for understanding.
You can send all information via support@devart.com
Looking forward to your email!
Best,
Devart Support Team