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

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.

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.

Sam Lester (MSFT)



Comments (11)

  1. Keiran Grogan says:

    Paragraph ” And hello World Wide Importers! ” requires amending.

    The Name of the New Database is WIDE WORLD not WORLD WIDE !!

    1. Hi Keiran, thanks for letting me know. I’ve made the correction.

    2. Randy Worrell says:

      Nit-picker… 😉

      1. Aaron Reese says:

        We are DBAs picking nits is in the job description 🙂

    1. Thanks for sharing the link to the 2017 version.

  2. Hold on, what?! Is northwind also getting the axe? 🙂

    1. Josh, the Northwind and pubs databases will live forever in our hearts, even if development stopped years ago. 🙂

  3. Chady Oweiti says:

    Where can i find exercises and questions on this new database?

    Thank you

    1. 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.


Skip to main content