views:

70

answers:

3

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?

+1  A: 

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

Pratik
I guess I will need a more complex schema
Jay
+1  A: 

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

Midhat
+1  A: 

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

Ed Harper
something for oracle too, pls?
Jay
@Ed this is good stuff. It works perfectly well for MS SQL 2005/2008. Thanks for this. Btw, any thing on oracle?
Jay