다음을 통해 공유

The AdventureWorks 2008 Family of Sample Databases

  • 아티클

There is a new AdventureWorks family of sample databases available for SQL Server 2008 February CTP at https://www.codeplex.com/Release/ProjectReleases.aspx?ProjectName=MSFTDBProdSamples.  The AdventureWorks 2008 family of databases demonstrates some of the new features of SQL Server 2008. This family of databases can only be used with SQL Server 2008 and will not install successfully for earlier versions of SQL Server.  The original AdventureWorks family continues to ship for SQL Server 2008, so you have a choice of staying with the compatible schema or trying out the new SQL Server 2008 features depending on which installers you download.  The installers for the AdventureWorks 2008 family all have 2008 in their names.  See the link above for additional details.

Right now most samples are compatible with the AdventureWorks family not the AdventureWorks 2008 family.  As samples are migrated to the new schema the readmes for the samples will be updated and sample and snippets scripts will have statements like USE AdventureWorks2008 in them instead of USE AdventureWorks.

Comments

  • Anonymous
    September 25, 2008
    The comment has been removed
  • Anonymous
    September 26, 2008
    The comment has been removed
  • Anonymous
    October 08, 2010
    Hi,I am looking for the database AdventureWorksDW2008.mdb  for my BI reporting purpose.Is there a free download link for this database warehouse?Patsy Farkaspatsyfarkas@hotmail.com
  • Anonymous
    October 20, 2010
    why does this install adventureworks as "adventureworks" and not "adventureworks2008"?
  • Anonymous
    November 15, 2011
    Why not provide a script that creates the tables and insert statements that insert the data??????
  • Anonymous
    July 01, 2012
    Hi there:I realise that your post was made a few months ago, but, if you're still battling with the mdf files that are ready to be downloaded, perhaps your next option is to try a script.  There is a download direct from Microsoft that contains data in csv format plus a script to create a database and import those csv files into sql studio express.  This is what helped me not waste any more time with other people's mdf files..  One day i wll try to find out why they didnt work..In the codeplex website, search for 'Installing Sample Databases' - scroll down until you find 2008. Unzip the file.Read the instructions, but normally you should run sql express as administrator and, when you open the  script,make sure that you run it in SQLCMD mode.I would recommend keeping a  clean copy of the script as well as a copy with the modifications that you make.You might also find that you get a few errors along the way, but this is all part of learning..Just be prepared to delete the newly created database after each error, because the script will create a database even if errors occur but the tables will be empty.Change all the paths from the generic word to the actual path that you want to put your data files into.There should be the script.I have discovered, after wasting days, that you just have to be so patient, especially as more people seem to have lots of questions (such as myself) than those who do have all the answers..Good luck
  • Anonymous
    March 11, 2013
    The comment has been removed