CornerstoneDB Data Generator

Dynamically generating test data into a database is a task needed at least once during the development cycle of any software application that saves information for later use. Whether performed by the developer or DBA, data generation in most cases is a time consuming process.

Why do you need to generate test data?

During the development cycle of a database application, developers often need real world data to test functionality of their product.

Interface Testing

One common case scenario is the design and implementation of UI user controls. Having unique test data to design controls like grid views, tree views, and custom controls can lend greatly to a cleaner product.

Unit Testing

Another useful scenario that is often overlooked is unit testing. Proper unit testing should always include the methods that perform CRUD operations in your application. Unique and repeatable data generation from an API built into your unit tests can lend a helping hand when testing these methods.

Introducing a new Data Generation Tool

The Data Generation Tool from CornerstoneDB was created to simplify and improve functionality where other tools on the market have fallen short.

SQL Data Generator UI Screenshot

Wide range of example data

We offer the ability to generate a wide range of test data including unique values, default column values, foreign key values, and auto incrementing keys.

The Data Generation Tool can generate all major data types, as well as custom types like first and last names, cities, states, countries, or provide your own data in a CSV or flat file.

Setup with a UI, run with an Application

You can generate test data within our WinForms UI or using code with our Data Generation API.   See the Data Generation API Sample page.

The Data Generation Tool offers the ability to save generation projects in XML form to be ran later from CLI or Unit test.

This allows you to setup the Data Generation project in an easy to use application, but then automate the running of the project over and over without needing to use the user interface directly.

Developer Productivity

Why waste developer time writing data generation scripts, debugging them, and then maintaining that code that has no benefit to your end users?  Leverage our API to increase developer productivity and simplify the generation process.

Desktop or Royalty Free Generation API

You can build applications that use our API and then ship them royalty free to your own customers!  Or you can simply use the desktop UI and run it locally.  We offer two different SKUs depending upon your needs.

Databases Supported

  • Microsoft SQL Server 2005/2008/2008R2
  • Microsoft SQL CE 3.5
  • VistaDB 4
  • MySql 5

We Need Your Feedback

The Data Generator is in beta, and we are seeking feedback from database developers.

Each user who submits feedback will be entered to win a free copy of the final shipping tool, and be invited to participate in the beta. The beta is limited to 100 users.

Submit Product Feedback

Signup for a trial

Would you like to try one of our database tools?  Visit the trial signup page for complete information.