I have been a very loyal user to sample database AdventureWorks for a while, I really liked the overall database. However, as we know SQL Server releases, new features every year and along with the new features there is always need for a new Sample Database which contains all the necessary data and schema to demonstrate new features of the SQL Server. The SQL Server team has recently released a new sample database WideWorldImporters which can be used to demonstrate new features of the SQL Server.
Personally, I would have preferred that team would have an enhanced AdventureWorks database to accommodate the new features, but I am sure there would be some reason for coming up for entirely new sample database. It will take a while before we can all wrap our head around this sample database.
I have received quite a few requests to write about how to install this new sample database as it is not as simple as installing AdventureWorks due to the new features. I have created a quick video about the same, where I demonstrate how quickly we can install SQL Server 2016 sample database WideWorldImporters.
In this short video we will see how we can install SQL Server 2016 sample database WideWorldImporters.
Here are a few important links:
- Download Sample Database and Script from Video
- Download SQL Server 2016 Developer Edition for FREE
- Install SQL Server 2016 Management Studio
Reference: Pinal Dave (https://blog.sqlauthority.com)