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.
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.