AdventureWorks2012 OLTP Database Diagram

Question

Is there a 2012 version for:

http://www.microsoft.com/en-us/download/details.aspx?id=10331

Where is AdventureWorks2008_Conceptual.pdf?  2012 version?

Thanks.

---

Kalman Toth SQL SERVER 2012 & BI TRAINING
New Book: Beginner Database Design & SQL Programming Using Microsoft SQL Server 2012

Answer 1

Hi Kalman,

I cannot find the OLTP database diagram for 2012, too. Hope it will be published soon.

---

Stephanie Lv

TechNet Community Support

Answer 2

Hi Kalman,

I've forwarded this request to the current owner of the AdventureWorks set of sample databases. 

Best,

Gail

---

Gail Erickson [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights

Answer 3

Thanks Gail.

I noticed 1 (one) difference between AdventureWorks2008 & AdventureWorks2012: dates are shifted 4 years up. Example: OrderDate (Sales.SalesOrderHeader) of 20040201 --> 20080201 .

---

Kalman Toth SQL SERVER 2012 & BI TRAINING

Answer 4

Hi Kalman,

I'm working on your request. I'll post a reply as soon as your request is completed. I do not have an estimated delivery date yet :-) Is your request blocking you?

Thanks,

Derrick

Answer 5

Thanks Derrick.

Well, I have a workaround, I just go back to 2005 and 2008 diagrams.

2008 and 2012 AdventureWorks db-s appear to be very similar.

However, there were some significant db schema changes from 2005 to 2008.

---

Kalman Toth SQL SERVER 2012 & BI TRAINING