ApexSQL Generate generates test data for specified columns and tables. It exports test data to SQL, XML, JSON, and CSV files, or execute it directly against the database. Use a wide range of predefined options to customize the data, like setting the seed, length, minimum and maximum values, uniqueness of data, and percentage of null values. Preview generated data before executing or exporting. Ability to quickly generate millions of rows. Use different generators such as Random, Incremental, From list, Table, Directory, Query, CSV and Predefined generators. Intelligent auto-creating of data patterns at row level. Supports a wide variety of data types, including geography, money, and hierarchyid. Possibility to save project as batch script for automatic execution. Features:

Instant database population Export data into SQL, JSON, XML or CSV Execute test data directly against the database Generate data with different generators such as Random, Incremental, From list, Table, Directory, Query, and CSV Replicate previously generated data Import from existing data sources Support for SQL Server 2016, 2014, 2012, 2008 R2, 2008 and 2005 Full CLI support 200+ predefined generators Save project as batch script