0
Vote

AdventureWorks OLTP: The Table Design in Visio file is not consistent with the real DB

description

Environment:

  1. SQL Server Katmai
  2. SQL Samples
  3. Visio
     

Repro Steps:

  1. Open ‘<SampleRoot>\ Tools\Samples\AdventureWorks OLTP\ AdventureWorks.vsd’ via Visio
  2. Select Tables and Columns in DB ‘AdventureWorks’:
    select name,object_id from sys.tables
     
    select c.object_id,c.column_id,c.name,t.name as typename, c.max_length, c.is_nullable, c.is_identity,c.is_filestream
    from sys.columns c
    left join sys.types t on t.user_type_id=c.user_type_id
    where c.object_id in (select object_id from sys.tables)
  3. Compare the Tables and Columns at 1st and 2nd.
     

Expectation:

The Tables and Columns in Visio should be consistent with the ones in real DB
 

Actual Result:

The Tables and Columns in Visio are not consistent with the ones in real DB.
 
[Visio]Table not exists: CountryRegionCurrency
[RealDB]Column not exists: PurchaseOrderDetail-ShipMethodID
[RealDB]Column not exists: Employee-ShiftID

comments