Chinook Database 1.2

Rating: No reviews yet
Downloads: 387
Change Set: 286bc0a41c56
Released: Nov 5, 2010
Updated: Nov 14, 2010 by lerocha
Dev status: Stable Help Icon

Recommended Download

Application ChinookDatabase1.2.zip
application, 2186K, uploaded Nov 6, 2010 - 387 downloads

Release Notes

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

Issues Resolved

Supported Database Servers

  • MySQL
  • Oracle
  • SQL Server
  • SQL Server Compact

Installation

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

An alternate SQL script is provided if you do not want the primary key to be automatically generated, see Create...NoIdentity.sql (SQL Server and SQL Server Compact) and Create...NoAutoIncrement.sql (MySQL).

The batch files use the database server command tool (mysql.exe for MySQL, sqlcmd.exe for SQL Server, and sqlplus.exe for Oracle). If you are using Windows Vista/2008/7, it is recommended to open a Command Prompt window as Administrator in order to run these batch files.

For SQL Server Compact, we included the compact databases .sdf. If you prefer to create your own compact database, then you can use its CreateTables.sqlce script.

For more information:

Package Content

The Chinook database is provided as a SQL scripts and also in XML format, see XML\ChinookData.xml, and SQL Server Compact databases (.sdf) under SqlServerCompact. The following table describes the contents of this package.

Folder File Description
MySql create.bat Batch file that uses mysql.exe to create the Chinook database using CreateDB.sql.
MySql CreateDB.sql SQL script to create the Chinook database using primary keys with AutoIncrement (PKs are auto-generated).
MySql CreateDB_NoAutoIncrement.sql An alternate version that does not use PKs with AutoIncrement. You will need to explicity set PKs values when inserting records.
Oracle create.bat Batch file that uses sqlplus.exe to create the Chinook database using CreateDB.sql.
Oracle CreateDB.sql SQL script to create and populate the Chinook database.
SqlServer create.bat Batch file that uses sqlcmd.exe to create and populate the Chinook database using CreateDB.sql
SqlServer CreateDB.sql SQL script to create and populate the Chinook database using primary keys with IDENTITY (PKs are auto-generated)
SqlServer CreateDB NoIdentity.sql An alternate version that does not use PKs with IDENTITY. You will need to explicity set PKs values when inserting records.
SqlServerCompact CreateTables.sqlce SQL script to create and populate the Chinook tables using primary keys with IDENTITY (PKs are auto-generated)
SqlServerCompact CreateTables NoIdentity.sqlce An alternate version that does not use PKs with IDENTITY. You will need to explicity set PKs values when inserting records.
SqlServerCompact Chinook.sdf A SQL Server Compact 3.5 database created using CreateTables.sqlce
SqlServerCompact Chinook NoIdentity.sdf A SQL Server Compact 3.5 database created using CreateTables_NoIdentity.sqlce
SqlServerCompact DropTables.sqlce SQL script to drop all tables of the Chinook database.
Xml ChinookData.xml An XML version of the Chinook database used to create the SQL scripts above.

Reviews for this release

No reviews yet for this release.