Navigation:  Data Management > Compare Structures >

Example HTML Report

 Previous pageReturn to chapter overviewNext page

This is an example of a REPORT generated in HTML format on inter schema SQL table comparison task

 

LEVEL STATUS Type Name Picture SERVER DEFAULT SIZE Precision B DT ID NULL COL NAMES PK ND [D] TABLE NAME DB Name NAME ORIG M
-------------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- -------------------------
Table(s)
-------------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- -------------------------
Parent TABLE dbo.animals [SQL] dmc_test
Child TABLE dmc.animals [SQL] dmc_test
Child TABLE dmc.animals2 [SQL] dmc_test
Child TABLE test.animals [SQL] dmc_test
-------------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- -------------------------
Columns
-------------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- -------------------------
Parent INT ANIMALID LONG NO dbo.animals
Identical dmc.animals dmc_test ANIMALID
Identical dmc.animals2 dmc_test ANIMALID
Identical test.animals dmc_test ANIMALID
Parent INT DAMID LONG YES dbo.animals
Identical dmc.animals dmc_test DAMID
Identical dmc.animals2 dmc_test DAMID
Identical test.animals dmc_test DAMID
Parent INT SIREID LONG YES dbo.animals
Identical dmc.animals dmc_test SIREID
Identical dmc.animals2 dmc_test SIREID
Identical test.animals dmc_test SIREID
Parent INT GROUPID LONG YES dbo.animals
Identical dmc.animals dmc_test GROUPID
Identical dmc.animals2 dmc_test GROUPID
Identical test.animals dmc_test GROUPID
Parent INT PADDOCKID LONG YES dbo.animals
Identical dmc.animals dmc_test PADDOCKID
Identical dmc.animals2 dmc_test PADDOCKID
Identical test.animals dmc_test PADDOCKID
Parent INT CLASSID LONG YES dbo.animals
Identical dmc.animals dmc_test CLASSID
Identical dmc.animals2 dmc_test CLASSID
Identical test.animals dmc_test CLASSID
Parent VARCHAR TAGNUMBER CSTRING 23 YES dbo.animals
Different 24 dmc.animals dmc_test TAGNUMBER
Different 24 dmc.animals2 dmc_test TAGNUMBER
Different 52 test.animals dmc_test TAGNUMBER
Parent VARCHAR REGNUMBER CSTRING 33 YES dbo.animals
Different 34 dmc.animals dmc_test REGNUMBER
Different 34 dmc.animals2 dmc_test REGNUMBER
Different 52 test.animals dmc_test REGNUMBER
Parent VARCHAR DESCRIPTION CSTRING 33 YES dbo.animals
Different 34 dmc.animals dmc_test DESCRIPTION
Different 34 dmc.animals2 dmc_test DESCRIPTION
Different 52 test.animals dmc_test DESCRIPTION
Parent DATETIME DATEOFBIRTH 1 YES dbo.animals
Identical dmc.animals dmc_test DATEOFBIRTH
Identical dmc.animals2 dmc_test DATEOFBIRTH
Identical test.animals dmc_test DATEOFBIRTH
Parent VARCHAR SEX CSTRING 9 YES dbo.animals
Different 10 dmc.animals dmc_test SEX
Different 10 dmc.animals2 dmc_test SEX
Different 8 test.animals dmc_test SEX
Parent DECIMAL AGE DECIMAL 9 2 YES dbo.animals
Identical dmc.animals dmc_test AGE
Identical dmc.animals2 dmc_test AGE
Different REAL SREAL test.animals dmc_test AGE
Parent VARCHAR AQUIREMETHOD CSTRING 13 YES dbo.animals
Different 14 dmc.animals dmc_test AQUIREMETHOD
Different 14 dmc.animals2 dmc_test AQUIREMETHOD
Different 52 test.animals dmc_test AQUIREMETHOD
Parent DATETIME DATEPURCHASED 1 YES dbo.animals
Identical dmc.animals dmc_test DATEPURCHASED
Identical dmc.animals2 dmc_test DATEPURCHASED
Different INT LONG test.animals dmc_test DATEPURCHASED
Parent DATETIME PLACEDINSERVICE 1 YES dbo.animals
Identical dmc.animals dmc_test PLACEDINSERVICE
Identical dmc.animals2 dmc_test PLACEDINSERVICE
Identical test.animals dmc_test PLACEDINSERVICE
Parent VARCHAR PLACEOFPURCHASE CSTRING PARIS 32 YES dbo.animals
Different 33 dmc.animals dmc_test PLACEOFPURCHASE
Different 33 dmc.animals2 dmc_test PLACEOFPURCHASE
Different 31 test.animals dmc_test PLACEOFPURCHASE
Parent DECIMAL ANIMALVALUE DECIMAL 7 2 YES dbo.animals
Identical dmc.animals dmc_test ANIMALVALUE
Identical dmc.animals2 dmc_test ANIMALVALUE
Identical test.animals dmc_test ANIMALVALUE
Parent INT MARK LONG YES dbo.animals
Identical dmc.animals dmc_test MARK
Identical dmc.animals2 dmc_test MARK
Identical test.animals dmc_test MARK
Parent TINYINT BRED BYTE YES dbo.animals
Identical dmc.animals2 dmc_test BRED
Identical test.animals dmc_test BRED
Parent TINYINT CALFATSIDE BYTE YES dbo.animals
Identical dmc.animals dmc_test CALFATSIDE
Identical dmc.animals2 dmc_test CALFATSIDE
Identical test.animals dmc_test CALFATSIDE
-------------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- -------------------------
Constraints
-------------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- -------------------------
Parent KEY PRIMARY +ANIMALID 1 1 dbo.animals
Identical dmc.animals2 dmc_test PRIMARY
Parent KEY TAGNUMBER_KEY +CLASSID,+TAGNUMBER 1 dbo.animals
Identical dmc.animals2 dmc_test TAGNUMBER_KEY
RENAME +TAGNUMBER,+CLASSID test.animals dmc_test TAGNUMBER_KEY
Parent KEY CLASSID_KEY +CLASSID dbo.animals
Identical dmc.animals2 dmc_test CLASSID_KEY
Parent KEY DAMID_INDEX +DAMID dbo.animals
Identical dmc.animals2 dmc_test DAMID_INDEX
Identical test.animals dmc_test DAMID_INDEX
Parent KEY GROUPID_KEY +GROUPID,+CLASSID dbo.animals
RENAME +CLASSID,+GROUPID dmc.animals2 dmc_test GROUPID_KEY
RENAME +CLASSID,+GROUPID test.animals dmc_test GROUPID_KEY
Parent KEY MARK_KEY +MARK dbo.animals
Identical dmc.animals2 dmc_test MARK_KEY
Identical test.animals dmc_test MARK_KEY
Parent KEY PADDOCKID_KEY +PADDOCKID dbo.animals
Identical dmc.animals2 dmc_test PADDOCKID_KEY
Identical test.animals dmc_test PADDOCKID_KEY
-------------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- -------------------------
Different Constraint
-------------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- -------------------------
Drop OR Rename KEY dmc_PRIMARY +ANIMALID 1 1 dmc.animals dmc_test dmc_PRIMARY
Drop OR Rename KEY dmc_TAGNUMBER_KEY +CLASSID,+TAGNUMBER 1 dmc.animals dmc_test dmc_TAGNUMBER_KEY
Drop OR Rename KEY dmc_CLASSID_KEY +CLASSID dmc.animals dmc_test dmc_CLASSID_KEY
Drop OR Rename KEY dmc_DAMID_INDEX +DAMID dmc.animals dmc_test dmc_DAMID_INDEX
Drop OR Rename KEY dmc_GROUPID_KEY +CLASSID,+GROUPID dmc.animals dmc_test dmc_GROUPID_KEY
Drop OR Rename KEY dmc_MARK_KEY +MARK dmc.animals dmc_test dmc_MARK_KEY
Drop OR Rename KEY dmc_PADDOCKID_KEY +PADDOCKID dmc.animals dmc_test dmc_PADDOCKID_KEY
Drop OR Rename KEY ANIMALID_PK +ANIMALID 1 1 test.animals dmc_test ANIMALID_PK
Drop OR Rename KEY CLASSID_KEY_NEW +CLASSID test.animals dmc_test CLASSID_KEY_NEW
Drop OR Rename KEY PADDOCK_DAMID_INDEX +DAMID,+PADDOCKID test.animals dmc_test PADDOCK_DAMID_INDEX