ApexSQL Generate v2020.02.0375 官方版

ApexSQL Generate is a powerful SQL test data generator that supports a wide range of SQL data types. It is capable of generating test data for specific tables at a high speed, capable of producing millions of rows in a short span of time.

Software Features:

Custom SQL Test Data Generation: Generate SQL test data specifically for selected tables.

Data Export: Export test data to SQL, XML, CSV, JSON, and Excel formats.

High-Speed Data Generation: Rapidly generate millions of rows of test data.

Detailed Customization: Customize test data scenarios with comprehensive options.

Support for Various SQL Data Types: Compatibility with numerous SQL data types.

Generator Selection: Choose from various generators (random, directory, etc.).

Foreign Key Constraint Support: Maintain data consistency based on foreign key constraints.

Realistic Test Data Simulation: Simulate realistic test data scenarios.

Software Highlights:

Comprehensive SQL Server Data Type Support: Generate test data across all SQL Server data types.

Predefined Generators: Utilize over 150 predefined generators for meaningful data, such as names, addresses, credit card numbers, and social security numbers.

Cross-Column Dependency Support: Use predefined rules, string arrays, date, and data functions to generate test data based on the values of other columns.

Customization: Define data using various predefined options, including seed, length, minimum and maximum values, uniqueness, and percentage of null values.

User-Defined Generators: Save generator settings for reuse in future test data generation.

Table Projection: Use intelligent column recognition patterns to populate tables with data from external sources (e.g., other database tables, views, or CSV files).

Trigger and Constraint Handling: Manage triggers and constraints to prevent data inconsistencies.

Referential Integrity Support: Include or exclude dependent targets during the generation process.

Export Options: Execute generated data or select one of the export options for the database.

Data Preview: View generated data before execution or export.

GUI Alerts: Display errors, warnings, and informational messages in the tree view and browse panels, including incorrect generator settings, cyclic dependencies, constraint violations, and information about DELETE triggers enforced on selected columns.

Progress Tracking: Monitor progress, potential errors, and the number of successfully inserted rows into the database, as well as the duration of the generation process.

Modular Test Report Templates: Inherit from existing database settings to build test data generation scenarios.

Command-Line Interface: Fully automate the test data generation process.

Visual Themes: Customize the appearance with various page themes.

How to Use ApexSQL Generate:

Installation: Install ApexSQL Generate on your system.

Project Setup: Create a new project and select the database you want to generate test data for.

Table Selection: Choose the tables for which you want to generate test data.

Generator Configuration: Configure generators for each column, selecting from predefined generators or creating custom ones.

Customization Options: Customize your data generation settings, such as data ranges, null values, and uniqueness.

Preview and Generate: Preview the data to ensure it meets your requirements, then generate the test data.

Export and Execution: Export the generated data to your desired format or execute it directly into your database.

By following these steps, you can effectively use ApexSQL Generate to produce high-quality test data for your SQL databases, ensuring that your applications are thoroughly tested and optimized for performance.