This post is out of date. The download links and the steps below belong to an older version of SQL Server. I keep one current guide for both sample databases, and I update that one instead of this page.
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
Still need to install these databases? Everything above is kept for the record. The steps that work today, the current download links and the errors people actually hit are all on one page, and that is the page I keep up to date.
Published by Pinal Dave on SQLAuthority. More of my work at pinaldave.com.
Discover more from SQL Authority with Pinal Dave
Subscribe to get the latest posts sent to your email.
3 Comments. Leave new
Instead of creating number of repor (.rdl) is there any way to generate the report using dynamic parameter ,data set and fields
Example : In entry project i will create only one report (table format) , But different store procedure based on dataset , number of columns report should generate
Error messages:
Source: mscorlib
Target Site: Void WinIOError(Int32, System.String)
Message: Access to the path ‘G:\SQL2012_FILES\MSSQL11.MSSQLSERVER\MSSQL\ReplData\unc\KAUSHIK-PC_DB_REPLICATION_REPLI_PUB\20160810205346\’ is denied.
Stack: at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.Directory.InternalCreateDirectory(String fullPath, String path, DirectorySecurity dirSecurity)
at System.IO.Directory.CreateDirectory(String path, DirectorySecurity directorySecurity)
at Microsoft.SqlServer.Replication.Utilities.CreateDirectoryWithExtendedErrorInformation(String directory)
at Microsoft.SqlServer.Replication.Snapshot.SnapshotProvider.CreateSnapshotFolders()
at Microsoft.SqlServer.Replication.Snapshot.SqlServerSnapshotProvider.GenerateSnapshot()
at Microsoft.SqlServer.Replication.SnapshotGenerationAgent.InternalRun()
at Microsoft.SqlServer.Replication.AgentCore.Run() (Source: mscorlib, Error number: 0)
Can we upgrade to SQL Server 2016 now, or should we wait for SP1? We are currently in SQL Server 2008r2.