Tested with Oracle Database 10g Express Edition (XE).
Change this file to match your settings before running it. The CreateMySql.bat script uses localhost server with the following user/password: root/p4ssw0rd.It is recommended to open a Command Prompt window as Administrator in order to run these batch files.įor embedded databases, SQLite and SQL Server Compact, it is also provided the embedded database files in addition to the SQL script files. These batch files use the database server command tool ( mysql.exe for MySQL, sqlcmd.exe for SQL Server, sqlplus.exe for Oracle, and sqlite3.exe for SQLite). You can run these SQL scripts with your preferred database tool.įor SQL Server, Oracle, MySQL and SQLite, there are available batch files that will execute the respective SQL script(s). It is provided one or more SQL script file for each database vendor supported.
#SQLITE DATABASE DOWNLOAD DOWNLOAD#
How do I Download and Create the Chinook Database?ĭownload the files from the Downloads page. Chinook is a good name choice for a database that intents to be an alternative to Northwind. Chinooks are most prevalent over southern Alberta in Canada.
Chinooks are winds in the interior West of North America, where the Canadian Prairies and Great Plains meet various mountain ranges. The name of this sample database was based on the Northwind database. Sales information is auto generated using random data for a four year period. It is possible for you to use your own iTunes Library to generate the SQL scripts, see instructions below.Ĭustomer 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.). Media related data was created using real data from an iTunes Library. The Chinook data model represents a digital media store, including tables for artists, albums, media tracks, invoices and customers. Chinook database is an alternative to the Northwind database, being ideal for demos and testing ORM tools targeting single and multiple database servers. It can be created by running a single SQL script. Chinook is a sample database available for SQL Server, Oracle, MySQL, etc.
0 kommentar(er)
