Need hundreds, thousands or millions of rows of test data? Well you probably didn't think to use Data Synchronisation Studio. Why would you, it's a synchronising tool right? Well, yes, this is true. However, Data Sync includes a provider that can generate as many rows as you need. Utilising this, we created a test data generator using dynamic columns. It can create you an entire user base in seconds!
You can download and use Data Sync Studio to see how this solution works and generate some data! Click here to go to the Download page
If you have used Data Synchronisation Studio before, you will be familiar with data source sides A and B. You may also be familiar with the term Dynamic Columns. This test generator works by creating a faux data source on side A using Dynamic Columns. You can then use this to create faux data for Dynamics CRM, SQL, SharePoint etc. to give yourself an instant user base for testing.
How do I use this generator?
This is optional, because it can take a few minutes to generate the rows. This depends on the machine spec and the row count chosen. Below is a basic guide to timings.
10,000 = 1.5s
100,000 = 12s
1,000,000 = 2m
Now that you have setup the generator to your liking, we can go about inserting the data into a usable SQL table. You can choose other data sources, but for this post we'll use SQL.
Go to the tools menu and select create SQL Table.
Follow the instructions of the SQL Table Wizard
Once you've created your new SQL Table, Click 'Compare A->B'
This will compare the generated data with your new table. Obviously your new table is empty, so once the sync has completed you will see a list of items to add to SQL.