This is just such a fun tool, I had to post about it.
So we often need to generate some test data to work with – be it for ETL, database or reporting work. There used to be a generate data tool in SSDT, which was good in that it tested boundary limits, but it did create just a bunch of nonsense. For example, strings would be random characters covering the full string length, integers would cover the full limit – 2,147,483,647. If you never get numbers or strings like that in your data, formatting for them in a report, for example, is just silly.
In comes Mockaroo, which, as they say on the site: “…lets you generate up to 1,000 rows of realistic test data in CSV, JSON, SQL, and Excel formats.” What do they mean by realistic? Lets look at some of the data types (depicted below). There is email address, street address, country, currency, date, color, sequence, guid, various versions of name including European and Chinese, lat / long, and my favorite – “Naughty String” – because no data behaves properly.
You have the ability to introduce random nulls as well, so you wind up with some very realistic data sets. When I made a request for SQL output, it generated inserts statements: