Work with data in Data Editor

Last modified: July 22, 2025

This section explains how to use dbForge Studio’s Data Generator to create realistic test data. It covers setting up and using various built-in generators, populating empty databases, creating custom generators, and running data generation from the command line. Specialized generators include options for credit card types, JSON, passwords, unique identifiers, and numerous region-specific identification numbers.

In this section

• Set up Data Generator
• Use generators
• Generate data for an empty database
• Populate a database
• Create custom generators
• Generate data from the command line
• Exit codes used in the command line for /generatedata
• ABA Routing Transit Number Generator
• Birth Date Generator
• Canadian Social Insurance Number Generator
• Check Constraint Generator
• CODEN Generator
• Constant Generator
• Credit Card Number Generator
• Credit Card Type Generator
• CUSIP Number Generator
• Datetime Generator
• Employment Term Generator
• Federal Employer Identification Number Generator
• Files Folder Generator
• Foreign Key (Auto Assigned) Generator
• Foreign Key (Manually Assigned) Generator
• International Article Number Generator
• International Bank Account Number Generator
• International Maritime Organization Number Generator
• International Mobile Station Equipment Identity Code 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
• JSON Generator
• Lorem Ipsum Generator
• Password Hash Generator
• Post Tracking Number 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
• United Kingdom NHS Number Generator
• United Kingdom Stock Exchange Daily Official List Number Generator
• Universal Product Code Generator
• Vehicle Identification Number Generator
• Weighted List Generators