Two million rows of intelligent data for 10 tables in less time than it takes to get a cup of coffee

CAMBRIDGE, UK, April 1, 2008 – Red Gate Software has released SQL Data Generator, a new tool that automatically populates MS SQL Server databases with intelligent and meaningful test data.

"In less than the time it took me to get a cup of coffee, SQL Data Generator created a database with 2 million rows of data for each of 10 tables," says Stephanie Beach, QA manager for Certica Solutions.  "This tool not only allows me to make large databases with varied data types, it is smart enough to create logical data such as months, cities and dates.  With its ease of use, logical user interface, smart data creation, and speed, it's the best data generator I've ever used."

SQL Data Generator replaces the hours of manually populating databases with a one-click solution: Select the database and SQL Data Generator populates it with realistic test data by automatically assigning an appropriate generator based on column names.  Test data can also be easily customized.

"Database developers need data for testing, but often cannot use live data because of privacy issues," says David Connell, SQL Data Generator project manager.  "The higher the quality of data, the easier it is to develop an application.  SQL Data Generator provides the high-quality data and makes it simple to quickly populate databases with anything from a few thousand to millions of records."

In addition to developing new applications, SQL Data Generator makes it easy to test database capacity and determine future server requirements, and to demonstrate products to clients without revealing sensitive data.

"It used to take me hours to generate useful test data," says Michael Gaertner of Quintech.  "With SQL Data Generator, I generated better data in only half an hour, and after initial customization was done, in only seconds with just one click."

Is it real or SQL Data Generator?

SQL Data Generator populates databases with intelligent data at the click of a mouse. Click on the databases below (the customer table from the Northwind database) to view them at full size and see if you can spot the difference between the real and SQL Data Generator data.

A demo, walkthrough and fully functional 14-day trial download of SQL Data Generator can be found at www.red-gate.com/products/SQL_Data_Generator/.

About Red Gate Software

Red Gate Software makes ingeniously simple tools for Microsoft technology developers and DBAs. The company's product line includes tools for testing, comparing, synchronizing, packaging, backing up and recovering SQL Server databases; understanding and fixing Visual Studio code problems to enable better performance; and profiling .NET web applications. Red Gate is a silver sponsor for the Visual Studio 2005 launch and a Visual Studio Industry Partner.