locked
Finding the Correct Version of the AdventureWorks Sample Database RRS feed

Answers

  • Hello,

    I uploaded AdventureWorks databases for 2012, 2008R2 and 2008. Each download zip file contains an mdf database file and ldf log file. This consolidates AdventureWorks databases for several SQL Server versions to one page. Please let me know what you think.

    AdventureWorks Databases – 2012, 2008R2 and 2008

    http://msftdbprodsamples.codeplex.com/releases/view/93587


    Wednesday, August 29, 2012 1:01 AM

All replies

  • Great post and thanks for sharing.

    When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer

    Jeff Wharton
    MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCSD, MCITP, MCDBA
    Blog: Mr. Wharty's Ramblings
    Twitter: @Mr_Wharty
    MC ID: Microsoft Transcript

    Thursday, August 23, 2012 11:30 PM
  • Hello,

    I uploaded AdventureWorks databases for 2012, 2008R2 and 2008. Each download zip file contains an mdf database file and ldf log file. This consolidates AdventureWorks databases for several SQL Server versions to one page. Please let me know what you think.

    AdventureWorks Databases – 2012, 2008R2 and 2008

    http://msftdbprodsamples.codeplex.com/releases/view/93587


    Wednesday, August 29, 2012 1:01 AM
  • I downloaded a copy of the AdventureWorks database for SQL Server 2008R2 but it is missing the blog tables that I need for course 10264. Where can I find a script for those tables?

    Thanks,

    Shawn

    Saturday, October 13, 2012 12:27 AM
  • The script should be on the Student CD that comes with the course material or you can ask your instructor for the script.

    When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer

    Jeff Wharton
    MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCSD, MCITP, MCDBA
    Blog: Mr. Wharty's Ramblings
    Twitter: @Mr_Wharty
    MC ID: Microsoft Transcript

    Saturday, October 13, 2012 12:33 AM
  • There was no student CD. You had to go to the Microsoft learning site and download the course content. The Database was not included in course content. Not sure why. I have asked the instructor for the script, just waiting for him to email it to me.
    Saturday, October 13, 2012 10:05 PM
  • I'm looking for an AdvertureWorks database for SQLCE 4.0.

    Can anyone point me to it?

    Ken


    Ken Cox - Microsoft MVP [ASP.NET]

    Wednesday, January 2, 2013 5:48 PM
  • I don't think there is a compact edition version of AdventureWorks database.

    For every expert, there is an equal and opposite expert. - Becker's Law


    My blog

    Wednesday, January 2, 2013 5:50 PM
  • Is it because it is impossible to create one or just because nobody has done it yet?

    Ken Cox - Microsoft MVP [ASP.NET]

    Wednesday, January 2, 2013 5:56 PM
  • Probably the latter. If you have AdventureWorks database installed in the normal SQL Server, try first making a backup and attempt to restore in CE version. If this fails, try creating a script (using option with data) and then try running that script in CE version and post errors if any.

    In other words, I think it may be done, but I don't know if anyone already tried it.


    For every expert, there is an equal and opposite expert. - Becker's Law


    My blog

    Wednesday, January 2, 2013 6:15 PM
  • There are a few differences between SQL Server and SQL Server CE so creating a backup and trying to restore to CE will probably not work.  Creating a script probably won't work either.

    The following blog post contains an AdventureWorks.sdf file however I'm not sure how it's schema compares with the fill version of AdventureWorks.

    http://geekswithblogs.net/Vishal/archive/2008/09/17/introduction-to-ado-.net-sync-services.aspx


    When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer

    Jeff Wharton
    MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCSD, MCITP, MCDBA
    Blog: Mr. Wharty's Ramblings
    Twitter: @Mr_Wharty
    MC ID: Microsoft Transcript

    Wednesday, January 2, 2013 10:09 PM
  • The following blog post contains an AdventureWorks.sdf file however I'm not sure how it's schema compares with the fill version of AdventureWorks.

    http://geekswithblogs.net/Vishal/archive/2008/09/17/introduction-to-ado-.net-sync-services.aspx 

    Thanks anyway, that only has three employee-related tables. I'm most interested in Products tables.

    Ken Cox - Microsoft MVP [ASP.NET]

    Thursday, January 3, 2013 4:14 AM
  • If you can post that script still or send it to me, I'd be grateful!

    EDIT: I thought my reply was on shawn434's post on getting the SQL-script from his instructor! Therefore, I was referring to the SQL-script that is part of the 10264A course, not the AdventureWorks-database references by Derrick VanArnam.

    • Edited by pjdevries Sunday, May 5, 2013 8:42 AM Edit needed for clarification in my request.
    Saturday, May 4, 2013 6:43 PM
  • I am using the download AdventureWorks databases for 2012, 2008R2 and 2008 as a learning tool to sharpen my self on the use of RDBS I built a server AMD 8CORE  16 GB ram and loadding the AdventureWorksDW2012 loads slow.

    (Question)

    Is there any way to speed up the process to opening the tables????


    alj

    Tuesday, July 15, 2014 3:50 PM
  • AdventureWorksLT

    https://www.google.com/?gws_rd=ssl#q=adventureworkslt+download&safe=off

            
                    
                    AWLTDocs

    AdventureWorksLT Database


    Introduction


    AdventureWorksLT is a new sample database based on the Adventure Works Cycles scenario.  See MSDN for more information about this scenario and the other sample databases which are available.

    The
    purpose of the AdventureWorksLT database is to provide a simple, small
    database sample focused on a product sales scenario. 

    You can find the schema diagram for AdventureWorksLT and the other sample databases here.

    AdventureWorksLT is simpler and smaller in the following ways:
    • The schema design is denormalized compared with AdventureWorks.
      To obtain useful information either requires no joins, or fewer joins
      compared with AdventureWorks.
    • The quantity of data is reduced from about 183mb down to 7mb which
      makes it more practical to download over slow or unreliable Internet
      connections.
    • Instead of 5 schemas plus dbo in the database,  AdventureWorksLT has one schema plus dbo in the database. 
    • Instead of 70 tables, AdventureWorksLT has 12 tables.


    AdventureWorksLT is specifically designed for developers and ITPros
    that are just starting to learn about relational database technology. 
    More advanced developers and ITPros who are developing enterprise-class
    applications should look at the AdventureWorks database.

    alj

    Tuesday, July 15, 2014 4:00 PM
  • This may be an old thread, but I am looking for the same answer in 2015. Here is the correct script on ANOTHER of Microsoft's hundreds of forum web sites:

    https://social.microsoft.com/Forums/en-US/5a2fe20d-56dd-4d49-9aeb-1c253a5f48e1/can-somebody-post-the-sqlscript-database-of-course-10264a?forum=CertGeneral


    • Edited by CigarDoug Wednesday, September 9, 2015 1:24 PM Forgot to make it a link.
    Wednesday, September 9, 2015 1:24 PM
  • Thanks for this .. 

    This is indeed an issue ..

    The version should be documented with the GitHub item but sometimes is not .. 

    Tuesday, November 27, 2018 11:30 PM