Freigeben über

So long AdventureWorks, we'll miss you! (And hello Wide World Importers!)

  • Artikel

So long AdventureWorks, we'll miss you!

It's the end of an era for the SQL Server sample database AdventureWorks as development has been suspended for the popular sample database following the release of SQL Server 2016. Many of us have used this sample database to learn constructs and features of the product since its introduction in SQL Server 2005, but it is time to move on.

And hello Wide World Importers!

With the release of SQL Server 2016, Microsoft has released an enhanced and improved sample database targeting SQL Server 2016 and Azure Database called Wide World Importers.

https://github.com/Microsoft/sql-server-samples/releases/tag/wide-world-importers-v1.0

Can I still use AdventureWorks with SQL Server 2016?

Yes, the final AdventureWorks build will be updated on the official download site here and you can still use AdventureWorks with your SQL Server 2016 instance.

What about future development with Microsoft sample databases?

If you already have samples using AdventureWorks, there is no need to update them to use Wide World Importers. However, any future development on Microsoft sample databases should use Wide World Importers instead of AdventureWorks since it will not be updated or maintained after 2016.

Thanks,
Sam Lester (MSFT)

Comments

  • Anonymous
    November 03, 2016
    Paragraph " And hello World Wide Importers! " requires amending.The Name of the New Database is WIDE WORLD not WORLD WIDE !!
    • Anonymous
      November 03, 2016
      Hi Keiran, thanks for letting me know. I've made the correction.
    • Anonymous
      December 31, 2016
      Nit-picker... ;-)
      • Anonymous
        April 03, 2017
        The comment has been removed
        • Anonymous
          October 03, 2017
          Absolutely!
  • Anonymous
    November 03, 2017
    2017 AdventureWorks is there,https://github.com/Microsoft/sql-server-samples/releases/tag/adventureworks
    • Anonymous
      November 08, 2017
      Thanks for sharing the link to the 2017 version.
  • Anonymous
    January 31, 2018
    Hold on, what?! Is northwind also getting the axe? :)
    • Anonymous
      February 01, 2018
      Josh, the Northwind and pubs databases will live forever in our hearts, even if development stopped years ago. :)
  • Anonymous
    March 22, 2018
    Hello, Where can i find exercises and questions on this new database?Thank you
    • Anonymous
      March 27, 2018
      Hi Chady, that's a great question. I haven't encountered any exercises/questions on the Wide World Importers DB yet, but will update this thread if I come across them.Thanks,Sam