Last time we created some test data with the tpc-h tool. This time i just want to post a short t-sql to create the database schema.
This site is about business intelligence related stuff which I learn and discover during my work and which I think is useful to remember.About Me
When you are testing databases (i.e. Microsoft SQL Server or MongoDB) or ETL-tools (like Pentaho or SSIS) you often need great amounts of data. The tool tpc-h from the “Transaction Processing Perfomance Council” fits this needs and generates as much data as you need. This should be a short tutorial how to compile the tool an generate some data.