dbForge Data Generator for SQL Server Revision History

2026.1.77 25-Jun-2026

User-reported bug fixes

  • Fixed a false-positive syntax error triggered by Transact-SQL expressions referencing objects named window
  • Added the MFA Application ID to the settings export
  • Resolved clipboard data corruption when copying HTML data with duplicate column names

2026.1.39 15-May-2026

Improvements

  • Added support for SSMS 22.6

2026.1.31 11-May-2026

AI Assistant

  • Improved AI Assistant by adding support for database index metadata

Text Editor

  • Added the Enclose identifiers in quotes feature to the SQL Editor
  • Added indexed column icons in Quick Info

Improvements

  • Added the ability to pin document tabs
  • Added the ability to restore document tab order
  • Enabled data generation for columns with unsupported data types

User-reported bug fixes

  • Fixed an issue where the document database was lost for recovered documents
  • Fixed the behavior of the "SQL Look In" option in the Find and Replace control
  • Fixed MFA authentication when connecting under different user accounts
  • Fixed an error in the data editor that occurred when executing a modified query before the previous query had finished fetching data
  • Updated the installation wizard to not display the "Successful Install" page during dbForge product updates
  • Fixed the auto-hint behavior for server selection on the Connection form
  • Improved saving of window layouts and restoration of window positions after restarting the Studio

2025.3.149 25-Mar-26

User-reported bug fixes

  • Fixed the Look In drop-down list in the Find and Replace window

2025.3.107 12-Feb-26

User-reported bug fixes

  • Several minor bugs are fixed

2025.3.93 29-Jan-26

User-reported bug fixes

  • Added support for the FORCESEEK table hint in FROM clauses for the Text Editor

2025.3.61 24-Dec-25

Text Editor Improvements

  • Added scroll bar annotations
  • Added an option to automatically surround selections
  • Added camelCase formatting for identifiers

Other Improvements

  • Added support for SSMS 22

User-reported bug fixes

  • Fixed an issue with generating data using Python (#218777)
  • Fixed an issue where floating-point values lost precision when copied to Excel

2025.2.138 20-Nov-25

User-reported bug fixes

  • Added functionality to reset nullable columns to null when clicking Clear in the date editor calendar

2025.2.109 31-Oct-25

User-reported bug fixes

  • Resolved an issue with displaying the tooltip for a document bookmark, where the tooltip window overlapped the document bookmark

2025.2.91 23-Oct-25

User-reported bug fixes

  • Fixed an exception caused by empty values in the parameter input form in SQL Document
  • Fixed an issue with clearing the DataViewer

2025.2.37 23-Sep-25

Connectivity

  • Enhanced authentication capabilities for SQL Server when using Entra ID
  • Added support for Microsoft Fabric

AI Assistant

  • Introduced automatic error submission from the Error List to AI chat for detailed explanations and suggested fixes
  • Added a Web Search option in the AI Assistant chat, allowing searches across Devart documentation, website, and blog
  • Added tooltips to the SQL document tab, showing connection and database names, document owner, full file path, and server version
  • Introduced the ability to customize the position where new document tabs open
  • Added Alt+Up and Alt+Down shortcuts to move selected lines up or down in the SQL document
  • Added the Ctrl+Shift+A shortcut to select the entire statement in the SQL document, including all related keywords, operators, and values

Improvements

  • Improved encryption capabilities
  • Added tooltips to the SQL document tab, showing connection and database names, document owner, full file path, and server version
  • Introduced the ability to customize the position where new document tabs open
  • Added Alt+Up and Alt+Down shortcuts to move selected lines up or down in the SQL document
  • Added the Ctrl+Shift+A shortcut to select the entire statement in the SQL document, including all related keywords, operators, and values
  • Added full support for the OPENROWSET function in Syntax Check

User-reported bug fixes

  • Resolved an issue where the Data Viewer content was lost when switching focus between tool windows

2025.1.230 21-Aug-25

User-reported bug fixes

  • Fixed an issue that caused the suggestion list to close when typing numbers

2025.1.186 21-Jul-25

User-reported bug fixes

  • Fixed an issue with long file names
  • Removed opening the connection on the main thread when opening the parameter input form
  • Fixed an issue with the automatic display of Data Editor: when the Activate Data Editor after query execution option is enabled, Data Editor now opens automatically after a query runs, even if no data is returned

2025.1.134 23-Jun-25

User-reported bug fixes

  • Fixed column alias suggestions in INSERT ... SELECT expressions

2025.1.124 16-Jun-25

AI Assistant is added

  • Context-aware query generation
  • Conversion of natural language to SQL
  • Query optimization
  • SQL explanations
  • SQL troubleshooting
  • Error analysis and recommendations
  • AI chat
  • Integration with the dbForge tools

Connectivity

  • Added support for dedicated and serverless SQL pools in Azure Synapse Analytics

Improvements

  • Updated color palettes for the Light and Dark skins
  • Refined font rendering and the coloring of syntax errors
  • Added Brief View to the Start Page to switch between displaying full paths to recent files and a more compact list
  • Supported integration with SSMS 21.0

User-reported bug fixes

  • Several minor bugs are fixed

7.1.63 14-May-25

Improvements

  • Supported integration with SSMS 21.0 Preview 7

User-reported bug fixes

  • Several minor bugs are fixed

7.1.45 18-Apr-25

Improvements

  • Supported integration with SSMS 21.0 Preview 6

User-reported bug fixes

  • Fixed an error with reading the database list when connecting to the server

7.1.37 07-Apr-25

Improvements

  • Added support for SQL Server 2025
  • Supported integration with SSMS 21.0 Preview 5
  • Supported compatibility with Windows Server 2025

User-reported bug fixes

  • Several minor bugs are fixed

7.0.362 07-Mar-25

User-reported bug fixes

  • Added support for data filtering in Data Editor for SELECT queries with an ORDER BY clause
  • Optimized the execution of the Export to CSV command in the Query History window

7.0.249 14-Nov-24

User-reported bug fixes

  • Several minor bugs are fixed

7.0.210 18-Oct-24

User-reported bug fixes

  • Several minor bugs are fixed

7.0.158 05-Sep-24

Improvements

  • Added a new option Append timestamp to the file name in Data Population Wizard
  • Added new shortcuts to facilitate search for the required tables and columns

Connectivity

  • Renamed the Azure Active Directory authentication type to Microsoft Entra ID
  • Added support for ApsaraDB

DevOps & CLI Automation

  • Added generation of comparison reports from the command line

SQL Query History

  • Redesigned the SQL Query history toolbar with an updated date range selection and a new Clear button
  • Added the ability to save user-defined column layouts in Query History

Documents

  • Added options to rearrange tab opening order
  • Added new options in Tabs and Windows: Tab layout, Show tabs in multiple rows, and Close tabs with middle-click
  • Added a new shortcut CTRL+SHIFT+/ that comments selected pieces of code

Data Editor

  • Added an option to set a cell value to a unique identifier from the shortcut menu

User-reported bug fixes

  • Resolved application startup error (#96079, #107064, #107772)
  • Updated automatic generators to recognize ContactFName as a first name and ContactLName as a last name (#94146)
  • Fixed an error that occurred during caching while generating data (#144745)
  • Fixed an issue with the Weighted List data generator (#127574, #127578)

4.6.2 12-Apr-24

Improvement

  • Integration support for SSMS 20.x

User-reported bug fixes

  • Several user reported minor bugs are fixed

4.5.28 28-Dec-23

User reported bug fixes

  • Several user reported minor bugs are fixed

4.5.26 12-Jul-23

User reported bug fixes

  • Fixed an error that occurred when the SQL document was closed while processing the parameter list for functions
  • Expanded the list of conditions in the Filter Editor for columns of type int in the Data Editor
  • Resolved a freezing issue that occurred when editing values in large tables in Data Editor

4.5.22 12-May-23

User reported bug fixes

  • Several user reported minor bugs are fixed

4.5.19 30-Dec-22

New features and improvements

  • Support for macOS & Linux via CrossOver

User reported bug fixes

  • Fixed a bug that occurred when configuring the Table or View generator

4.5.16 12-Sep-22

New features and improvements

  • Connectivity support for SQL Server 2022 CTP 2.1

4.5.10 20-Jul-22

New features and improvements

  • SSMS v19 Preview 2 integration is added

4.5.5 17-Jun-22

New features and improvements

  • Added support for new functions in the Completion List, Quick Info, and Parameter Information: GREATEST, LEAST, CURRENT_TIMEZONE, CURRENT_TIMEZONE_ID
  • Added support for the FORMATFILE_DATA_SOURCE parameter for bulk_options in the OPENROWSET function

User reported bug fixes

  • Fixed an issue with defining columns in a script for Python Generator in Data Generator (#79913)
  • Other user reported bugs are fixed

4.4.5 21-Dec-21

New features and improvements

    • Improved the behavior of data sorting in Data Editor
    • Added the ability to resize the search text field
    • Added a warning when trying to save read-only files with the applied changes

    4.3.68 10-Sep-21

    New features and improvements

    • Ability to simultaneously connect with different ApplicationIDs to Azure SQL Server

    User reported bug fixes

    • Error during the data generation for the tables with composite primary keys
    • Error with canceling the operation in Data Editor
    • Improved behavior with the active Paste As New Records command in Data Editor
    • Improved behavior of active control of changing the current database when executing the query in SQL Document
    • Coloring of cells with the NULL values in Data Editor
    • Error when completing the procedure with parameters in Data Editor
    • Error when executing a query with parameters of the Date type in Paginal Mode in Data Editor
    • Error with specifying an incorrect value in the Filter window in Data Editor
    • Processing of the Ctrl+A, Ctrl+C shortcuts in Data Viewer

    4.3.58 16-Jun-21

    New features and improvements

    • Redesigned progress window for data generation
    • New formatting profiles
    • Options search

    User-reported and internal bug fixes

    • Error with generating data for the tables with circular dependencies (T306370)

    4.2.76 08-Oct-19

    User reported bug fixes

    • Several user reported bugs are fixed

    4.2.62 27-Jun-19

    User reported bug fixes

    • Several user reported bugs are fixed

    4.2.52 10-May-19

    User reported bug fixes

    • Several user reported bugs are fixed

    4.2.31 20-Feb-19

    Connection

    • Support for the Active Directory - Universal with MFA authentication

    User reported bug fixes

    • Problem with check constraints is fixed (MSSQL-1602)

    4.1.46 21-Dec-18

    New features and improvements

    • Connectivity support for SQL Server 2019
    • Product now integrates into SSMS v18
    • Lots of Azure improvements implemented
    • Foreign Key Generator for a group of unique table columns

    User reported bug fixes

    • Problem with false message about unsupporded datatypes is fixed (T257927)
    • Other user reported bugs are fixed

    4.0.92 19-Jul-18

    • Compatibility problem with SSMS 17.8 is fixed

    4.0.74 30-Aug-17

    • User reported issue with SQL Query generator is fixed (T231391)

    4.0.71 30-Aug-17

    • SQL Server 2016 Service Pack 1 (SP1) new syntax support
    • SQL Server 2017 new syntax support
    • The latest SQL Server Management Studio v17.2 integration support
    • Azure SQL Data Warehouse support
    • Pre and Post Script Execution
    • Storing custom generators
    • Generating data by time
    • Generating data to existing tables already populated with data
    • Generating data using linked table

    3.11.43 20-Apr-17

    • Generation of country-specific data
    • The ISJSON function in Check Constraint generator
    • 10+ new generators, including ICD-10 Codes
    • Data generation for databases already filled with data
    • Improved DateTime generators
    • Support for PowerShell
    • Trial product activation
    • Greatly improved visual style of the application with high DPI support
    • Specific exit codes added
    • Compliance with the Federal Information Processing Standard (FIPS)
    • Connection to Microsoft Azure SQL Database by using identities in Azure Active Directory

    3.10.33 16-Sep-16

    • SQL Server 2016 support
    • Product now integrates into SSMS 2016
    • XML generator is improved
    • Foreign Key generator is improved
    • Check Constraint generator is improved
    • Updated RegExp and Python generators
    • JSON generator
    • Check Constraint generator
    • 30+ new and improved meaningful generators

    3.9.6 22-Jan-16

    • RegExp generator is improved
    • IronPython generator is improved
    • Check Constraint generator is improved
    • Miscellaneous improvements and bug fixes

    3.8.13 29-Dec-15

    • Check Constraint generator implemented
    • Several new meaningful generators added
    • Installation wizard redesigned

    3.7.17 30-Nov-15

    SSMS Integration Support

    • SQL Server Management Studio integration enables starting the data generation directly from SSMS

    3.6.9 15-Sep-15

    • Iron Python script generator implemented
    • Password generator implemented
    • Credit Card Type generator redesigned
    • International Securities Identification Number (ISIN) generator improved
    • IPv4 Address generator extended
    • 5 new meaningful generators added

    3.5.39 17-Aug-15

    • Bug fix and stability improvements
    • Crash when openining some older .dgen documents is fixed

    3.5.37 13-Aug-15

    Enhanced RegExp Generator

    • Generate data from .txt and .csv files, table or view columns, and custom query columns
    • Counter added
    • Option to set weight for alternatives

    Advanced Foreign Key Support

    • Composite foreign keys are supported.

    New Generators

    • Basic generators (Constant, FK Manual, Twaddle)
    • 20+ new generators with valid checksum (Credit Card Number, VIN, ISSN, etc.)
    • 30+ meaningful generators (US Full Address, NickName, Birth Date, etc.)

    Improved Matching

    • Extended matching for more intelligent table mapping.

    3.0.32 14-Jul-15

    User-defined generators implemented

    • User-defined generators implemented.

    90+ meaningful generators added

    • 90+ meaningful generators added.

    2.0.18 11-Jun-15

    Basic Generators added

    • Regular Expression - generates values based on a regular expression
    • SQL Query - generates values from a custom query
    • Table or View - generates values from a table or view
    • Text File - generates values from the specified text file
    • Files Folder - generates values by retrieving documents content from a specified folder
    • Weighted Lists - generates values from a simple (or regexp, or nested, or ranged) values list with specified frequency of occurrence
    • Shuffled Text - generates dummy text by shuffling words in a specified text
    • Lorem Ipsum - generates dummy text with some characteristics of a real written text

    1.0.23 19-Mar-15

    • First release of dbForge Data Generator for SQL Server.