SQL Data Generator - Summary

by Red Gate Software - Product Type: Application

Summary

SQL Data Generator by Red Gate Software

URLs: red-gate-sql-data-generator, red gate sql data generator, redgatesqldatagenerator, red-gate, red gate, redgate

Automatically populates databases with realistic test data. SQL Data Generator is a test data generator for MS SQL Server databases. With SQL Data Generator you can generate data in one click, creating realistic data based on column and table names. The data can also be customized if desired. SQL Data Generator eliminates hours of tedious work and fully supports SQL Server 2008.

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.

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.

But it is not just about speed. It is also about quality data. SQL Data Generator intelligently creates realistic test data by automatically taking the table and column names into account, along with field length and any existing constraints.

Privacy legislation prohibits the sharing of live sensitive data. So if you want to demo your database to a client or develop your production database, SQL Data Generator can quickly replace the live data with realistic test data so that people will probably not even notice you've made the switch.

Whether you want to future-proof your database by populating it with large quantities of additional data and testing to see if it scales or breaks, or you simply need some starter data to highlight potential improvements to your new schema, SQL Data Generator will automate the tedious, allowing you much more time to run lots of creative tests.

Data can be pulled in from existing data sources and if you really want to show off to your boss or clients the data can be easily customized.

SQL Data Generator feature list:

Generates data that perfectly matches to your database schema

Intuitive, easy to use user interface makes it easy to start populating your database immediately

Intelligently generates appropriate data based on table and column names and data types

Over 60 built in generators with sensible configuration options

Inter-column dependency support, for example to generate records with matching email address and domain name

Very fast data generation through use of the SQL Server’s bulk copy insertion feature.

Support for all SQL Server 2000, 2005, and 2008 data types including CLR types

Command-line support for automated data generation, for example as part of your build process

Foreign key support for generating consistent data across multiple tables with no manual configuration

Seeded random data generation allows you to generate the same collection of data every time

Take data from existing tables to easily create a database containing a sample of your data

Import data from flat files in csv or tsv formats.

Optionally disable triggers and constraints to avoid interfering with database logic

Automatic data conversion when the source data is of a different data type

User defined generators in any .NET language give complete control over the generated data

Automatically populates databases with realistic test data.

Pricing: SQL Data Generator 2.0 1 User License, SQL Data Generator 2.0 5 User License, SQL Data Generator 2.0 10 User License, SQL Data Generator 2.0 with 12 Months of Support and Upgrades 1 User License, SQL Data Generator 2.0 with 12 Months of Support and Upgrades 5 User License, SQL Data Generator 2.0 with 12 Months of Support and Upgrades 10 User License, SQL Data Generator 2.0 with 24 Months of Support and Upgrades 1 User License, SQL Data Generator 2.0 with 24 Months of Support and Upgrades 5 User License, SQL Data Generator 2.0 with 24 Months of Support and Upgrades 10 User License, SQL Data Generator 2.0 with 36 Months of Support and Upgrades 1 User License, SQL Data Generator 2.0 with 36 Months of Support and Upgrades 5 User License, SQL Data Generator 2.0 with 36 Months of Support and Upgrades 10 User License, SQL Data Generator 2.0 Renewal License - 12 Months of Support and Upgrades 1 User Renewal License, SQL Data Generator 2.0 Renewal License - 12 Months of Support and Upgrades 5 User Renewal License, SQL Data Generator 2.0 Renewal License - 12 Months of Support and Upgrades 10 User Renewal License, SQL Data Generator 2.0 Renewal License - 24 Months of Support and Upgrades 1 User Renewal License, SQL Data Generator 2.0 Renewal License - 24 Months of Support and Upgrades 5 User Renewal License, SQL Data Generator 2.0 Renewal License - 24 Months of Support and Upgrades 10 User Renewal License, SQL Data Generator 2.0 Renewal License - 36 Months of Support and Upgrades 1 User Renewal License, SQL Data Generator 2.0 Renewal License - 36 Months of Support and Upgrades 5 User Renewal License, SQL Data Generator 2.0 Renewal License - 36 Months of Support and Upgrades 10 User Renewal License

Evals & Downloads: Read the SQL Data Generator help file, Read the SQL Data Generator Data sheet, Read the Red Gate End User License Agreement, Download the SQL Toolbelt evaluation on to your computer - Expires after 14 days

Operating System for Deployment: Windows Vista, Windows XP, Windows Server 2003, Windows 2000

Architecture of Product: 32Bit

Product Type: Application

Compatible Containers: Microsoft SQL Server 2008, Microsoft SQL Server 2005, Microsoft SQL Server 2000, .NET Framework 3.5, .NET Framework 3.0

Keywords: sql data generator, red gate sql data generator, redgate sql data generator, buy sql data generator, sql data generator distributor, sql data generator reseller

Red Gate Software Red-Gate RedGate

SQL query language

Verification Verify verified Check Checking

Database DB Management

Debugging debug debugs Testing Test Tests

Database DB Reporting Report reports

Part numbers: PC-518609-429111 518609-429111 PC-518609-429112 518609-429112 PC-518609-429113 518609-429113 PC-518609-429114 518609-429114 PC-518609-429115 518609-429115 PC-518609-429116 518609-429116 PC-518609-429117 518609-429117 PC-518609-429118 518609-429118 PC-518609-429119 518609-429119 PC-518609-429120 518609-429120 PC-518609-429121 518609-429121 PC-518609-429122 518609-429122 PC-518609-429123 518609-429123 PC-518609-429124 518609-429124 PC-518609-429125 518609-429125 PC-518609-429126 518609-429126 PC-518609-429127 518609-429127 PC-518609-429128 518609-429128 PC-518609-429129 518609-429129 PC-518609-429130 518609-429130 PC-518609-429131 518609-429131

Mfr. Part No: P66U10M0 P66U10M12 P66U10M24 P66U10M36 P66U1M0 P66U1M12 P66U1M24 P66U1M36 P66U5M0 P66U5M12 P66U5M24 P66U5M36