Skip to content

pre-release for the wide-world-importers sample database

Pre-release
Pre-release
Compare
Choose a tag to compare
@jodebrui jodebrui released this 06 Jun 19:57
· 3598 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 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 (or higher) Evaluation/Developer/Enterprise Edition.
    • WideWorldImportersDW-Full.bak - full sample database for OLAP (OnLine Analytical Processing). For SQL Server 2016 (or higher) Evaluation/Developer/Enterprise Edition.
  • SQL Server Standard Edition
  • Azure SQL Database
  • 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.
  • 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).

Note that this release does not yet include bacpac versions of the full versions of the databases. This is due some SQL Server 2016 functionality not yet being available in Azure DB. The functionality should be available soon, at which point a new version of the sample will be released including bacpac versions of all the databases.

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