dbForge Data Generator for SQL Server

dbForge Data Generator for SQL Server is a user-friendly application that allows you to generate and manage large amounts of data in Microsoft SQL Server.

The program allows you to work in a comprehensive, graphic environment, which makes it accessible for many types of users. Moreover, the program supports several column data types.

dbForge Data Generator for SQL Server allows you to create separate tasks for each table test data set you wish to work with.

It supports various types of column data and enables you to define entire tables, set value ranges, customize parameters for each column or preview the data before you create it.

Each task for data generation includes the SQL script, which you may view, edit or save for further usage. The software can thus facilitate the creation of entries in the selected database, by populating the tables, columns, rows with highly customizable templates.

The data you can enter is categorized by its type and can be related to geography, geometry, hierarchyID, datatime2 and datatimeoffset. You may set value distribution modes, minimum and maximum thresholds, as well as enable data repetition or uniqueness.

You may work with individual generators for customizing each supported data type: the number of NULL rows, data uniqueness, value ranges and value distribution modes. You may immediately save the SQL script that defines the data generation/population, for further usage or editing.

Alternatively, after configuring all the parameters, you may easily execute the generated data against a database saved with in SQL Server. dbForge Data Generator for SQL Server features a wizard function, designed to guide you through all the stages in the script execution process.

The software supports data encryption and can record the entire activity in a log, that you can consult at any time. Moreover, dbForge Data Generator for SQL Server allows you to supervise the execution of each query or script, as well as instantly edit data, from almost any window.