Paylocity recently published an article about the open-source MassDataHandler. This framework assists with testing the database.
We've also uploaded version 1.3, which offers several new features:
- Improved handling of identity values and triggers: (1) Triggers no longer break the identity inserts, (2) You can specify identity inserts for a table-by-table basis using an Xml attribute on the Table element, (3) If you set IdentityInsert=On for a table without Identity, then it no longer crashes.
- Improved extracting from existing data: (1) The Existing Data tab can now use a custom select that returns many tables, and (2) When using Existing Data tab, if you use a Custom filter, it will copy your Sql select values into the Xml file as a meta node.
- Some miscellaneous bug fixes and enhancements.
You can download the framework on Microsoft's CodePlex site.