http://www.codeplex.com/ChinookDatabase/Release/ProjectReleases.aspxChinookDatabase Release Rss Descriptionhttp://www.codeplex.com/ChinookDatabase/Release/ProjectReleases.aspx?ReleaseId=21111<div> 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 <a href="http://www.codeplex.com/ChinookDatabase/Wiki/View.aspx?title=Chinook_Schema">here</a>.<br> <br>The zip file above contains SQL scripts and batch files for each database supported. It also contains the data in XML format, see <b>SampleData\ChinookData.xml</b>, and a SQL Server Compact database <b>SampleData\Chinook.sdf</b>.<br><h2> What is new? </h2><ul> <li>Support for SQL Server Compact.</li><li>Additional customers from multiple countries.</li><li>Added a many-to-many relationship (a Playlist contains many Tracks, a Track belongs to many Playlists).</li><li>Added a one-to-many relationship between Employee and Customer (support representative).</li><li>Added Total field to invoice table.</li> </ul><h2> Supported Database Servers </h2><ul> <li>MySQL</li><li>Oracle</li><li>SQL Server</li><li>SQL Server Compact</li> </ul><h2> How do I Create the Chinook Database? </h2>Download and extract the zip file above. Under the <b>Script</b> folder, there are two files per database server: a SQL script, <b>CreateDB.sql</b>, and a batch file, <b>CreateDB.bat</b>. You can either run the SQL script by using your preferred database tool or run the provided batch file. <br> <br>The batch files use the database server command tool (<b>mysql.exe</b> for MySQL, <b>sqlcmd.exe</b> for SQL Server, and <b>sqlplus.exe</b> for Oracle). If you are using Windows Vista, it is recommended to open a Command Prompt window as Administrator in order to run these batch files.<br> <br>For SQL Server Compact, we included the compact database <b>SampleData\Chinook.sdf</b>. If you prefer to create your own compact database, then you can use its <b>CreateTables.sqlce</b> script.<br><h2> Notes for MySQL Version </h2><ul> <li>The provided script was tested using <a href="http://dev.mysql.com/downloads/mysql/5.1.html">MySQL Server 5.1<span></span></a>.</li><li>The <b>CreateDB.bat</b> file uses the localhost server, and the <b>root</b> user with the password <b>p4ssw0rd</b>. Change this file to match your settings before running it.</li> </ul><h2> Notes for Oracle Version </h2><ul> <li>The provided script was tested using <a href="http://www.oracle.com/technology/products/database/xe/index.html">Oracle Database 10g Express Edition (XE)<span></span></a>.</li><li>The <b>CreateDB.sql</b> creates a new user <b>chinook</b>, with the password <b>p4ssw0rd</b>. Change this script if you want a different user/password.</li> </ul><h2> Notes for SQL Server Version </h2><ul> <li>The provided script was tested using <a href="http://www.microsoft.com/downloads/details.aspx?FamilyID=7522a683-4cb2-454e-b908-e805e9bd4e28&DisplayLang=en">SQL Server Express 2008<span></span></a>.</li> </ul><h2> Notes for SQL Server Compact Version </h2><ul> <li>The provided script was tested using <a href="http://www.microsoft.com/Sqlserver/2008/en/us/compact.aspx">SQL Server Compact 3.5 SP1<span></span></a>.</li><li>We included the compact database <b>SampleData\Chinook.sdf</b>. If you prefer to create your own compact database, then you can use the <b>CreateTables.sqlce</b> script with <a href="http://msdn.microsoft.com/en-us/library/ms365247.aspx">SQL Server Management Studio Express<span></span></a> tool.</li> </ul> </div>lerochaSun, 11 Jan 2009 19:25:55 GMTUpdated Release: Chinook Database 1.1 (Jan 04, 2009) 20090111072555Phttp://www.codeplex.com/ChinookDatabase/Release/ProjectReleases.aspx?ReleaseId=21111<div> 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 <a href="http://www.codeplex.com/ChinookDatabase/Wiki/View.aspx?title=Chinook_Schema">here</a>.<br> <br>The zip file above contains SQL scripts and batch files for each database supported. It also contains the data in XML format, see <b>SampleData\ChinookData.xml</b>, and a SQL Server Compact database <b>SampleData\Chinook.sdf</b>.<br><h2> What is new? </h2><ul> <li>Support for SQL Server Compact.</li><li>Additional customers from multiple countries.</li><li>Added a many-to-many relationship (a Playlist contains many Tracks, a Track belongs to many Playlists).</li><li>Added a one-to-many relationship between Employee and Customer (support representative).</li><li>Added Total field to invoice table.</li> </ul><h2> Supported Database Servers </h2><ul> <li>MySQL</li><li>Oracle</li><li>SQL Server</li><li>SQL Server Compact</li> </ul><h2> How do I Create the Chinook Database? </h2>Download and extract the zip file above. Under the <b>Script</b> folder, there are two files per database server: a SQL script, <b>CreateDB.sql</b>, and a batch file, <b>CreateDB.bat</b>. You can either run the SQL script by using your preferred database tool or run the provided batch file. <br> <br>The batch files use the database server command tool (<b>mysql.exe</b> for MySQL, <b>sqlcmd.exe</b> for SQL Server, and <b>sqlplus.exe</b> for Oracle). If you are using Windows Vista, it is recommended to open a Command Prompt window as Administrator in order to run these batch files.<br> <br>For SQL Server Compact, we included the compact database <b>SampleData\Chinook.sdf</b>. If you prefer to create your own compact database, then you can use its <b>CreateTables.sqlce</b> script.<br><h2> Notes for MySQL Version </h2><ul> <li>The provided script was tested using <a href="http://dev.mysql.com/downloads/mysql/5.1.html">MySQL Server 5.1<span></span></a>.</li><li>The <b>CreateDB.bat</b> file uses the localhost server, and the <b>root</b> user with the password <b>p4ssw0rd</b>. Change this file to match your settings before running it.</li> </ul><h2> Notes for Oracle Version </h2><ul> <li>The provided script was tested using <a href="http://www.oracle.com/technology/products/database/xe/index.html">Oracle Database 10g Express Edition (XE)<span></span></a>.</li><li>The <b>CreateDB.sql</b> creates a new user <b>chinook</b>, with the password <b>p4ssw0rd</b>. Change this script if you want a different user/password.</li> </ul><h2> Notes for SQL Server Version </h2><ul> <li>The provided script was tested using <a href="http://www.microsoft.com/downloads/details.aspx?FamilyID=7522a683-4cb2-454e-b908-e805e9bd4e28&DisplayLang=en">SQL Server Express 2008<span></span></a>.</li> </ul><h2> Notes for SQL Server Compact Version </h2><ul> <li>The provided script was tested using <a href="http://www.microsoft.com/Sqlserver/2008/en/us/compact.aspx">SQL Server Compact 3.5 SP1<span></span></a>.</li><li>We included the compact database <b>SampleData\Chinook.sdf</b>. If you prefer to create your own compact database, then you can use the <b>CreateTables.sqlce</b> script with <a href="http://msdn.microsoft.com/en-us/library/ms365247.aspx">SQL Server Management Studio Express<span></span></a> tool.</li> </ul> </div>Sun, 11 Jan 2009 19:25:55 GMTReleased: Chinook Database 1.1 (Jan 04, 2009) 20090111072555Phttp://www.codeplex.com/ChinookDatabase/Release/ProjectReleases.aspx?ReleaseId=21111<div> 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 <a href="http://www.codeplex.com/ChinookDatabase/Wiki/View.aspx?title=Chinook_Schema">here</a>.<br> <br>The zip file above contains SQL scripts and batch files for each database supported. It also contains the data in XML format, see <b>SampleData\ChinookData.xml</b>, and a SQL Server Compact database <b>SampleData\Chinook.sdf</b>.<br><h2> What is new? </h2><ul> <li>Support for SQL Server Compact.</li><li>Additional customers from multiple countries.</li><li>Added a many-to-many relationship (a Playlist contains many Tracks, a Track belongs to many Playlists).</li><li>Added a one-to-many relationship between Employee and Customer (support representative).</li><li>Added Total field to invoice table.</li> </ul><h2> Supported Database Servers </h2><ul> <li>MySQL</li><li>Oracle</li><li>SQL Server</li><li>SQL Server Compact</li> </ul><h2> How do I Create the Chinook Database? </h2>Download and extract the zip file above. Under the <b>Script</b> folder, there are two files per database server: a SQL script, <b>CreateDB.sql</b>, and a batch file, <b>CreateDB.bat</b>. You can either run the SQL script by using your preferred database tool or run the provided batch file. <br> <br>The batch files use the database server command tool (<b>mysql.exe</b> for MySQL, <b>sqlcmd.exe</b> for SQL Server, and <b>sqlplus.exe</b> for Oracle). If you are using Windows Vista, it is recommended to open a Command Prompt window as Administrator in order to run these batch files.<br> <br>For SQL Server Compact, we included the compact database <b>SampleData\Chinook.sdf</b>. If you prefer to create your own compact database, then you can use its <b>CreateDB.sql</b> script.<br><h2> Notes for MySQL Version </h2><ul> <li>The provided script was tested using <a href="http://dev.mysql.com/downloads/mysql/5.1.html">MySQL Server 5.1<span></span></a>.</li><li>The <b>CreateDB.bat</b> file uses the localhost server, and the <b>root</b> user with the password <b>p4ssw0rd</b>. Change this file to match your settings before running it.</li> </ul><h2> Notes for Oracle Version </h2><ul> <li>The provided script was tested using <a href="http://www.oracle.com/technology/products/database/xe/index.html">Oracle Database 10g Express Edition (XE)<span></span></a>.</li><li>The <b>CreateDB.sql</b> creates a new user <b>chinook</b>, with the password <b>p4ssw0rd</b>. Change this script if you want a different user/password.</li> </ul><h2> Notes for SQL Server Version </h2><ul> <li>The provided script was tested using <a href="http://www.microsoft.com/downloads/details.aspx?FamilyID=7522a683-4cb2-454e-b908-e805e9bd4e28&DisplayLang=en">SQL Server Express 2008<span></span></a>.</li> </ul><h2> Notes for SQL Server Compact Version </h2><ul> <li>The provided script was tested using <a href="http://www.microsoft.com/Sqlserver/2008/en/us/compact.aspx">SQL Server Compact 3.5 SP1<span></span></a>.</li><li>We included the compact database <b>SampleData\Chinook.sdf</b>. If you prefer to create your own compact database, then you can use the <i>CreateTables.sql</i> script with <a href="http://msdn.microsoft.com/en-us/library/ms365247.aspx">SQL Server Management Studio Express<span></span></a> tool.</li> </ul> </div>lerochaTue, 06 Jan 2009 03:08:40 GMTUpdated Release: Chinook Database 1.1 (Jan 04, 2009) 20090106030840Ahttp://www.codeplex.com/ChinookDatabase/Release/ProjectReleases.aspx?ReleaseId=21111<div> 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 <a href="http://www.codeplex.com/ChinookDatabase/Wiki/View.aspx?title=Chinook_Schema">here</a>.<br> <br>The zip file above contains SQL scripts and batch files for each database supported. It also contains the data in XML format, see <b>SampleData\ChinookData.xml</b>, and a SQL Server Compact database <b>SampleData\Chinook.sdf</b>.<br><h2> What is new? </h2><ul> <li>Support for SQL Server Compact.</li><li>Additional customers from multiple countries.</li><li>Added a many-to-many relationship (a Playlist contains many Tracks, a Track belongs to many Playlists).</li><li>Added a one-to-many relationship between Employee and Customer (support representative).</li><li>Added Total field to invoice table.</li> </ul><h2> Supported Database Servers </h2><ul> <li>MySQL</li><li>Oracle</li><li>SQL Server</li><li>SQL Server Compact</li> </ul><h2> How do I Create the Chinook Database? </h2>Download and extract the zip file above. Under the <b>Script</b> folder, there are two files per database server: a SQL script, <b>CreateDB.sql</b>, and a batch file, <b>CreateDB.bat</b>. You can either run the SQL script by using your preferred database tool or run the provided batch file. <br> <br>The batch files use the database server command tool (<b>mysql.exe</b> for MySQL, <b>sqlcmd.exe</b> for SQL Server, and <b>sqlplus.exe</b> for Oracle). If you are using Windows Vista, it is recommended to open a Command Prompt window as Administrator in order to run these batch files.<br> <br>For SQL Server Compact, we included the compact database <b>SampleData\Chinook.sdf</b>. If you prefer to create your own compact database, then you can use its <b>CreateDB.sql</b> script.<br><h2> Notes for MySQL Version </h2><ul> <li>The provided script was tested using <a href="http://dev.mysql.com/downloads/mysql/5.1.html">MySQL Server 5.1<span></span></a>.</li><li>The <b>CreateDB.bat</b> file uses the localhost server, and the <b>root</b> user with the password <b>p4ssw0rd</b>. Change this file to match your settings before running it.</li> </ul><h2> Notes for Oracle Version </h2><ul> <li>The provided script was tested using <a href="http://www.oracle.com/technology/products/database/xe/index.html">Oracle Database 10g Express Edition (XE)<span></span></a>.</li><li>The <b>CreateDB.sql</b> creates a new user <b>chinook</b>, with the password <b>p4ssw0rd</b>. Change this script if you want a different user/password.</li> </ul><h2> Notes for SQL Server Version </h2><ul> <li>The provided script was tested using <a href="http://www.microsoft.com/downloads/details.aspx?FamilyID=7522a683-4cb2-454e-b908-e805e9bd4e28&DisplayLang=en">SQL Server Express 2008<span></span></a>.</li> </ul><h2> Notes for SQL Server Compact Version </h2><ul> <li>The provided script was tested using <a href="http://www.microsoft.com/Sqlserver/2008/en/us/compact.aspx">SQL Server Compact 3.5 SP1<span></span></a>.</li><li>We included the compact database <b>SampleData\Chinook.sdf</b>. If you prefer to create your own compact database, then you can use the <i>CreateTables.sql</i> script with <a href="http://msdn.microsoft.com/en-us/library/ms365247.aspx">SQL Server Management Studio Express<span></span></a> tool.</li> </ul> </div>Tue, 06 Jan 2009 03:08:40 GMTReleased: Chinook Database 1.1 (Jan 04, 2009) 20090106030840Ahttp://www.codeplex.com/ChinookDatabase/Release/ProjectReleases.aspx?ReleaseId=21111<div> 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 <a href="http://www.codeplex.com/ChinookDatabase/Wiki/View.aspx?title=Chinook_Schema">here</a>.<br> <br>The zip file above contains SQL scripts and batch files for each database supported. It also contains the data in XML format, see <b>SampleData\ChinookData.xml</b>, and a SQL Server Compact database <b>SampleData\Chinook.sdf</b>.<br><h2> What is new? </h2><ul> <li>Support for SQL Server Compact.</li><li>Additional customers from multiple countries.</li><li>Added a many-to-many relationship (a Playlist contains many Tracks, a Track belongs to many Playlists).</li><li>Added a one-to-many relationship between Employee and Customer (support representative).</li><li>Added Total field to invoice table.</li> </ul><h2> Supported Database Servers </h2><ul> <li>MySQL</li><li>Oracle</li><li>SQL Server</li><li>SQL Server Compact</li> </ul><h2> How do I Create the Chinook Database? </h2>Download and extract the zip file above. Under the <b>Script</b> folder, there are two files per database server: a SQL script, <b>CreateDB.sql</b>, and a batch file, <b>CreateDB.bat</b>. You can either run the SQL script by using your preferred database tool or run the provided batch file. <br> <br>The batch files use the database server command tool (<b>mysql.exe</b> for MySQL, <b>sqlcmd.exe</b> for SQL Server, and <b>sqlplus.exe</b> for Oracle). If you are using Windows Vista, it is recommended to open a Command Prompt window as Administrator in order to run these batch files.<br> <br>For SQL Server Compact, we included the compact database <b>SampleData\Chinook.sdf</b>. If you prefer to create your own compact database, then you can use its <b>CreateDB.sql</b> script.<br><h2> Notes for MySQL Version </h2><ul> <li>The provided script was tested using <a href="http://dev.mysql.com/downloads/mysql/5.1.html">MySQL Server 5.1<span></span></a>.</li><li>The <b>CreateDB.bat</b> file uses the localhost server, and the <b>root</b> user with the password <b>p4ssw0rd</b>. Change this file to match your settings before running it.</li> </ul><h2> Notes for Oracle Version </h2><ul> <li>The provided script was tested using <a href="http://www.oracle.com/technology/products/database/xe/index.html">Oracle Database 10g Express Edition (XE)<span></span></a>.</li><li>The <b>CreateDB.sql</b> creates a new user <b>chinook</b>, with the password <b>p4ssw0rd</b>. Change this script if you want a different user/password.</li> </ul><h2> Notes for SQL Server Version </h2><ul> <li>The provided script was tested using <a href="http://www.microsoft.com/downloads/details.aspx?FamilyID=7522a683-4cb2-454e-b908-e805e9bd4e28&DisplayLang=en">SQL Server Express 2008<span></span></a>.</li> </ul><h2> Notes for SQL Server Compact Version </h2><ul> <li>The provided script was tested using <a href="http://www.microsoft.com/Sqlserver/2008/en/us/compact.aspx">SQL Server Compact 3.5 SP1<span></span></a>.</li><li>We included the compact database <b>SampleData\Chinook.sdf</b>. If you prefer to create your own compact database, then you can use the <i>CreateTables.sql</i> script with <a href="http://msdn.microsoft.com/en-us/library/ms365247.aspx">SQL Server Management Studio Express<span></span></a> tool.</li> </ul> </div>lerochaMon, 05 Jan 2009 03:50:59 GMTUpdated Release: Chinook Database 1.1 (Jan 04, 2009) 20090105035059Ahttp://www.codeplex.com/ChinookDatabase/Release/ProjectReleases.aspx?ReleaseId=21111<div> 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 <a href="http://www.codeplex.com/ChinookDatabase/Wiki/View.aspx?title=Chinook_Schema">here</a>.<br> <br>The zip file above contains SQL scripts and batch files for each database supported. It also contains the data in XML format, see <b>SampleData\ChinookData.xml</b>, and a SQL Server Compact database <b>SampleData\Chinook.sdf</b>.<br><h2> What is new? </h2><ul> <li>Support for SQL Server Compact.</li><li>Additional customers from multiple countries.</li><li>Added a many-to-many relationship (a Playlist contains many Tracks, a Track belongs to many Playlists).</li><li>Added a one-to-many relationship between Employee and Customer (support representative).</li><li>Added Total field to invoice table.</li> </ul><h2> Supported Database Servers </h2><ul> <li>MySQL</li><li>Oracle</li><li>SQL Server</li><li>SQL Server Compact</li> </ul><h2> How do I Create the Chinook Database? </h2>Download and extract the zip file above. Under the <b>Script</b> folder, there are two files per database server: a SQL script, <b>CreateDB.sql</b>, and a batch file, <b>CreateDB.bat</b>. You can either run the SQL script by using your preferred database tool or run the provided batch file. <br> <br>The batch files use the database server command tool (<b>mysql.exe</b> for MySQL, <b>sqlcmd.exe</b> for SQL Server, and <b>sqlplus.exe</b> for Oracle). If you are using Windows Vista, it is recommended to open a Command Prompt window as Administrator in order to run these batch files.<br> <br>For SQL Server Compact, we included the compact database <b>SampleData\Chinook.sdf</b>. If you prefer to create your own compact database, then you can use its <b>CreateDB.sql</b> script.<br><h2> Notes for MySQL Version </h2><ul> <li>The provided script was tested using <a href="http://dev.mysql.com/downloads/mysql/5.1.html">MySQL Server 5.1<span></span></a>.</li><li>The <b>CreateDB.bat</b> file uses the localhost server, and the <b>root</b> user with the password <b>p4ssw0rd</b>. Change this file to match your settings before running it.</li> </ul><h2> Notes for Oracle Version </h2><ul> <li>The provided script was tested using <a href="http://www.oracle.com/technology/products/database/xe/index.html">Oracle Database 10g Express Edition (XE)<span></span></a>.</li><li>The <b>CreateDB.sql</b> creates a new user <b>chinook</b>, with the password <b>p4ssw0rd</b>. Change this script if you want a different user/password.</li> </ul><h2> Notes for SQL Server Version </h2><ul> <li>The provided script was tested using <a href="http://www.microsoft.com/downloads/details.aspx?FamilyID=7522a683-4cb2-454e-b908-e805e9bd4e28&DisplayLang=en">SQL Server Express 2008<span></span></a>.</li> </ul><h2> Notes for SQL Server Compact Version </h2><ul> <li>The provided script was tested using <a href="http://www.microsoft.com/Sqlserver/2008/en/us/compact.aspx">SQL Server Compact 3.5 SP1<span></span></a>.</li><li>We included the compact database <b>SampleData\Chinook.sdf</b>. If you prefer to create your own compact database, then you can use the <i>CreateTables.sql</i> script with <a href="http://msdn.microsoft.com/en-us/library/ms365247.aspx">SQL Server Management Studio Express<span></span></a> tool.</li> </ul> </div>Mon, 05 Jan 2009 03:50:56 GMTReleased: Chinook Database 1.1 (Jan 04, 2009) 20090105035056Ahttp://www.codeplex.com/ChinookDatabase/Release/ProjectReleases.aspx?ReleaseId=21111<div> 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 <a href="http://www.codeplex.com/ChinookDatabase/Wiki/View.aspx?title=Chinook_Schema">here</a>.<br> <br>The zip file above contains SQL scripts and batch files for each database supported. It also contains the data in XML format, see <b>SampleData\ChinookData.xml</b>, and a SQL Server Compact database <b>SampleData\Chinook.sdf</b>.<br><h2> What is new? </h2><ul> <li>Support for SQL Server Compact.</li><li>Additional customers from multiple countries.</li><li>Added a many-to-many relationship (a Playlist contains many Tracks, a Track belongs to many Playlists).</li><li>Added a one-to-many relationship between Employee and Customer (support representative).</li><li>Added Total field to invoice table.</li> </ul><h2> Supported Database Servers </h2><ul> <li>MySQL</li><li>Oracle</li><li>SQL Server</li><li>SQL Server Compact</li> </ul><h2> How do I Create the Chinook Database? </h2>Download and extract the zip file above. Under the <b>Script</b> folder, there are two files per database server: a SQL script, <b>CreateDB.sql</b>, and a batch file, <b>CreateDB.bat</b>. You can either run the SQL script by using your preferred database tool or run the provided batch file. <br> <br>The batch files use the database server command tool (<b>mysql.exe</b> for MySQL, <b>sqlcmd.exe</b> for SQL Server, and <b>sqlplus.exe</b> for Oracle). If you are using Windows Vista, it is recommended to open a Command Prompt window as Administrator in order to run these batch files.<br> <br>For SQL Server Compact, we included the compact database <b>SampleData\Chinook.sdf</b>. If you prefer to create your own compact database, then you can use its <b>CreateDB.sql</b> script.<br><h2> Notes for MySQL Version </h2><ul> <li>The provided script was tested using <a href="http://dev.mysql.com/downloads/mysql/5.1.html">MySQL Server 5.1<span></span></a>.</li><li>The <b>CreateDB.bat</b> file uses the localhost server, and the <b>root</b> user with the password <b>p4ssw0rd</b>. Change this file to match your settings before running it.</li> </ul><h2> Notes for Oracle Version </h2><ul> <li>The provided script was tested using <a href="http://www.oracle.com/technology/products/database/xe/index.html">Oracle Database 10g Express Edition (XE)<span></span></a>.</li><li>The <b>CreateDB.sql</b> creates a new user <b>chinook</b>, with the password <b>p4ssw0rd</b>. Change this script if you want a different user/password.</li> </ul><h2> Notes for SQL Server Version </h2><ul> <li>The provided script was tested using <a href="http://www.microsoft.com/downloads/details.aspx?FamilyID=7522a683-4cb2-454e-b908-e805e9bd4e28&DisplayLang=en">SQL Server Express 2008<span></span></a>.</li> </ul><h2> Notes for SQL Server Compact Version </h2><ul> <li>The provided script was tested using <a href="http://www.microsoft.com/Sqlserver/2008/en/us/compact.aspx">SQL Server Compact 3.5 SP1<span></span></a>.</li><li>We included the compact database <b>SampleData\Chinook.sdf</b>. If you prefer to create your own compact database, then you can use the <i>CreateTables.sql</i> script with <a href="http://msdn.microsoft.com/en-us/library/ms365247.aspx">SQL Server Management Studio Express<span></span></a> tool.</li> </ul> </div>lerochaMon, 05 Jan 2009 03:50:21 GMTUpdated Release: Chinook Database 1.1 20090105035021Ahttp://www.codeplex.com/ChinookDatabase/Release/ProjectReleases.aspx?ReleaseId=21111<div> 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 <a href="http://www.codeplex.com/ChinookDatabase/Wiki/View.aspx?title=Chinook_Schema">here</a>.<br> <br>The zip file above contains SQL scripts and batch files for each database supported. It also contains the data in XML format (DataSet), see <b>SampleData\ChinookData.xml</b>.<br><h2> What is new? </h2><ul> <li>Added a many-to-many relationship (a Playlist contains many Tracks, a Track belongs to many Playlists).</li><li>Support for SQL Server Compact.</li><li>Additional data for customers and employees.</li> </ul><h2> Supported Database Servers </h2><ul> <li>MySQL</li><li>Oracle</li><li>SQL Server</li><li>SQL Server Compact</li> </ul><h2> How do I Create the Chinook Database? </h2>Download and extract the zip file above. Under the <b>Script</b> folder, there are two files per database server: a SQL script, <b>CreateDB.sql</b>, and a batch file, <b>CreateDB.bat</b>. You can either run the SQL script by using your preferred database tool or run the provided batch file. <br> <br>The batch files use the database server command tool (<b>mysql.exe</b> for MySQL, <b>sqlcmd.exe</b> for SQL Server, and <b>sqlplus.exe</b> for Oracle). If you are using Windows Vista, it is recommended to open a Command Prompt window as Administrator in order to run these batch files.<br> <br>For SQL Server Compact, we included the compact database <b>SampleData\Chinook.sdf</b>. If you prefer to create your own compact database, then you can use its <b>CreateDB.sql</b> script.<br><h2> Notes for MySQL Version </h2><ul> <li>The provided script was tested using <a href="http://dev.mysql.com/downloads/mysql/5.1.html">MySQL Server 5.1<span></span></a>.</li><li>The <b>CreateDB.bat</b> file uses the localhost server, and the <b>root</b> user with the password <b>p4ssw0rd</b>. Change this file to match your settings before running it.</li> </ul><h2> Notes for Oracle Version </h2><ul> <li>The provided script was tested using <a href="http://www.oracle.com/technology/products/database/xe/index.html">Oracle Database 10g Express Edition (XE)<span></span></a>.</li><li>The <b>CreateDB.sql</b> creates a new user <b>chinook</b>, with the password <b>p4ssw0rd</b>. Change this script if you want a different user/password.</li> </ul><h2> Notes for SQL Server Version </h2><ul> <li>The provided script was tested using <a href="http://www.microsoft.com/downloads/details.aspx?FamilyID=7522a683-4cb2-454e-b908-e805e9bd4e28&DisplayLang=en">SQL Server Express 2008<span></span></a>.</li> </ul><h2> Notes for SQL Server Compact Version </h2><ul> <li>The provided script was tested using <a href="http://www.microsoft.com/Sqlserver/2008/en/us/compact.aspx">SQL Server Compact 3.5 SP1<span></span></a>.</li><li>We included the compact database <b>SampleData\Chinook.sdf</b>. If you prefer to create your own compact database, then you can use the <i>CreateTables.sql</i> script with <a href="http://msdn.microsoft.com/en-us/library/ms365247.aspx">SQL Server Management Studio Express<span></span></a> tool.</li> </ul> </div>lerochaMon, 05 Jan 2009 00:17:43 GMTUpdated Release: Chinook Database 1.1 20090105121743Ahttp://www.codeplex.com/ChinookDatabase/Release/ProjectReleases.aspx?ReleaseId=21111<div> 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 <a href="http://www.codeplex.com/ChinookDatabase/Wiki/View.aspx?title=Chinook_Schema">here</a>.<br> <br>The zip file above contains SQL scripts and batch files for each database supported. It also contains the data in XML format (DataSet), see <b>SampleData\ChinookData.xml</b>.<br><h2> What is new? </h2><ul> <li>Added a many-to-many relationship (a Playlist contains many Tracks, a Track belongs to many Playlists).</li><li>Support for SQL Server Compact.</li><li>Additional data for customers and employees.</li> </ul><h2> Supported Database Servers </h2><ul> <li>MySQL</li><li>Oracle</li><li>SQL Server</li><li>SQL Server Compact</li> </ul><h2> How do I Create the Chinook Database? </h2>Download and extract the zip file above. Under the <b>Script</b> folder, there are two files per database server: a SQL script, <b>CreateDB.sql</b>, and a batch file, <b>CreateDB.bat</b>. You can either run the SQL script by using your preferred database tool or run the provided batch file. <br> <br>The batch files use the database server command tool (<b>mysql.exe</b> for MySQL, <b>sqlcmd.exe</b> for SQL Server, and <b>sqlplus.exe</b> for Oracle). If you are using Windows Vista, it is recommended to open a Command Prompt window as Administrator in order to run these batch files.<br> <br>For SQL Server Compact, we included the compact database <b>SampleData\Chinook.sdf</b>. If you prefer to create your own compact database, then you can use its <b>CreateDB.sql</b> script.<br><h2> Notes for MySQL Version </h2><ul> <li>The provided script was tested using <a href="http://dev.mysql.com/downloads/mysql/5.1.html">MySQL Server 5.1<span></span></a>.</li><li>The <b>CreateDB.bat</b> file uses the localhost server, and the <b>root</b> user with the password <b>p4ssw0rd</b>. Change this file to match your settings before running it.</li> </ul><h2> Notes for Oracle Version </h2><ul> <li>The provided script was tested using <a href="http://www.oracle.com/technology/products/database/xe/index.html">Oracle Database 10g Express Edition (XE)<span></span></a>.</li><li>The <b>CreateDB.sql</b> creates a new user <b>chinook</b>, with the password <b>p4ssw0rd</b>. Change this script if you want a different user/password.</li> </ul><h2> Notes for SQL Server Version </h2><ul> <li>The provided script was tested using <a href="http://www.microsoft.com/downloads/details.aspx?FamilyID=7522a683-4cb2-454e-b908-e805e9bd4e28&DisplayLang=en">SQL Server Express 2008<span></span></a>.</li> </ul><h2> Notes for SQL Server Compact Version </h2><ul> <li>The provided script was tested using <a href="http://www.microsoft.com/Sqlserver/2008/en/us/compact.aspx">SQL Server Compact 3.5 SP1<span></span></a>.</li><li>We included the compact database <b>SampleData\Chinook.sdf</b>. If you prefer to create your own compact database, then you can use the <i>CreateDB.sql</i> script with <a href="http://msdn.microsoft.com/en-us/library/ms365247.aspx">SQL Server Management Studio Express<span></span></a> tool.</li> </ul> </div>lerochaTue, 30 Dec 2008 06:08:58 GMTUpdated Release: Chinook Database 1.1 20081230060858Ahttp://www.codeplex.com/ChinookDatabase/Release/ProjectReleases.aspx?ReleaseId=21111<div> 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 <a href="http://www.codeplex.com/ChinookDatabase/Wiki/View.aspx?title=Chinook_Schema">here</a>.<br> <br>The zip file above contains SQL scripts and batch files for each database supported. It also contains the data in XML format (DataSet), see <i>SampleData\ChinookData.xml</i>.<br><h2> What is new? </h2><ul> <li>Added a many-to-many relationship (a Playlist contains many Tracks, a Track belongs to many Playlists).</li><li>Support for SQL Server Compact.</li><li>Additional data for customers and employees.</li> </ul><h2> Supported Database Servers </h2><ul> <li>MySQL</li><li>Oracle</li><li>SQL Server</li><li>SQL Server Compact</li> </ul><h2> How do I Create the Chinook Database? </h2>Download and extract the zip file above. Under the <i>Script</i> folder, there are two files per database server: a SQL script, <i>CreateDB.sql</i>, and a batch file, <i>CreateDB.bat</i>. You can either run the SQL script by using your preferred database tool or run the provided batch file. <br> <br>The batch files use the database server command tool (<i>mysql.exe</i> for MySQL, <i>sqlcmd.exe</i> for SQL Server, and <i>sqlplus.exe</i> for Oracle). If you are using Windows Vista, you should open a Command Prompt window as <i>Administrator</i> in order to run these batch files.<br><h2> Notes for MySQL Version </h2><ul> <li>The provided script was tested using <a href="http://dev.mysql.com/downloads/mysql/5.1.html">MySQL Server 5.1<span></span></a>.</li><li>The <i>CreateDB.bat</i> file uses the localhost server, and the <i>root</i> user with the password <i>p4ssw0rd</i>. Change this file to match your settings before running it.</li> </ul><h2> Notes for Oracle Version </h2><ul> <li>The provided script was tested using <a href="http://www.oracle.com/technology/products/database/xe/index.html">Oracle Database 10g Express Edition (XE)<span></span></a>.</li><li>The <i>CreateDB.sql</i> creates a new user <i>chinook</i>, with the password <i>p4ssw0rd</i>. Change this script if you want a different user/password.</li> </ul><h2> Notes for SQL Server Version </h2><ul> <li>The provided script was tested using <a href="http://www.microsoft.com/downloads/details.aspx?FamilyID=7522a683-4cb2-454e-b908-e805e9bd4e28&DisplayLang=en">SQL Server Express 2008<span></span></a>.</li> </ul><h2> Notes for SQL Server Compact Version </h2><ul> <li>The provided script was tested using <a href="http://www.microsoft.com/Sqlserver/2008/en/us/compact.aspx">SQL Server Compact 3.5 SP1<span></span></a>.</li><li>When using SQL Server Compact, you will have to create an empty database, and then use <a href="http://msdn.microsoft.com/en-us/library/ms365247.aspx">SQL Server Management Studio Express<span></span></a> tool to run the <i>CreateDB.sql</i> to create and populate the tables.</li> </ul> </div>lerochaTue, 30 Dec 2008 00:58:23 GMTUpdated Release: Chinook Database 1.1 20081230125823Ahttp://www.codeplex.com/ChinookDatabase/Release/ProjectReleases.aspx?ReleaseId=21111<div> 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 <a href="http://www.codeplex.com/ChinookDatabase/Wiki/View.aspx?title=Chinook_Schema">here</a>.<br> <br>The zip file above contains SQL scripts and batch files for each database supported. It also contains the data in XML format (DataSet), see <i>SampleData\ChinookData.xml</i>.<br><h2> What is new? </h2><ul> <li>Added a many-to-many relationship (a Playlist contains many Tracks, a Track belongs to many Playlists).</li><li>Support for SQL Server Compact.</li><li>Additional data for customers and employees.</li> </ul><h2> Supported Database Servers </h2><ul> <li>SQL Server</li><li>Oracle</li><li>MySQL</li> </ul><h2> How do I Create the Chinook Database? </h2>Download and extract the zip file above. Under the <i>Script</i> folder, there are two files per database server: a SQL script, <i>CreateDB.sql</i>, and a batch file, <i>CreateDB.bat</i>. You can either run the SQL script by using your preferred database tool or run the provided batch file. <br> <br>The batch files use the database server command tool (<i>mysql.exe</i>, <i>osql.exe</i> for SQL Server, and <i>sqlplus.exe</i> for Oracle). If you are using Windows Vista, you should open a Command Prompt window as <i>Administrator</i> in order to run these batch files.<br><h2> Notes for MySQL Version </h2><ul> <li>The provided script was tested using MySQL Server 5.0.</li><li>The <i>CreateDB.bat</i> file uses the localhost server, and the <i>root</i> user with the password <i>p4ssw0rd</i>. Change this file to match your settings before running it.</li> </ul><h2> Notes for Oracle Version </h2><ul> <li>The provided script was tested using Oracle Database 10g Express Edition (XE).</li><li>The <i>CreateDB.sql</i> creates a new user <i>chinook</i>, with the password <i>p4ssw0rd</i>. Change this script if you want a different user/password.</li> </ul><h2> Notes for SQL Server Version </h2><ul> <li>The provided script was tested using SQL Server Express which ships with Visual Studio 2008.</li> </ul> </div>lerochaTue, 30 Dec 2008 00:37:14 GMTUpdated Release: Chinook Database 1.1 20081230123714Ahttp://www.codeplex.com/ChinookDatabase/Release/ProjectReleases.aspx?ReleaseId=16370<div> 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 <a href="http://www.codeplex.com/ChinookDatabase/Wiki/View.aspx?title=Chinook_Schema">here</a>.<br> <br>The zip file above contains SQL scripts and batch files for each database supported. It also contains the data in XML format (DataSet), see <i>SampleData\ChinookData.xml</i>.<br><h2> Supported Database Servers </h2><ul> <li>SQL Server</li><li>Oracle</li><li>MySQL</li> </ul><h2> How do I Create the Chinook Database? </h2>Download and extract the zip file above. Under the <i>Script</i> folder, there are two files per database server: a SQL script, <i>CreateDB.sql</i>, and a batch file, <i>CreateDB.bat</i>. You can either run the SQL script by using your preferred database tool or run the provided batch file. <br> <br>The batch files use the database server command tool (<i>mysql.exe</i>, <i>osql.exe</i> for SQL Server, and <i>sqlplus.exe</i> for Oracle). If you are using Windows Vista, you should open a Command Prompt window as <i>Administrator</i> in order to run these batch files.<br><h2> Notes for MySQL Version </h2><ul> <li>The provided script was tested using MySQL Server 5.0.</li><li>The <i>CreateDB.bat</i> file uses the localhost server, and the <i>root</i> user with the password <i>p4ssw0rd</i>. Change this file to match your settings before running it.</li> </ul><h2> Notes for Oracle Version </h2><ul> <li>The provided script was tested using Oracle Database 10g Express Edition (XE).</li><li>The <i>CreateDB.sql</i> creates a new user <i>chinook</i>, with the password <i>p4ssw0rd</i>. Change this script if you want a different user/password.</li> </ul><h2> Notes for SQL Server Version </h2><ul> <li>The provided script was tested using SQL Server Express which ships with Visual Studio 2008.</li> </ul> </div>lerochaSat, 22 Nov 2008 03:45:40 GMTUpdated Release: Chinook Database 1.0 (Aug 17, 2008) 20081122034540Ahttp://www.codeplex.com/ChinookDatabase/Release/ProjectReleases.aspx?ReleaseId=16370<div> 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 <a href="http://www.codeplex.com/ChinookDatabase/Wiki/View.aspx?title=Chinook_Schema">here</a>.<br> <br>The zip file above contains SQL scripts and batch files for each database supported. It also contains the data in XML format (DataSet), see <i>SampleData\ChinookData.xml</i>.<br><h2> Supported Database Servers </h2><ul> <li>SQL Server</li><li>Oracle</li><li>MySQL</li> </ul><h2> How do I Create the Chinook Database? </h2>Download and extract the zip file above. Under the <i>Script</i> folder, there are two files per database server: a SQL script, <i>CreateDB.sql</i>, and a batch file, <i>CreateDB.bat</i>. You can either run the SQL script by using your preferred database tool or run the provided batch file. <br> <br>The batch files use the database server command tool (<i>mysql.exe</i>, <i>osql.exe</i> for SQL Server, and <i>sqlplus.exe</i> for Oracle). If you are using Windows Vista, you should open a Command Prompt window as <i>Administrator</i> in order to run these batch files.<br><h2> Notes for MySQL Version </h2><ul> <li>The provided script was tested using MySQL Server 5.0.</li><li>The <i>CreateDB.bat</i> file uses the localhost server, and the <i>root</i> user with the password <i>p4ssw0rd</i>. Change this file to match your settings before running it.</li> </ul><h2> Notes for Oracle Version </h2><ul> <li>The provided script was tested using Oracle Database 10g Express Edition (XE).</li><li>The <i>CreateDB.sql</i> creates a new user <i>chinook</i>, with the password <i>p4ssw0rd</i>. Change this script if you want a different user/password.</li> </ul><h2> Notes for SQL Server Version </h2><ul> <li>The provided script was tested using SQL Server Express which ships with Visual Studio 2008.</li> </ul> </div>Sat, 22 Nov 2008 03:45:36 GMTReleased: Chinook Database 1.0 (Aug 17, 2008) 20081122034536Ahttp://www.codeplex.com/ChinookDatabase/Release/ProjectReleases.aspx?ReleaseId=16370Rated 5 Stars (out of 5) - 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.chiponiumFri, 21 Nov 2008 16:00:23 GMTReviewed: Chinook Database 1.0 (Nov 21, 2008) 20081121040023Phttp://www.codeplex.com/ChinookDatabase/Release/ProjectReleases.aspx?ReleaseId=16370<div> 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 <a href="http://www.codeplex.com/ChinookDatabase/Wiki/View.aspx?title=Chinook_Schema">here</a>.<br> <br>The zip file above contains SQL scripts and batch files for each database supported. It also contains the data in XML format (DataSet), see <i>SampleData\ChinookData.xml</i>.<br><h2> Supported Database Servers </h2><ul> <li>SQL Server</li><li>Oracle</li><li>MySQL</li> </ul><h2> How do I Create the Chinook Database? </h2>Download and extract the zip file above. Under the <i>Script</i> folder, there are two files per database server: a SQL script, <i>CreateDB.sql</i>, and a batch file, <i>CreateDB.bat</i>. You can either run the SQL script by using your preferred database tool or run the provided batch file. <br> <br>The batch files use the database server command tool (<i>mysql.exe</i>, <i>osql.exe</i> for SQL Server, and <i>sqlplus.exe</i> for Oracle). If you are using Windows Vista, you should open a Command Prompt window as <i>Administrator</i> in order to run these batch files.<br><h2> Notes for MySQL Version </h2><ul> <li>The provided script was tested using MySQL Server 5.0.</li><li>The <i>CreateDB.bat</i> file uses the localhost server, and the <i>root</i> user with the password <i>p4ssw0rd</i>. Change this file to match your settings before running it.</li> </ul><h2> Notes for Oracle Version </h2><ul> <li>The provided script was tested using Oracle Database 10g Express Edition (XE).</li><li>The <i>CreateDB.sql</i> creates a new user <i>chinook</i>, with the password <i>p4ssw0rd</i>. Change this script if you want a different user/password.</li> </ul><h2> Notes for SQL Server Version </h2><ul> <li>The provided script was tested using SQL Server Express which ships with Visual Studio 2008.</li> </ul> </div>Mon, 18 Aug 2008 03:34:41 GMTUpdated Release: Chinook Database 1.0 (Aug 17, 2008) 20080818033441Ahttp://www.codeplex.com/ChinookDatabase/Release/ProjectReleases.aspx?ReleaseId=16370<div> 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 <a href="http://www.codeplex.com/ChinookDatabase/Wiki/View.aspx?title=Chinook_Schema">here</a>.<br> <br>The zip file above contains SQL scripts and batch files for each database supported. It also contains the data in XML format (DataSet), see <i>SampleData\ChinookData.xml</i>.<br><h2> Supported Database Servers </h2><ul> <li>SQL Server</li><li>Oracle</li><li>MySQL</li> </ul><h2> How do I Create the Chinook Database? </h2>Download and extract the zip file above. Under the <i>Script</i> folder, there are two files per database server: a SQL script, <i>CreateDB.sql</i>, and a batch file, <i>CreateDB.bat</i>. You can either run the SQL script by using your preferred database tool or run the provided batch file. <br> <br>The batch files use the database server command tool (<i>mysql.exe</i>, <i>osql.exe</i> for SQL Server, and <i>sqlplus.exe</i> for Oracle). If you are using Windows Vista, you should open a Command Prompt window as <i>Administrator</i> in order to run these batch files.<br><h2> Notes for MySQL Version </h2><ul> <li>The provided script was tested using MySQL Server 5.0.</li><li>The <i>CreateDB.bat</i> file uses the localhost server, and the <i>root</i> user with the password <i>p4ssw0rd</i>. Change this file to match your settings before running it.</li> </ul><h2> Notes for Oracle Version </h2><ul> <li>The provided script was tested using Oracle Database 10g Express Edition (XE).</li><li>The <i>CreateDB.sql</i> creates a new user <i>chinook</i>, with the password <i>p4ssw0rd</i>. Change this script if you want a different user/password.</li> </ul><h2> Notes for SQL Server Version </h2><ul> <li>The provided script was tested using SQL Server Express which ships with Visual Studio 2008.</li> </ul> </div>Mon, 18 Aug 2008 03:34:41 GMTReleased: Chinook Database 1.0 (Aug 17, 2008) 20080818033441Ahttp://www.codeplex.com/ChinookDatabase/Release/ProjectReleases.aspx?ReleaseId=16370<div> 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 <a href="http://www.codeplex.com/ChinookDatabase/Wiki/View.aspx?title=Chinook_Schema">here</a>.<br> <br>The zip file above contains SQL scripts and batch files for each database supported. It also contains the data in XML format (DataSet), see <i>SampleData\ChinookData.xml</i>.<br><h2> Supported Database Servers </h2><ul> <li>SQL Server</li><li>Oracle</li><li>MySQL</li> </ul><h2> How do I Create the Chinook Database? </h2>Download and extract the zip file above. Under the <i>Script</i> folder, there are two files per database server: a SQL script, <i>CreateDB.sql</i>, and a batch file, <i>CreateDB.bat</i>. You can either run the SQL script by using your preferred database tool or run the provided batch file. <br> <br>The batch files use the database server command tool (<i>mysql.exe</i>, <i>osql.exe</i> for SQL Server, and <i>sqlplus.exe</i> for Oracle). If you are using Windows Vista, you should open a Command Prompt window as <i>Administrator</i> in order to run these batch files.<br><h2> Notes for MySQL version </h2><ul> <li>The provided script was tested using MySQL Server 5.0.</li><li>The <i>CreateDB.bat</i> file uses the localhost server, and the <i>root</i> user with the password <i>p4ssw0rd</i>. Change this file to match your settings before running it.</li> </ul><h2> Notes for Oracle Version </h2><ul> <li>The provided script was tested using Oracle Database 10g Express Edition (XE).</li><li>The <i>CreateDB.sql</i> creates a new user <i>chinook</i>, with the password <i>p4ssw0rd</i>. Change this script if you want a different user/password.</li> </ul><h2> Notes for SQL Server version </h2><ul> <li>The provided script was tested using SQL Server Express which ships with Visual Studio 2008.</li> </ul> </div>Mon, 18 Aug 2008 00:59:41 GMTUpdated Release: Chinook Database 1.0 (Aug 17, 2008) 20080818125941Ahttp://www.codeplex.com/ChinookDatabase/Release/ProjectReleases.aspx?ReleaseId=16370<div> 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 <a href="http://www.codeplex.com/ChinookDatabase/Wiki/View.aspx?title=Chinook_Schema">here</a>.<br> <br>The zip file above contains SQL scripts and batch files for each database supported. It also contains the data in XML format (DataSet), see <i>SampleData\ChinookData.xml</i>.<br><h2> Supported Database Servers </h2><ul> <li>SQL Server</li><li>Oracle</li><li>MySQL</li> </ul><h2> How do I Create the Chinook Database? </h2>Download and extract the zip file above. Under the <i>Script</i> folder, there are two files per database server: a SQL script, <i>CreateDB.sql</i>, and a batch file, <i>CreateDB.bat</i>. You can either run the SQL script by using your preferred database tool or run the provided batch file. <br> <br>The batch files use the database server command tool (<i>mysql.exe</i>, <i>osql.exe</i> for SQL Server, and <i>sqlplus.exe</i> for Oracle). If you are using Windows Vista, you should open a Command Prompt window as <i>Administrator</i> in order to run these batch files.<br><h2> Notes for MySQL version </h2><ul> <li>The provided script was tested using MySQL Server 5.0.</li><li>The <i>CreateDB.bat</i> file uses the localhost server, and the <i>root</i> user with the password <i>p4ssw0rd</i>. Change this file to match your settings before running it.</li> </ul><h2> Notes for Oracle Version </h2><ul> <li>The provided script was tested using Oracle Database 10g Express Edition (XE).</li><li>The <i>CreateDB.sql</i> creates a new user <i>chinook</i>, with the password <i>p4ssw0rd</i>. Change this script if you want a different user/password.</li> </ul><h2> Notes for SQL Server version </h2><ul> <li>The provided script was tested using SQL Server Express which ships with Visual Studio 2008.</li> </ul> </div>Mon, 18 Aug 2008 00:59:41 GMTReleased: Chinook Database 1.0 (Aug 17, 2008) 20080818125941Ahttp://www.codeplex.com/ChinookDatabase/Release/ProjectReleases.aspx?ReleaseId=16370<div> This is the first release of the Chinook database. You can see the Chinook database schema <a href="http://www.codeplex.com/ChinookDatabase/Wiki/View.aspx?title=Chinook_Schema">here</a>.<br> <br>The zip file above contains SQL scripts and batch files for each database supported. It also contains the data in XML format (DataSet), see <i>SampleData\ChinookData.xml</i>.<br><h2> Supported Database Servers </h2><ul> <li>SQL Server</li><li>Oracle</li><li>MySQL</li> </ul><h2> How do I Create the Chinook Database? </h2>Download and extract the zip file above. Under the <i>Script</i> folder, there are two files per database server: a SQL script, <i>CreateDB.sql</i>, and a batch file, <i>CreateDB.bat</i>. You can either run the SQL script by using your preferred database tool or run the provided batch file. <br> <br>The batch files use the database server command tool (<i>mysql.exe</i>, <i>osql.exe</i> for SQL Server, and <i>sqlplus.exe</i> for Oracle). If you are using Windows Vista, you should open a Command Prompt window as <i>Administrator</i> in order to run these batch files.<br><h2> Notes for MySQL version </h2><ul> <li>The provided script was tested using MySQL Server 5.0.</li><li>The <i>CreateDB.bat</i> file uses the localhost server, and the <i>root</i> user with the password <i>p4ssw0rd</i>. Change this file to match your settings before running it.</li> </ul><h2> Notes for Oracle Version </h2><ul> <li>The provided script was tested using Oracle Database 10g Express Edition (XE).</li><li>The <i>CreateDB.sql</i> creates a new user <i>chinook</i>, with the password <i>p4ssw0rd</i>. Change this script if you want a different user/password.</li> </ul><h2> Notes for SQL Server version </h2><ul> <li>The provided script was tested using SQL Server Express which ships with Visual Studio 2008.</li> </ul> </div>Mon, 18 Aug 2008 00:56:16 GMTUpdated Release: Chinook Database 1.0 (Aug 17, 2008) 20080818125616A