EMS Data Generator para SQL Server

What is EMS Data Generator para SQL Server?

EMS Data Generator for SQL Server is an impressive tool for generating test data in SQL Server database tables, with the ability to save and edit scripts.

The utility can help you simulate the database production environment and lets you populate multiple SQL Server database tables with test data simultaneously, define tables and fields to generate data, define value ranges, generate SQL Server character fields by mask, set value lists manually, or select them in SQL queries,  define generation parameters for each field type and has many other features to generate SQL Server test data simply and directly. Data Generator for SQL Server also provides a console application, which allows you to generate SQL Server test data with one touch, using generation models.

Core features

• Unicode support.
• Wizard-friendly interface.
• Ability to save and edit data generated in sql script without running queries on the server.
• Support for all sql server data types, including uniqueidentifier, BIT, SQL_VARIANT, and TIMESTAMP types.
• Different generation types for each field, including list and random generation, generation in two and more fields simultaneously.
• Ability to use SQL query results as a list of values for data generation.
• Ability to view the generated data.
• Automatic referential integrity control for linked tables.
• Ability to disable triggers of tables generated during the generation process.
• Wide variety of generation parameters for each field type.
• Ability to set NULL values for a given percentage of cases.
• Ability to save all generation parameters defined in the current wizard session in a configuration file.
• Command-line utility for generating data using the template file.

System Requirements

• Microsoft Windows XP, Microsoft Windows Server 2003, Microsoft Windows Server 2008, Microsoft Windows Server 2008 R2, Microsoft Windows Server 2012, Microsoft Windows Server 2012 R2, Microsoft Windows Server 2016, Microsoft Windows Vista, Microsoft Windows 7, Microsoft Windows 8 / 8.1, Microsoft Windows 10
• 20 MB of available HD space for program installation
• MDAC (Microsoft Data Access Components) ou SQL Server Native Client
• Possibility to connect to any local or remote SQL Server