Where to find free-to-use, complex test databases?

Question

I need a database for testing a data masking solution. Any database would do (Oracle/MSSQL flavor). I just need the schema / db definition. I have tools to generate data records. The magnitude of database I am looking should have 30 odd tables with 30 odd columns in each table - a HUGE database.

Do freely available complex database /schema definitions exist on the internet? If yes, where do I find them?

Why is having 30 tables and 30 columns per table a HUGE database? By that measure I'm working on a REALLY HUGE GIGANTIC database right now :) — Jeffrey Kemp, Apr 09 '10 at 00:53

score 3 · Answer 1 · answered Apr 08 '10 at 09:28

3

Not as complex as you want but Chinook DB is a free sample database that supports Oracle among others.

answered Apr 08 '10 at 09:28

softveda

10,858
6
42
50

I guess I will need a more complex schema – Jay Apr 08 '10 at 09:39

score 1 · Answer 2 · answered Apr 08 '10 at 09:32

1

The good ol' NorthWind. Here r the oracle scripts http://jagchat.spaces.live.com/blog/cns!41050F68F010A662!758.entry

answered Apr 08 '10 at 09:32

Midhat

17,454
22
87
114

score 1 · Accepted Answer · answered Apr 08 '10 at 09:48

1

There are various iterations of the AdventureWorks schema for SQL 2005/2008 available.

answered Apr 08 '10 at 09:48

Ed Harper

21,127
4
54
80

Where to find free-to-use, complex test databases?

3 Answers3