Small sample database for practicing database administration?

Question

I'm looking for a portable sample database that

• can be created from a script
• has a simple ER model
• has little data for database administration practicing purposes.

I know that there is e.g. Adventureworks, Northwind and pubs sample databases out there, but I'm looking for something smaller.

Any idea where I can find this kind of database?

Answer 1

Take a look at the Dell DVD Store database. It's available for multiple databases, SQL Server included.

The Dell DVD Store is an open source simulation of an online ecommerce site with implementations in Microsoft SQL Server, Oracle, MySQL and PostgreSQL along with driver programs and web applications

Answer 2

Adventureworks database is already setup with flaws that provide good practice.

There is also a BI database offered as well by MS, search for "Contoso BI demo". This database is only offered as a backup file which provides you practice for one vital task that every DBA should know: restore.

There are a ton of data sets on the world wide web that offer practice on building your own "small" database. I am doing this now to practice design, scripting, and working with SSRS.

Answer 3

You can't find more small ones. :-)

Answer 4

Besides the AdventureWorks and AdventureWorks2008 databases which have about 600 objects, there are a couple of smaller MS sample databases: AdventureWorksDW, AdventureWorksDW2008, AdventureWorksLT, AdventureWorksDW2008, each one contains about 150 objects

You can download them here: http://msftdbprodsamples.codeplex.com/