This project is read-only.

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



  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,, 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.


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