Instead, let’s begin by deselecting the tables we don’t want to generate data for in the “Tables to populate” panel: We could just generate everything right now but that would make for a very short blog post and not fully demonstrate the full power of the tool. We than land up on a screen consisting of three panels allowing us to configure the data generation. Project setup is a piece of cake just point it at a server and choose a database: Yep, 91,000 customers with 830,000 orders containing 2,155,000 order details across 77,000 products managed by 9,000 employees. Lightweights! Let’s turn this up by, oh, a factor of one thousand. Out of the box, Northwind gives you 91 customers with 830 orders containing 2,155 order details across 77 products managed by 9 employees. Why these four? Because they’re very atypical of many apps, they span a good range of both SQL data types and logical data values and there’s a bunch of relational integrity going on to make things interesting. In particular, I want to focus on these four tables: Moving on, we’re going to use SQL Data Generator (normally a $295 spend), to push a whole heap of data into your classic Northwind database.
0 Comments
Leave a Reply. |