Skip to content

Wide World Importers sample database v1.0

Compare
Choose a tag to compare
@jodebrui jodebrui released this 08 Jun 19:25
· 3424 commits to master since this release

WideWorldImporters sample database for SQL Server (starting 2016) and Azure SQL Database. For details see the corresponding documentation.

This release includes the following artifacts:

  • SQL Server 2016 SP1 (or later) Any Edition aside from LocalDB; SQL Server 2016 RTM (or later) Evaluation/Developer/Enterprise Edition
    • WideWorldImporters-Full.bak - full sample database for OLTP (OnLine Transaction Processing) and HTAP (hybrid transaction and analytical processing aka real-time operational analytics). For SQL Server 2016 SP1 (or higher), any edition.
      • Update (8/12/2016): updated stats on system tables to support efficient reverse engineering with Entity Framework
    • WideWorldImportersDW-Full.bak - full sample database for OLAP (OnLine Analytical Processing). For SQL Server 2016 SP1 (or higher), any edition.
    • Hardware requirements: installing both databases requires 10GB of available disk space, and 1.5GB of available memory for SQL Server.
  • Azure SQL Database Premium tier
  • Azure SQL Database Standard tier
  • SQL Server Integration Services
    • Daily.ETL.ispac - SSIS package for ETL from the OLTP to the OLAP database. Works for both the Full and the Standard versions of the databases.
      • Update (8/12/2016): removed encryption from the package to allow running in more environments
  • sample-scripts.zip - sample scripts illustrating the use of various SQL Server features in the WideWorldImporters sample databases.
  • workload-drivers.zip - sample workloads for the WideWorldImporters sample databases. These are Windows Form applications that will only run on Windows (in this release).
  • (legacy) SQL Server 2016 RTM Standard Edition and SP1 LocalDB
    • Consider upgrading to SP1 and installing the Full version of the sample on your SQL Server Express or Standard edition instance.
    • WideWorldImporters-Standard.bak - standard edition OLTP sample database in backup format. For SQL Server 2016 RTM Standard Edition.
      • Update (8/15/2016): updated stats on system tables to support efficient reverse engineering with Entity Framework
    • WideWorldImportersDW-Standard.bak - standard edition OLAP sample database in backup format. For SQL Server 2016 RTM Standard Edition.

Update (11/16/2016): Included bacpac format for the full versions of the sample databases, for use with Azure SQL Databases in the Premium tier.

The source code included with this release includes the source code for the entire samples repository, not just the wide-world-importers sample.