9

Well, what alternative sample databases exist that have:

  • an un-restrictive license
  • loads of sample data
  • lots of data types
  • a simple mechanism for adding the database to a db server
  • are not Northwind

I'm not too fussed what server type (MSSQL, SQLite, MySQL, etc.) the db is designed for.

grenade
  • 31,451
  • 23
  • 97
  • 126

5 Answers5

7

How about

Chinook Database

See also Chinook Database Schema

Adriaan Stander
  • 162,879
  • 31
  • 289
  • 284
  • Lot's of good answers, but using a simple sql script to create the db and populate it is the nicest cross platform solution for our environment. – grenade Jan 25 '10 at 16:23
5

Microsoft do another set of sample databases called AdventureWorks (these are often used in MS courses). They canbe downloaded from here for SQL 2005 http://www.microsoft.com/downloads/details.aspx?FamilyID=e719ecf7-9f46-4312-af89-6ad8702e4e6e&displaylang=en#Overview.

I'm not sure how much sample data is shipped with it though!

Dave7896
  • 829
  • 5
  • 11
3

This looks promising: http://www.databaseanswers.org/data_models/

Klaus Byskov Pedersen
  • 117,245
  • 29
  • 183
  • 222
1

i love AdventureWorks, there's also a diagram available

1

Here are some MS sample databases from CodePlex, called AdventureWorks.

Oded
  • 489,969
  • 99
  • 883
  • 1,009