New GitHub location for AdventureWorks

Published Mar 23 2019 05:10 PM 824 Views
Microsoft
First published on MSDN on Nov 16, 2017

AdventureWorks has long been one of the most used database samples to run demos. Its downloads and scripts are now available in the SQL Server Samples repository in GitHub . If you have the download links in any of your scripts or automations, please update links to use the new download location .

With this, the Codeplex repository will be archived to read-only at the end of November. We left the AdventureWorks files intact on Codeplex so we wouldn’t break existing links. But, we ask everyone to start using the new GitHub location going forward.

The downloads and scripts on GitHub have these improvements:

  • The AdventureWorks and AdventureWorksDW install scripts work on any version of SQL Server. Each script auto-generates the right database compatibility to match the current SQL Server instance. This means you can quickly install either database on any release of SQL Server including CTPs, SPs, and any interim release.
  • The AdventureWorks download page lists all the .bak files for each SQL Server version, including SQL Server 2016 and SQL Server 2017.
  • The SQL Server 2016 CTP3 sample databases are published on the site as .bak files and renamed to AdventureWorks2016_EXT and AdventureWorksDW2016_EXT.

Please try out the new downloads and scripts. If you have any issues or comments, please send feedback via this blog, or in GitHub.

%3CLINGO-SUB%20id%3D%22lingo-sub-385728%22%20slang%3D%22en-US%22%3ENew%20GitHub%20location%20for%20AdventureWorks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-385728%22%20slang%3D%22en-US%22%3E%0A%20%26lt%3Bmeta%20http-equiv%3D%22Content-Type%22%20content%3D%22text%2Fhtml%3B%20charset%3DUTF-8%22%20%2F%26gt%3B%3CSTRONG%3E%20First%20published%20on%20MSDN%20on%20Nov%2016%2C%202017%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3E%3CP%3EAdventureWorks%20has%20long%20been%20one%20of%20the%20most%20used%20database%20samples%20to%20run%20demos.%20Its%20downloads%20and%20scripts%20are%20now%20available%20in%20the%20SQL%20Server%20Samples%20repository%20in%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2Fsql-server-samples%2Freleases%2Ftag%2Fadventureworks%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EGitHub%20%3C%2FA%3E.%20If%20you%20have%20the%20download%20links%20in%20any%20of%20your%20scripts%20or%20automations%2C%20please%20update%20links%20to%20use%20the%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2Fsql-server-samples%2Freleases%2Ftag%2Fadventureworks%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Enew%20download%20location%20%3C%2FA%3E.%3C%2FP%3E%0A%20%20%3CP%3EWith%20this%2C%20the%20%3CA%20href%3D%22https%3A%2F%2Fmsftdbprodsamples.codeplex.com%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3ECodeplex%20%3C%2FA%3Erepository%20will%20be%20archived%20to%20read-only%20at%20the%20end%20of%20November.%20We%20left%20the%20AdventureWorks%20files%20intact%20on%20Codeplex%20so%20we%20wouldn%E2%80%99t%20break%20existing%20links.%20But%2C%20we%20ask%20everyone%20to%20start%20using%20the%20new%20GitHub%20location%20going%20forward.%3C%2FP%3E%0A%20%20%3CP%3EThe%20downloads%20and%20scripts%20on%20GitHub%20have%20these%20improvements%3A%3C%2FP%3E%0A%20%20%3CUL%3E%0A%20%20%20%3CLI%3EThe%20AdventureWorks%20and%20AdventureWorksDW%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2Fsql-server-samples%2Ftree%2Fmaster%2Fsamples%2Fdatabases%2Fadventure-works%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Einstall%20scripts%20%3C%2FA%3Ework%20on%20any%20version%20of%20SQL%20Server.%20Each%20script%20auto-generates%20the%20right%20database%20compatibility%20to%20match%20the%20current%20SQL%20Server%20instance.%20This%20means%20you%20can%20quickly%20install%20either%20database%20on%20any%20release%20of%20SQL%20Server%20including%20CTPs%2C%20SPs%2C%20and%20any%20interim%20release.%3C%2FLI%3E%0A%20%20%20%3CLI%3EThe%20AdventureWorks%20download%20page%20lists%20all%20the%20.bak%20files%20for%20each%20SQL%20Server%20version%2C%20including%20SQL%20Server%202016%20and%20SQL%20Server%202017.%3C%2FLI%3E%0A%20%20%20%3CLI%3EThe%20SQL%20Server%202016%20CTP3%20sample%20databases%20are%20published%20on%20the%20site%20as%20.bak%20files%20and%20renamed%20to%20AdventureWorks2016_EXT%20and%20AdventureWorksDW2016_EXT.%3C%2FLI%3E%0A%20%20%3C%2FUL%3E%0A%20%20%3CP%3EPlease%20try%20out%20the%20new%20downloads%20and%20scripts.%20If%20you%20have%20any%20issues%20or%20comments%2C%20please%20send%20feedback%20via%20this%20blog%2C%20or%20in%20GitHub.%3C%2FP%3E%0A%20%0A%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-385728%22%20slang%3D%22en-US%22%3EFirst%20published%20on%20MSDN%20on%20Nov%2016%2C%202017%20AdventureWorks%20has%20long%20been%20one%20of%20the%20most%20used%20database%20samples%20to%20run%20demos.%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-385728%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESQLReleases%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Version history
Last update:
‎Mar 23 2019 05:10 PM
Updated by: