Thursday, March 8, 2012

AdventureWorks2008 Doesn't Exist

I'm using the self paced training kit Exam 70-448: MCTS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance.

When you download the Adventure Works database sample at http://msftdbprodsamples.codeplex.com/releases/view/55926, you'll find it doesn't include the AdventureWorks2008 sample being called for. No big deal. It's the same database as AdventureWorks with some date changes.

I did my first pass through the book pointing to AdventureWorks in my connection strings and when later SSRS lessons were calling for dates that were out of rage (2004-2008), I ran a quick query against the fields in question in SSMS as follows:

Use [Database]
Go

Update [Table]
Set [xField] = DATEADD(year,3,[xField])

This run through the book I used the export wizard against AdventureWorks and created AdventureWorks2008. Now I'm pointing to AdventureWorks2008 in my BIDS connection strings and I'll update dates when needed.

No comments:

Post a Comment