ChinookDatabase Wiki & Documentation Rss Feed

Updated Wiki: Home

lerocha — Mon, 05 Jan 2009 06:13:51 GMT

Project Description

Chinook is a sample database available for SQL Server, Oracle and MySQL. It can be created by running a single SQL script. Chinook database is an alternative to the Northwind database, being ideal for demos and testing ORM tools targeting single and multiple database servers.

What is New?

Version 1.1 has been released! This new version includes support for SQL Server Compact, a new many-to-many relationship (Playlists/Tracks), and additional customer data from multiple countries. For more information and download, see Chinook Database 1.1.

Supported Database Servers

SQL Server
SQL Server Compact
Oracle
MySQL

Database Schema

The Chinook database schema represents a digital media store, including tables for artists, albums, media tracks, invoices and customers. You can see the Chinook database schema here.

Sample Data

Media related data was created using real data from an iTunes Library. It is possible for you to use your own iTunes Library to generate the SQL scripts, see instructions here.
Customer and employee information was manually created using fictitious names, addresses that can be located on Google maps, and other well formatted data (phone, fax, email, etc.).
Sales information is auto generated using random data for a four year period.

Why the name Chinook?

The name of this sample database was based on the Northwind database. Chinooks are winds in the interior West of North America, where the Canadian Prairies and Great Plains meet various mountain ranges. Chinooks are most prevalent over southern Alberta in Canada. Chinook is a good name choice for a database that intents to be an alternative to Northwind.

Updated Wiki: Chinook_Schema

lerocha — Mon, 05 Jan 2009 04:04:28 GMT

Chinook Database Schema 1.1 (Current Release)

Chinook Database Schema 1.0

Updated Wiki: Home

lerocha — Mon, 05 Jan 2009 04:01:44 GMT

Project Description

What is New?

Supported Database Servers

SQL Server
SQL Server Compact
Oracle
MySQL

Database Schema

The Chinook database schema represents a digital media store, including tables for artists, albums, media tracks, invoices and customers. You can see the Chinook database schema here.

Sample Data

Media related data was created using real data from an iTunes Library. It is possible for you to use your own iTunes Library to generate the SQL scripts, see instructions here.
Customer and employee information was manually created using fictitious names, addresses that can be located on Google maps, and other well formatted data (phone, fax, email, etc.).
Sales information is auto generated using random data for a four year period.

Why the name Chinook?

Updated Wiki: Home

lerocha — Mon, 05 Jan 2009 04:00:37 GMT

Project Description

What is New?

Supported Database Servers

SQL Server
SQL Server Compact
Oracle
MySQL

Database Schema

The Chinook database schema represents a digital media store, including tables for artists, albums, media tracks, invoices and customers. You can see the Chinook database schema here.

Sample Data

Media related data was created using real data from an iTunes Library. It is possible for you to use your own iTunes Library to generate the SQL scripts, see instructions here.
Customer and employee information was manually created using fictitious names, addresses that can be located on Google maps, and other well formatted data (phone, fax, email, etc.).
Sales information is auto generated using random data for a four year period.

Why the name Chinook?

Updated Wiki: Home

lerocha — Mon, 05 Jan 2009 03:55:57 GMT

Project Description

What is New?

Supported Database Servers

SQL Server
SQL Server Compact
Oracle
MySQL

Database Schema

The Chinook database schema represents a digital media store, including tables for artists, albums, media tracks, invoices and customers. You can see the Chinook database schema here.

Sample Data

Media related data was created using real data from an iTunes Library. It is possible for you to use your own iTunes Library to generate the SQL scripts, see instructions here.
Customer and employee information was manually created using fictitious names, addresses that can be located on Google maps, and other well formatted data (phone, fax, email, etc.).
Sales information is auto generated using random data for a four year period.

Why the name Chinook?

Updated Wiki: Chinook_Schema

lerocha — Mon, 05 Jan 2009 00:12:27 GMT

Chinook Database Schema 1.1 (Upcoming Release)

Chinook Database Schema 1.0 (Current Release)

Updated Wiki: Building_Scripts

lerocha — Sun, 04 Jan 2009 08:31:21 GMT

Generating SQL scripts for the Chinook Database

Required Tools

Microsoft Visual Studio 2008

Database Servers

SQL Server Express (already installed with Visual Studio).
Oracle Database 10g Express Edition (XE).
MySQL 5.1 Community Server: Choose all default settings when installing, but on the MySQL Server Instance installer make sure to select:

Best Support For Multilingualism
Include Bin Directory in Windows PATH

MySQL Connector/Net 5.2

Instructions

Download the latest source code from here.
Open the Solution file ChinookDatabase.sln in Visual Studio.
If you want to use the data from your own iTunes library, then replace the file SampleData\iTunes Music Library.xml with your version.
Verify that your database servers are properly set:

The batch file Scripts\MySql\CreateDB.bat uses the root user with the password p4ssw0rd. Change this file to match your settings before running CreateAll.bat.
The T4 template Scripts\Oracle\CreateDB.tt generates a SQL script which creates a new user chinook, with the password p4ssw0rd. Change this T4 template file if you want to use a different user/password.
In app.config, verify that the connection strings are matching any changes you made to username/password above. Also, the Oracle connection string uses the Express Edition, e.g. Data Source=xe. So, change it if you are using a different Oracle edition.

On the Solution Explorer, click on your Solution and then click on the Transform All Templates button at the Solution Explorer buttons bar.
Rebuild the solution.
Run the Scripts\CreateAll.bat batch file to create all databases (see Notes below).
Run all unit tests to make sure the databases were created properly.

Updated Wiki: Building_Scripts

lerocha — Tue, 30 Dec 2008 07:16:48 GMT

Generating SQL scripts for the Chinook Database

Required Tools

Microsoft Visual Studio 2008

Database Servers

SQL Server Express (already installed with Visual Studio).
Oracle Database 10g Express Edition (XE).
MySQL 5.1 Community Server: Choose all default settings when installing, but on the MySQL Server Instance installer, check the option to Include Bin Directory in Windows PATH.
MySQL Connector/Net 5.2

Instructions

Download the latest source code from here.
Open the Solution file ChinookDatabase.sln in Visual Studio.
If you want to use the data from your own iTunes library, then replace the file SampleData\iTunes Music Library.xml with your version.
Verify that your database servers are properly set:

The batch file Scripts\MySql\CreateDB.bat uses the root user with the password p4ssw0rd. Change this file to match your settings before running CreateAll.bat.
The T4 template Scripts\Oracle\CreateDB.tt generates a SQL script which creates a new user chinook, with the password p4ssw0rd. Change this T4 template file if you want to use a different user/password.
In app.config, verify that the connection strings are matching any changes you made to username/password above. Also, the Oracle connection string uses the Express Edition, e.g. Data Source=xe. So, change it if you are using a different Oracle edition.

On the Solution Explorer, click on your Solution and then click on the Transform All Templates button at the Solution Explorer buttons bar.
Rebuild the solution.
Run the Scripts\CreateAll.bat batch file to create all databases (see Notes below).
Run all unit tests to make sure the databases were created properly.

Updated Wiki: Chinook_Schema

lerocha — Mon, 29 Dec 2008 19:13:03 GMT

Chinook Database Schema 1.1 (Upcoming Release)

Chinook Database Schema 1.0 (Current Release)

Updated Wiki: Building_Scripts

lerocha — Mon, 18 Aug 2008 06:46:10 GMT

Generating SQL scripts for the Chinook Database

Required Tools

Microsoft Visual Studio 2008

Database Servers

SQL Server Express (already installed with Visual Studio).
Oracle Database 10g Express Edition (XE).
MySQL 5.0 Community Server: Choose all default settings when installing, but on the MySQL Server Instance installer, check the option to Include Bin Directory in Windows PATH.
MySQL Connector/Net 5.1

Instructions

Download the latest source code from here.
Open the Solution file ChinookDatabase.sln in Visual Studio.
If you want to use the data from your own iTunes library, then replace the file SampleData\iTunes Music Library.xml with your version.
Verify that your database servers are properly set:

The batch file Scripts\MySql\CreateDB.bat uses the root user with the password p4ssw0rd. Change this file to match your settings before running CreateAll.bat.
The T4 template Scripts\Oracle\CreateDB.tt generates a SQL script which creates a new user chinook, with the password p4ssw0rd. Change this T4 template file if you want to use a different user/password.
In app.config, verify that the connection strings are matching any changes you made to username/password above. Also, the Oracle connection string uses the Express Edition, e.g. Data Source=xe. So, change it if you are using a different Oracle edition.

On the Solution Explorer, click on your Solution and then click on the Transform All Templates button at the Solution Explorer buttons bar.
Rebuild the solution.
Run the Scripts\CreateAll.bat batch file to create all databases (see Notes below).
Run all unit tests to make sure the databases were created properly.

Updated Wiki: Building_Scripts

lerocha — Mon, 18 Aug 2008 06:40:21 GMT

Generating SQL scripts for the Chinook Database

Required Tools

Microsoft Visual Studio 2008

Database Servers

SQL Server Express (already installed with Visual Studio).
Oracle Database 10g Express Edition (XE).
MySQL 5.0 Community Server: Choose all default settings when installing, but on the MySQL Server Instance installer, check the option to Include Bin Directory in Windows PATH.
MySQL Connector/Net 5.1

Instructions

Download the latest source code from here.
Open the Solution file ChinookDatabase.sln in Visual Studio.
If you want to use the data from your own iTunes library, then replace the file SampleData\iTunes Music Library.xml with your version.
On the Solution Explorer, click on your Solution and then click on the Transform All Templates button at the Solution Explorer buttons bar.
Rebuild the solution.
Run the Scripts\CreateAll.bat batch file to create all databases (see Notes below).
Run all unit tests to make sure the databases were created properly.

Notes

The batch file Scripts\MySql\CreateDB.bat uses the root user with the password p4ssw0rd. Change this file to match your settings before running CreateAll.bat.
The SQL script Scripts\Oracle\CreateDB.sql creates a new user chinook, with the password p4ssw0rd. Change this script if you want a different user/password.
In app.config, verify that the connection strings are matching any changes you made to username/password. Also, the Oracle connection string uses the Express Edition, e.g. Data Source=xe. So, change it if you are using a different Oracle edition.

Updated Wiki: Building_Scripts

lerocha — Mon, 18 Aug 2008 06:17:34 GMT

Generating SQL scripts for the Chinook Database

Required Tools

Microsoft Visual Studio 2008

Database Servers

SQL Server Express (already installed with Visual Studio).
Oracle Database 10g Express Edition (XE).
MySQL 5.0 Community Server: Choose all default settings when installing, but on the MySQL Server Instance installer, check the option to Include Bin Directory in Windows PATH.
MySQL Connector/Net 5.1

Instructions

Download the latest source code from here.
Open the Solution file ChinookDatabase.sln in Visual Studio.
If you want to use the data from your own iTunes library, then replace the file SampleData\iTunes Music Library.xml with your version.
On the Solution Explorer, click on your Solution and then click on the Transform All Templates button at the Solution Explorer buttons bar.
Rebuild the solution.
Run the Scripts\CreateAll.bat batch file to create all databases.
Run all unit tests to make sure the databases were created properly.

Updated Wiki: Building_Scripts

lerocha — Mon, 18 Aug 2008 06:14:09 GMT

Generating the SQL scripts for the Chinook Database

Required Tools

Microsoft Visual Studio 2008

Database Servers

SQL Server Express (already installed with Visual Studio).
Oracle Database 10g Express Edition (XE).
MySQL 5.0 Community Server: Choose all default settings when installing, but on the MySQL Server Instance installer, check the option to Include Bin Directory in Windows PATH.
MySQL Connector/Net 5.1

Instructions

Download the latest source code from here.
Open the Solution file ChinookDatabase.sln in Visual Studio.
If you want to use the data from your own iTunes library, then replace the file SampleData\iTunes Music Library.xml with your version.
On the Solution Explorer, click on your Solution and then click on the Transform All Templates button at the Solution Explorer buttons bar.
Rebuild the solution.
Run the Scripts\CreateAll.bat batch file to create all databases.
Run all unit tests.

Updated Wiki: Building_Scripts

lerocha — Mon, 18 Aug 2008 03:08:04 GMT

Required Tools

Microsoft Visual Studio 2008

Database Servers

SQL Server Express (already installed with Visual Studio).
Oracle Database 10g Express Edition (XE).
MySQL 5.0 Community Server: Choose all default settings when installing, but on the MySQL Server Instance installer, check the option to Include Bin Directory in Windows PATH.
MySQL Connector/Net 5.1

Instructions

Download the latest source code from here.
Open the Solution file ChinookDatabase.sln in Visual Studio.
If you want to use the data from your own iTunes library, then replace the file SampleData\iTunes Music Library.xml with your version.
On Solution Explorer, click on your Solution and then click on the Transform All Templates button at the Solution Explorer buttons bar.
Rebuild the solution.
Run the Scripts\CreateAll.bat batch file to create all databases.
Run all unit tests.

Updated Wiki: Building_Scripts

lerocha — Mon, 18 Aug 2008 03:06:16 GMT

Required Tools

Microsoft Visual Studio 2008

Database Servers

SQL Server Express (already installed with Visual Studio).
Oracle Database 10g Express Edition (XE).
MySQL 5.0 Community Server: Choose all default settings when installing, but on the MySQL Server Instance installer, check the option to Include Bin Directory in Windows PATH.
MySQL Connector/Net 5.1

Instructions

Download the latest source code from here.
Open the Solution file ChinookDatabase.sln in Visual Studio.
If you want to use the data from your own iTunes library, then replace the file SampleData\iTunes Music Library.xml with your version.
On Solution Explorer, click on your Solution and then click on the Transform All Templates buttons at the Solution Explorer buttons bar.
Rebuild the solution.
Run the Scripts\CreateAll.bat batch file to create all databases.
Run all unit tests.

Updated Wiki: Building_Scripts

lerocha — Mon, 18 Aug 2008 02:38:38 GMT

Required Tools

Microsoft Visual Studio 2008

Database Servers

SQL Server Express (already installed with Visual Studio).
Oracle Database 10g Express Edition (XE).
MySQL 5.0 Community Server: Choose all default settings when installing, but on the MySQL Server Instance installer, check the option to Include Bin Directory in Windows PATH.
MySQL Connector/Net 5.1

Instructions

Download the latest source code from here.
Open the Solution file in Visual Studio.
If you want to use the data from your own iTunes library, then replace the file SampleData\iTunes Music Library.xml with your version.
On Solution Explorer, click on your Solution and then click on the Transform All Templates buttons at the Solution Explorer buttons bar.
Rebuild the solution.
Run the Scripts\CreateAll.bat batch file to create all databases.
Run all unit tests.

Updated Wiki: Building_Scripts

lerocha — Mon, 18 Aug 2008 02:34:03 GMT

Required Tools

Microsoft Visual Studio 2008

Database Servers

SQL Server Express (already installed with Visual Studio).
Oracle Database 10g Express Edition (XE).
MySQL 5.0 Community Server: Choose all default settings when installing, but on the MySQL Server Instance installer, check the option to Include Bin Directory in Windows PATH.
MySQL Connector/Net 5.1

Instructions

Download the latest source code from here.
Open the Solution file in Visual Studio.
If you want to use the data from your own iTunes library, then replace the file SampleData\iTunes Music Library.xml with your version.
Click on Transform All Templates on Solution Explorer.
Rebuild the solution.
Run the Scripts\CreateAll.bat batch file to create all databases.
Run all unit tests.

Updated Wiki: Building_Scripts

lerocha — Mon, 18 Aug 2008 02:09:49 GMT

Required Tools

Microsoft Visual Studio 2008

Database Servers

SQL Server Express (already installed with Visual Studio).
Oracle Database 10g Express Edition (XE).
MySQL 5.0 Community Server: Choose all default settings when installing, but on the MySQL Server Instance installer, check the option to Include Bin Directory in Windows PATH.
MySQL Connector/Net 5.1

Instructions

Download the latest source code from here.
Open the Solution file in Visual Studio.
Click on Transform All Templates on Solution Explorer.
Rebuild the solution.
Run all unit tests.

Updated Wiki: Building_Scripts

lerocha — Mon, 18 Aug 2008 02:07:47 GMT

Required Tools

Microsoft Visual Studio 2008

Database Servers

SQL Server Express (already installed with Visual Studio).
Oracle Database 10g Express Edition (XE).
MySQL 5.0 Community Server: Choose all default settings when installing, but on the MySQL Server Instance installer, check the option to Include Bin Directory in Windows PATH.
MySQL Connector/Net 5.1

Updated Wiki: Home

lerocha — Mon, 18 Aug 2008 02:03:53 GMT

Project Description

Supported Database Servers

SQL Server
Oracle
MySQL

Database Schema

The Chinook database schema represents a digital media store, including tables for artists, albums, media tracks, invoices and customers. You can see the Chinook database schema here.

Sample Data

Media related data was created using real data from an iTunes Library. It is possible for you to use your own iTunes Library to generate the SQL scripts, see instructions here.
Customer and employee information was manually created using fictitious names, addresses that can be located on Google maps, and other well formated data (phone, fax, email, etc.).
Sales information is auto generated using random data for a four year period.