Data Generator for SQL Server
  • Documentation center

  • Table of Contents

  • Get started
    • Why choose Data Generator
      • Boost the productivity of database testing
      • Gain more control
      • Automate routine tasks
      • Ensure data integrity
    • Copyright information
    • Requirements
    • Installation
      • How to install dbForge Data Generator
      • Install Data Generator from the command line
    • Updates
    • Licensing and activation
      • Licensing
      • Activation
      • Deactivation
      • Activation troubleshooting
    • Third-party software
    • How to run Data Generator on Linux & macOS
      • How to install dbForge Data Generator on Linux & macOS
      • Manual installation of dbForge Data Generator via CrossOver
      • Command-line mode on Linux
      • Command-line mode on macOS
  • Generate data
    • Connect to a database
    • Use Microsoft Entra Authentication
    • Set generation options
    • How to register dbForge Data Generator for SQL Server as a Microsoft Entra ID application
    • Table generation settings
    • Column generation settings
    • Preview generated data
    • Set databases in SSMS
    • Generation warnings
    • Import and export settings
  • Use generators
    • Basic generators
      • Check Constraint Generator
      • Constant Generator
      • Datetime Generator
      • Files Folder Generator
      • Foreign Key (Auto Assigned) Generator
      • Foreign Key (Manually Assigned) Generator
      • JSON Generator
      • Lorem Ipsum Generator
      • Python Generator
      • Regular Expression Generator
      • Shuffled Text Generator
      • SQL Query Generator
      • String Generator
      • Table or View Generator
      • Text File Generator
      • Twaddle Generator
      • Uniqueidentifier Generator
      • Weighted List Generators
    • Meaningful generators
      • Birth Date Generator
      • Canadian Social Insurance Number Generator
      • ABA Routing Transit Number Generator
      • CODEN Generator
      • Credit Card Number Generator
      • Credit Card Type Generator
      • CUSIP Number Generator
      • Employment Term Generator
      • International Article Number Generator
      • International Bank Account Number Generator
      • International Mobile Station Equipment Identity Code Generator
      • International Maritime Organization Number Generator
      • International Mobile Station Equipment Identity Code Software Version Generator
      • International Securities Identification Number Generator
      • International Standard Book Number Generator
      • International Standard Music Number Generator
      • International Standard Serial Number Generator
      • IPv4 Address Generator
      • Password Hash Generator
      • Post Tracking Number Generator
      • United Kingdom NHS Number Generator
      • Universal Product Code Generator
      • United Kingdom Stock Exchange Daily Official List Number Generator
      • Federal Employer Identification Number Generator
      • Vehicle Identification Number Generator
    • Customize existing generators
    • Create new generators
    • Python script examples
    • Data Generator in the DevOps process
  • Populate databases with data
    • Manage data population scripts
    • Set population options
    • Select additional scripts
    • Review the action plan and warnings
  • Work with particular cases
    • Populate tables with constraints
    • Populate a self-referencing-table
    • Populate tables with a circular reference
    • Populate a table referencing another table that already contains data
  • Use the command line
    • Generate data
    • Schedule data generation
    • Execute scripts
    • Command line syntax
      • Switches used in the command line
      • Exit codes used in the command line
    • Command Line Wizard
  • Set up dbForge Data Generator
    • Import and export settings
    • Customization options
    • Assign keyboard shortcuts
    • How to check the account that the SQL Server Agent is using
  • Other tasks
    • Write and execute SQL statements
      • SQL Editor overview
      • Write SQL statements
      • Execute SQL statements
      • View server messages and errors
      • Use parameters
      • Execute large scripts
      • SQL document shortcut keys
      • Format SQL code
        • Work with SQL formatting
        • Customize formatting styles with profiles
        • Share custom formatting profiles
        • Formatting options
      • Find and Replace
        • Find text with regular expressions
        • Wildcards for Find and Replace
        • Find text in files
        • Find Results
        • Replace text in files
    • View and edit data
      • Results output patterns
      • View and edit data in the Grid View mode
      • View and edit data in the Card View mode
      • Sort and group data
      • Hide columns and filter data
      • How to copy data from the results grid
      • Auto-search mode
      • Server-side and client-side sorting and filtering
      • Data Editor shortcuts
  • Release notes and other versions
    • dbForge Data Generator for SQL Server release history
    • Data Generator v7.0 release notes
    • Data Generator v4.6 release notes
    • Data Generator v4.5.19 release notes
    • Data Generator v4.5.16 release notes
    • Data Generator v4.5.10 release notes
    • Data Generator v4.5.5 release notes
    • Data Generator v4.4 release notes
    • Data Generator v4.3.68 release notes
    • Data Generator v4.3 release notes
    • Data Generator v4.2 release notes
    • Data Generator v4.1 release notes
    • Data Generator v4.0 release notes
    • Data Generator v3.11 release notes
    • Data Generator v3.10 release notes
    • Data Generator v3.9 release notes
    • Data Generator v3.8 release notes
    • Data Generator v3.7 release notes
    • Data Generator v3.6 release notes
    • Data Generator v3.5 release notes
    • Data Generator v3.0 release notes
    • Data Generator v2.0 release notes
Devart
© 1997 - 2025 Devart. All rights reserved.