5

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?

3
  • 1
    Why smaller?? All of those databases you listed can be scripted and easily ported. Commented Dec 10, 2011 at 13:53
  • Smaller ER model, more easily adopted.
    – jrara
    Commented Dec 10, 2011 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. Commented Aug 21, 2014 at 1:27

5 Answers 5

9

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

4

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.

2
  • What flaws does AdventureWorks have? Commented Dec 11, 2011 at 1:19
  • maybe not flaws necessarily but improvements could be made, guess indexes and such
    – user507
    Commented Dec 11, 2011 at 3:58
1

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

1

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/

0

Use the official sample databases from MySQL: http://dev.mysql.com/doc/index-other.html.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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