Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
Why smaller?? All of those databases you listed can be scripted and easily ported. – Thomas Stringer Dec 10 '11 at 13:53
Smaller ER model, more easily adopted. – jrara Dec 10 '11 at 14:16
Smaller than pubs? It only has 10 tables with 20s of rows in each. Any smaller is too trivial and worthless for learning. – Greenstone Walker Aug 21 '14 at 1:27
up vote 6 down vote accepted

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

share|improve this answer

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.

share|improve this answer
What flaws does AdventureWorks have? – Thomas Stringer Dec 11 '11 at 1:19
maybe not flaws necessarily but improvements could be made, guess indexes and such – Shawn Melton Dec 11 '11 at 3:58

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

share|improve this answer

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:

share|improve this answer

Use the official sample databases from MySQL:

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.