Chinook Database 1.3

Rating:        Based on 2 ratings
Reviewed:  2 reviews
Downloads: 15018
Change Set: 39725e1519f2
Released: Nov 14, 2010
Updated: Nov 19, 2010 by lerocha
Dev status: Stable Help Icon

Recommended Download

Application ChinookDatabase1.3_CompleteVersion.zip
application, 3517K, uploaded Nov 15, 2010 - 7014 downloads

Other Available Downloads

Application ChinookDatabase1.3_EffiProz.zip
application, 316K, uploaded Nov 15, 2010 - 120 downloads
Application ChinookDatabase1.3_MySql.zip
application, 313K, uploaded Nov 15, 2010 - 360 downloads
Application ChinookDatabase1.3_Oracle.zip
application, 163K, uploaded Nov 15, 2010 - 190 downloads
Application ChinookDatabase1.3_Sqlite.zip
application, 985K, uploaded Nov 15, 2010 - 5818 downloads
Application ChinookDatabase1.3_SqlServer.zip
application, 376K, uploaded Nov 15, 2010 - 1240 downloads
Application ChinookDatabase1.3_SqlServerCompact.zip
application, 1131K, uploaded Nov 15, 2010 - 276 downloads

Release Notes

  • This is a sample database available in multiple formats: SQL scripts for multiple database vendors, embeded database files, and XML format.
  • The Chinook data model is available here.
  • ChinookDatabase1.3_CompleteVersion.zip is a complete package for all supported databases/data sources. There are also packages for each specific data source.

Issues Resolved

Supported Database Servers

Installation

Package Content

This is the list of files included in the complete version.
Data Source File Description
EffiProz Chinook_EffiProz.sql SQL script to create the Chinook database. Primary keys are not auto incremented by the database system, they must be set when inserting records.
EffiProz Chinook_EffiProz_AutoIncrementPKs.sql SQL script to create the Chinook database. Primary keys are auto incremented.
MySql Chinook_MySql.sql SQL script to create the Chinook database. Primary keys are not auto incremented by the database system, they must be set when inserting records.
MySql Chinook_MySql_AutoIncrementPKs.sql SQL script to create the Chinook database. Primary keys are auto incremented.
MySql CreateMySql.bat Batch file to create the Chinook database.
Oracle Chinook_Oracle.sql SQL script to create the Chinook database. Primary keys are not auto incremented by the database system, they must be set when inserting records.
Oracle CreateOracle.bat Batch file to create the Chinook database.
Sqlite Chinook_Sqlite.sql SQL script to create the Chinook database. Primary keys are not auto incremented by the database system, they must be set when inserting records.
Sqlite Chinook_Sqlite.sqlite Chinook database file. Primary keys are not auto incremented by the database system, they must be set when inserting records.
Sqlite Chinook_Sqlite_AutoIncrementPKs.sql SQL script to create the Chinook database. Primary keys are auto incremented.
Sqlite Chinook_Sqlite_AutoIncrementPKs.sqlite Chinook database file. Primary keys are auto incremented.
Sqlite CreateSqlite.bat Batch file to create the Chinook database.
SqlServer Chinook_SqlServer.sql SQL script to create the Chinook database. Primary keys are not auto incremented by the database system, they must be set when inserting records.
SqlServer Chinook_SqlServer_AutoIncrementPKs.sql SQL script to create the Chinook database. Primary keys are auto incremented.
SqlServer CreateSqlServer.bat Batch file to create the Chinook database.
SqlServerCompact Chinook_SqlServerCompact.sqlce SQL script to create the Chinook database. Primary keys are not auto incremented by the database system, they must be set when inserting records.
SqlServerCompact Chinook_SqlServerCompact.sdf Chinook database file. Primary keys are not auto incremented by the database system, they must be set when inserting records.
SqlServerCompact Chinook_SqlServerCompact_AutoIncrementPKs.sqlce SQL script to create the Chinook database. Primary keys are auto incremented.
SqlServerCompact Chinook_SqlServerCompact_AutoIncrementPKs.sdf Chinook database file. Primary keys are auto incremented.
XML ChinookData.xml XML data used to generate the Chinook database SQL scripts.

Reviews for this release

     
Thank you, being able to use the same sample database on different backends sure makes my life easier. Hope to see support for PostgreSQL and DB2 in the future.
by BriceLambson on Oct 18, 2012 at 10:11 PM
     
Outstanding and relevant sample database!
by ErikEJ on Oct 24, 2011 at 11:17 AM