View Issue Details

IDProjectCategoryView StatusLast Update
0000401Database Workbench v4Compare & Migrationpublic2014-01-27 13:09
ReporterJeroen Pluimers Assigned ToMartijn Tonies  
PrioritynormalSeverityminorReproducibilityalways
Status closedResolutionfixed 
Fixed in Version4.4.4 
Summary0000401: SQL Server compare, "nocheck" is not in script after compare
DescriptionThis diff does end up in the comparison tree, but not in the script:

ALTER TABLE dbo.ALGT_Applicatie WITH NOCHECK ADD CONSTRAINT FK_ALGT_Applicatie_ALGT_AppServer FOREIGN KEY (AppServer)
  REFERENCES dbo.ALGT_AppServer (AppServerID)
  ON DELETE NO ACTION
  ON UPDATE NO ACTION
GO

The diff is subtle:
Source database has the constraint as CHECK, destination as NOCHECK.
TagsNo tags attached.
DBMS & Version

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2012-07-15 22:02 Jeroen Pluimers New Issue
2012-07-16 10:12 Martijn Tonies Status new => acknowledged
2013-12-18 11:50 Martijn Tonies Assigned To => Martijn Tonies
2013-12-18 11:50 Martijn Tonies Status acknowledged => assigned
2013-12-18 11:50 Martijn Tonies Summary SQL Server database compare: not all differences end up in the script => SQL Server compare, "nocheck" is not in script after compare
2013-12-18 16:12 Martijn Tonies Status assigned => resolved
2013-12-18 16:12 Martijn Tonies Fixed in Version => 4.4.4
2013-12-18 16:12 Martijn Tonies Resolution open => fixed
2014-01-13 15:09 Martijn Tonies View Status private => public
2014-01-27 13:09 Martijn Tonies Status resolved => closed