SQL Data Generator - 2.0
Getting Started - SQL Data Generator
SQL Data Generator enables you to populate selected tables and entire databases with realistic data. You can populate empty tables, or add extra rows to your existing data.
This is useful when you have a table or database that you want to populate, and no live data that you can use. For example, you may want to create a large database of test data so that you can perform nunit or performance tests on a new product. Or you may have live data you do not want to use all of; for example, you may want to replace the data in a credit card number column with randomly-generated data. With SQL Data Generator, you can do this by importing some of the data from existing SQL tables or CSV files, while generating the other columns or tables.
You can use SQL Data Generator to populate SQL Server 2008 and 2008 R2, SQL Server 2005, and SQL Server 2000 databases.
You can use SQL Data Generator to:
- Generate data for all supported SQL Server data types, using the standard generators supplied.
- Customize the generators to suit your specific needs.
- Create a new generator based on one of the supplied generic data generators.
Technical notes
SQL Data Generator automatically assigns a generator to each column based on information such as table name, column name, data type, and any constraints; otherwise the Regular Expressions Generator is assigned.
There are over 80 pre-configured generators, supporting all SQL Server 2008 data types. These are detailed in the list of generators and the data types they support.
You must have administrator privileges for the database that you want to populate.
Getting more information
- Find out what's new in this version
- Find out about activating SQL Data Generator.
- How can I check for updates to SQL Data Generator?
- Find out more about Red Gate.
See also |
Was this article helpful?
Using SQL Data GeneratorSQL Data Generator
- Creating random GUIDs in SQL Data Generator
- Conforming to unique constraints in SQL Data Generator
- Generating data in improperly-named column causes System.InvalidOperationException
- Self-referencing table constraints can cause generation to stop
- Logging and log files
all SQL products
- Compatibility of Red Gate tools in 64-bit environments
- Application has encountered an error and needs to close
- Error message after installing SQL Toolbelt - The description for Event ID ( 1 ) in Source ( nview_info ) cannot be found.
- Changing the temporary directory used by the installer
- Toolbelt Installer "hanging" while "scanning volumes"
- Login failing with "trusted SQL Server connection" error when using RunAs
all products
- Some Red Gate products identified as containing a trojan by Anti-Virus software
- Activation may fail with Unknown Error -1
- Product uses web help although a CHM file is available locally
- Argument exception resulting from missing environment variable
- Check for updates may fail when used through proxies
- 'Unidentified Publisher' error when repairing or uninstalling
- Licensing activates product as standard edition
- Moving Red Gate software products to another machine
- Red Gate tools log locations
- The application UI opening slowly when there is no internet access
SQL Data Generator
- Activating your products
- Activating your products
- Getting help offline
- Cleansing or removing sensitive data from an existing data source
- SQL Data Generator release notes - version 1.xx
- SQL Data Generator release notes - version 2.xx
all SQL products
all products
- Red Gate product acknowledgements
- Activating your products
- Activating your products
- Red Gate bundle history
- Check for updates
- Troubleshooting Check for Updates errors
- Current versions
- Deactivating your products
- Installing Red Gate products from the .msi file
- Requesting additional activations
- Serial numbers for bundles
- Reactivating using a different serial number
- Extending your trial
- Finding your serial numbers
- Moving a serial number from one computer to another
- No response received for manual activation
- Licensing and activation resources
- Licensing and activation resources
- Troubleshooting licensing and activation errors
- Licensing and activation FAQs
- Red Gate tools log file locations
- Download old versions of products
- Download product prerequisites & utilities
- Support & upgrades
- Upgrading your software
- Upgrading FAQs
