Chinook Database 1.0

Rating:        Based on 1 rating
Reviewed:  1 review
Downloads: 541
Released: Aug 17, 2008
Updated: Nov 22, 2008 by lerocha
Dev status: Stable Help Icon

Recommended Download

Application ChinookDatabase1.0.zip
application, 522K, uploaded Aug 17, 2008 - 541 downloads

Release Notes

This is a sample database available for SQL Server, Oracle and MySQL. It can be created by running a single SQL script. You can see the Chinook database schema here.

The zip file above contains SQL scripts and batch files for each database supported. It also contains the data in XML format (DataSet), see SampleData\ChinookData.xml.

Supported Database Servers

  • SQL Server
  • Oracle
  • MySQL

How do I Create the Chinook Database?

Download and extract the zip file above. Under the Script folder, there are two files per database server: a SQL script, CreateDB.sql, and a batch file, CreateDB.bat. You can either run the SQL script by using your preferred database tool or run the provided batch file.

The batch files use the database server command tool (mysql.exe, osql.exe for SQL Server, and sqlplus.exe for Oracle). If you are using Windows Vista, you should open a Command Prompt window as Administrator in order to run these batch files.

Notes for MySQL Version

  • The provided script was tested using MySQL Server 5.0.
  • The CreateDB.bat file uses the localhost server, and the root user with the password p4ssw0rd. Change this file to match your settings before running it.

Notes for Oracle Version

  • The provided script was tested using Oracle Database 10g Express Edition (XE).
  • The CreateDB.sql creates a new user chinook, with the password p4ssw0rd. Change this script if you want a different user/password.

Notes for SQL Server Version

  • The provided script was tested using SQL Server Express which ships with Visual Studio 2008.

Reviews for this release

     
I tried to install AdventureWorks for SQL Server Express without much success. Chinook installed without a hitch! Thank you for providing this sample db available for SS Express 2008.
by chiponium on Nov 21, 2008 at 3:00 PM