MCTS Self-Paced Training Kit (Exam 70-448) out of Sync with AdventureWorks

The link provided in the Microsoft SQL Server 2008 - Business Intelligence Development and Maintenance: MCTS Self-Paced Training Kit (Exam 70-448) book for the AdventureWorks database is out of date and the latest version does not have the same tables and views. Where can I find a copy of the AdventureWorks database that works with this book?
1 person has
this problem
+1
Reply
  • Hi Preston,
    I will be emailing you the solution from one of our book techs here shortly.

    Cheers,
    Tai Hake
    Customer Service Rep,
    O'Reilly Media
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. indifferent, undecided, unconcerned kidding, amused, unsure, silly happy, confident, thankful, excited sad, anxious, confused, frustrated

  • I was wondering the same thing - I've managed to get to lesson 3 - but I really don't want to go any further unless I'm able to do the actual work, rather than just look at photos, or look at the companion cd on how it should look in the end. I want to actually do the steps myself.

    Thank you.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. indifferent, undecided, unconcerned kidding, amused, unsure, silly happy, confident, thankful, excited sad, anxious, confused, frustrated

  • Hi Gestotamoseke,
    if you need help with that book, you can contact our Microsoft Press book tech support staff at:
    mspbooksupport@oreilly.com
    They'll be able to help you if you get stuck.

    Cheers,
    Tai H.
    Customer Service Rep,
    O'Reilly Media
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. indifferent, undecided, unconcerned kidding, amused, unsure, silly happy, confident, thankful, excited sad, anxious, confused, frustrated

  • Hi,

    You can download the version of the AdventureWorks2008 database that the book used from the companion content for the 70-433 Training Kit from here - http://examples.oreilly.com/978073562...
    The AdventureWorks databases will be in the Database folder of that zip file.
    That database doesn't have an installer like the one from the CodePlex site, so you'll need to follow these instructions in order to attach the database:

    -------
    How to Install the Sample Databases

    Caution
    Database names are unique within an instance of SQL Server. The sample databases are named AdventureWorks2008, AdventureWorksDW2008, and Northwind. If you already have databases with these names, you need to make changes to either the names of these sample databases or to the databases that already exist in your instance. If you make changes to the names, you also need to make the corresponding naming adjustments wherever a database name is referenced within this book.

    To install the sample databases from the companion CD to your hard disk, perform the following steps:
    1. Follow the instructions in the SQL Server Books Online article “How to: Enable
    FILESTREAM” at http://msdn.microsoft.com/en-us/libra....

    2. Insert the companion CD into your CD-ROM drive.

    3. Browse to the \Databases folder and then to the directory of your choice.

    4. Copy the Northwind.mdf and Northwind.ldf files to C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA.

    5. Copy the AdventureWorksDW2008_Data.mdf and AdventureWorksDW2008_Log.ldf files to C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA.

    6. Copy the AdventureWorks2008_Data.mdf and AdventureWorks2008_Log.ldf files
    with the entire Documents folder to C:\Program Files\Microsoft SQL Server\
    MSSQL10.MSSQLSERVER\MSSQL\DATA.

    7. In SQL Server Management Studio connect to your SQL Server instance in an Object Explorer window.

    8. Right-click the Databases node and select Attach.

    9. Click Add, select AdventureWorks2008_Data.mdf, and click OK.

    10. Click Add, select AdventureWorksDW2008_Data.mdf, and click OK.

    11. Click Add, select Northwind.mdf, and click OK.

    12. Click OK. Verify that you have the AdventureWorks2008, AdventureWorksDW2008, and Northwind databases attached to your instance.
    ------

    Make sure you follow those directions as they process is different than the one the book describes.

    I hope that helps,
    Chris Olson
    O'Reilly Book Support
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. indifferent, undecided, unconcerned kidding, amused, unsure, silly happy, confident, thankful, excited sad, anxious, confused, frustrated

  • Thanks for providing the source data, Chris! I'm not sure why codeplex removed the 2008 AdventureWorks database samples.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. indifferent, undecided, unconcerned kidding, amused, unsure, silly happy, confident, thankful, excited sad, anxious, confused, frustrated

  • Thanks a lot! I'm with the same problem. I bought SQL Server 2008 Reporting Services Step by Step but I didn't had the databaso, so the examples with the book where totally useless.

    Thanks
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. indifferent, undecided, unconcerned kidding, amused, unsure, silly happy, confident, thankful, excited sad, anxious, confused, frustrated