You'll receive

Bi-weekly updates

Exclusive discounts

Product update alerts

 

ApexSQL Generate release notes

Release:

2016.06.0141

Date:

May 18, 2017

Enhancements:

  • Support for SQL Server Management Studio 17 integration

Fixes:

  • The add-in doesn’t integrate into SQL Server Management Studio 16.5.3 when it is the only ApexSQL add-in installed
  • “SQL Server Management Studio has stopped working” error message is encountered on start-up when the add-in is integrated into SQL Server Management Studio 2014 alongside other ApexSQL add-ins
  • Some SQL tables are not populated during data generation for specific databases

Changes:

  • SQL Server Management Studio integration is now disabled by default in the product installation wizard

Known issues:

  • "Index was out of range. Must be non-negative and less than the size of the collection." message is encountered when the /et switch is used in the CLI

Release:

2016.05.0132

Date:

March 21, 2017

Enhancements:

  • The "Fill only empty tables" option in the Options tab enables data generation for only empty tables
  • CLI switches:
    • Ignore project object selection [/ipos]
    • Export and execute [/eae]
    • Fill only empty tables [/foet]

Fixes:

  • All project file settings are ignored from the CLI when connection switches are specified along with the project file
  • "ColumnName: No module named listing" warning message is encountered when the application is unable to load IronPython generator libraries
  • "Index was out of range. Must be non-negative and less than the size of the collection" error is encountered when there is an error inside the module imported into the IronPython generator
  • The add-in version in the About window in SQL Server Management Studio is not the same as the version in the application About dialog
  • "Object reference not set to an instance of an object" error is encountered on loading a project file after one or more SQL tables are added or removed from the database referenced in the project file
  • The set identity_insert on SQL statement is added for SQL tables which do not have the identity columns
  • An exported SQL file cannot be executed due to the misspelled set qouted_identifier on SQL statement
  • "Object reference not set to an instance of an object" error is encountered when saving a project after it was previously canceled
  • No information about errors is available from the CLI when the execution is finished with errors

Changes:

  • Switch [/pr] is renamed to [/pt]
  • Switch [/pf] is renamed to [/pr]

Known issues:

  • Some SQL tables are skipped during data generation for specific databases
  • "Index was out of range. Must be non-negative and less than the size of the collection." message is encountered when the /et switch is used in the CLI

Release:

2016.04.0095

Date:

July 14, 2016

Enhancements:

  • Support for SQL Server Management Studio 2016 integration
  • Error-handling (/error_handling) switch is added in CLI
  • Switches for including/excluding (/include, /exclude) tables are added in CLI
  • Switch for exporting help into HTML file (/help_to_html) is added in CLI
  • Switch for inserting unique data (/unique) is added in CLI
  • Switch for shuffling the test data prior to generation (/shuffle) is added in CLI
  • Switch for setting the percentage of NULL values to insert (/allow_null) is added in CLI
  • Switch for previewing the return code (/return_codes) is added in CLI
  • Option is added to include the return code switch in the saved batch file
  • 20+ new predefined generators:
    • Products:
      • ISSN
      • ISSN-13
      • bibliographic code[coden]
      • IMEI number
      • post tracking number
    • Geographical:
      • language
      • language code ISO 639-1 alpha-2 lowercase
      • language code ISO 639-1 alpha-2 uppercase
      • language code ISO 639-1 alpha-3 lowercase
      • language code ISO 639-1 alpha-3 uppercase
      • address type
      • ethnic group
      • country code ISO 3166-1 numeric
      • country code ISO 3166-1 alpha-3
      • building unit
    • Personal:
      • phone type
      • nickname
      • phone number
    • Payment:
      • credit card number ISO 7812
      • credit card security code (cvv2|cvc2)
    • IT:
      • social networks
  • 20 new CLI return error codes
  • Improved output messages in the CLI: Generation summary, Warnings output and Preview with objects to process

Fixes:

  • Table mapping is lost when the Refresh button is clicked
  • Issue with loading .CSV or .txt files via Regular expression generator
  • Set time value is not being saved in the Random generator used on a column with datetimeoffset data type
  • Set time is not saved when the Random generator, used on datetimeoffset, is saved as User defined
  • The "Apply settings to tables" feature applies settings to all the tables, even the ones that are not selected
  • “Invalid column name 'remote_data_archive_migration_state_desc' “ error is encountered when generating in database on SQL Server 2016 RC3
  • “The ConnectionString property has not been initialized” message is encountered when connecting via Alias, while the Alias tab isn't selected
  • After generator selection the field with the generator settings is scrolled to the bottom
  • The Test data preview grid remains empty for table and all its columns, if the SQL table or view generator is assigned to any column in that table
  • The application freezes when the View dependencies option is selected on the table with no relations
  • The Test data preview remains empty when selecting specific table in the Main grid
  • The Regular expression settings and Dependent object grid are flashing and freezing when switching between two columns with the Regular expression generator assigned
  • “Access to the path 'C:\Program Files\ApexSQL\ApexSQLGenerate\allTypes.sql' is denied” exception occurs when exporting in the current folder through CLI
  • “Object reference not set to an instance of an object” error is encountered when connecting to the server instance that has stopped working
  • Empty values are inserted when IT>Roman numerals Predefined list is assigned to a column
  • Values start with lower case for Personal>Occupation Predefined list
  • The IronPython is not populating columns with nvarchar(MAX) datatype
  • Only half of the defined value's length is allowed in Random generator when it is assigned to a column with char(10) or more data type
  • Empty values are inserted when exceeding Longitude/Latitude while generating decrement values for columns with geography data type
  • The Weighted list (ranged) generator should not be presented for the columns with hierarchyid data type
  • Incorrectly limited maximum allowed value for the 'From' and 'To' labeled text-boxes in the Weighted list (ranged) generator
  • “SQL Server Management Studio has stopped working” message is encountered when starting SSMS while ApexSQL Diff (interim), ApexSQL Complete (interim) and ApexSQL Generate (public) are all installed
  • “Value cannot be null” error is encountered when clicking the Select all button when the database is collapsed in the Main grid after refreshing
  • “Invalid column name 'remote_data_archive_migration_state_desc' “ error is encountered when connecting to SQL Server 2016 RC0
  • “Object reference not set to an instance of an object” error is encountered when loading a specific database
  • Missing CLI switches to redirect the console output to an HTML file
  • “Object reference not set to an instance of an object” error is encountered when the SQL query generator is selected on specific int column
  • Enabling delete trigger is located under "Enabling insert triggers" action in the Action plan
  • Missing the CLI switches for Activation/Deactivation of the application
  • Missing the CLI switches for specifying which tables to be populated
  • The quotation marks are missing in the batch script when there are white spaces in the database name
  • Batch file does not populate the columns correctly even though the generator settings are properly specified in the project file that the batch file is using
  • Missing the corresponding switches for Unique, Shuffle and Allow null options in the CLI
  • Missing the error-handling switch in the CLI
  • Problem in the exported script when the object's name contain apostrophe
  • “Object reference not set to an instance of an object” error is encountered when using a project file with only a connection string in CLI
  • Missing the option in the "Save as batch" form to include the return code at the end of the output when executing the saved batch
  • Wrong database name is shown in the Apply settings window
  • The Pre and Post processing scripts are incorrectly ordered in the Action plan window
  • Wrong naming of the Pre and Post processing scripts under the Group by action tab in the Action plan window
  • “Execution successfully finished” message is encountered even when the pre/post processing scripts fails
  • The Project settings option in the Save project as batch file window should be checked by default
  • The application freezes intensely when using the Directory generator
  • The Cross-column generator's settings are previewed for computed columns with server assigned generator
  • The User defined generator is not being saved in the default folder - My Documents\ApexSQL\ApexSQLGenerate\User defined
  • Missing a path to default folder for saving User defined generators
  • Saved generators are available for reuse in the generator settings even if they are not located in the folder specified in the application's options
  • User defined generator saved on the tinyint data type cannot be reused on smallint, int, bigint
  • Generator saved outside of the user defined folder appears in the generator drop-down list anyway
  • Shared user defined generator cannot be loaded when browsed for
  • Application freezes when Aliases are not previously created
  • Random generator for datetimeoffset(7) data type is not being saved as User defined
  • “Value cannot be null” error is encountered when clicking the Table mapping button after canceling the Table mapping action

Release:

2016.03.0064

Date:

June 06, 2016

Enhancements:

  • Support for SQL Server 2016

Fixes:

  • "Object reference not set to an instance of an object" error is encountered when loading a specific database

Known issues:

  • The application cannot be integrated into latest SQL Server Management Studio 2016 version

Release:

2016.02.0062

Date:

March 15, 2016

Fixes:

  • "SQL Server Management Studio has stoped working" error is encountered when starting SQL Server Management Studio while ApexSQL Diff 2016 or ApexSQL Complete 2016.02 are also installed

Release:

2016.02.0061

Date:

February 26, 2016

Enhancements:

  • Import database structure from SQL creation script
  • Merge SQL creation script with SQL static data script
  • New export: JSON
  • New export: Excel
  • Live preview of export results
  • New generator: IronPython
  • 25 new predefined generators were added
  • New generator: Manual foreign key
  • New weighted list: Nested
  • New weighted list: Regular expression
  • New weighted list: Ranged
  • Check constraint violation warnings
  • Graphical dependency viewer

Fixes:

  • "Object reference not set to an instance of an object" error is encountered when the Table mapping is set and confirmed for a column, and then reopened again
  • The application closes when the Save as button for the embedded script is clicked
  • Options for the Lorem ipsum generator are not loaded when it is saved as the User defined generator
  • Tables are missing from the Apply settings to tables window, when one option is applied and then the option is unchecked and tables are removed from the applied settings
  • "Index was out of range. Must be non-negative and less then the size of the collection" error is encounterd when all columns are removed from the applied settings to columns
  • The project is saved to wrong location
  • The application starts to flash when one table is selected and CTRL+A is pressed
  • "Error during parsing value: Exception has been thrown by the target of an invocation" error message is encountered when percent or dollar value is added to the List generator
  • "Index was out of range. Must be non-negative and less than the size of the collection" error is encountered when the generation process is done and several tables are clicked
  • Missing an option to remove table mapping
  • "Internal parser error" error message is encountered when the Cancel button is clicked while loading a database
  • The last location for saving the project file is not remembered
  • When a project is selected from the Recent projects option in the New project window, the master database is loaded
  • The addin file for SQL Server Management Studio integration is created in wrong locations
  • The drop-down buttons in the Regular expression generator are not working correctly
  • Tables are being collapsed after the Refresh button is clicked
  • Missing an option to create a batch file for the CLI code from the GUI
  • The exported SQL file that contains apostrophe character in the data values cannot be executed from SQL Server Management Studio
  • The installation wizard offers SQL Server Management Studio integration even if that version is uninstalled
  • The option for defining the number of decimal points for Float data type is missing
  • Delimiter for Table mapping set in options is not applied after clicking the "Ok" button
  • The Shuffle option is not checked by default for the List generator
  • Missing Command-Line Interface switches for Additional scripts
  • The Unique option is redundant in the Text generator
  • Include / exclude dependent tables does not refresh when new database is loaded
  • For "E-mailAddress" column, Predefined generator will insert Address predefined
  • Application crashes when adding fourth predefined list for one column using Regular expression generator
  • Test data preview isn't refreshing to "Empty" when SQL table or view generator is selected and before it's set
  • The application is freezing and flashing when deleting or typing in expression in Regular expression generator
  • Bottom of the application is flasing intensively when the warning occures
  • Test data preview is not refreshing when the new database is loaded
  • The application is flashing when the Lorem ipsum text is deleted
  • Missing the Predefined generator for "Citizenship" column
  • Wrong default generator is set for column named "Street"
  • The options are not applied in Lorem ipsum Text generator
  • Context menus are missing for columns and databases
  • The application crashes when opening inappropriate .XML file as a shared User defined generator
  • "Index was outside the bounds of the array" error is sometimes encountered when using "Show filter rows" option
  • "Switch 'af' cannot be used along with other switches" message is encountered when using the Argument file switch in the Command-Line Interface
  • Default folder is not created if the first project after installation of the application is executed from the Command-Line Interface
  • Dialog opens when overwriting the existing files in the Command-Line Interface
  • "Object reference not set to an instance of an object" message is encountered when generating through CLI
  • Not supported type GT_CSV for column with type timestamp message is encountered when column with timestamp data type is selected
  • "Object reference not set to an Instance of an object" message is encountered when newly added table is selected after refreshing the database
  • The Predefined generator is missing for the columns with datetime2 data type
  • The "0 or more repeats" option in Snippet, Regular expression has a function of "1 or more repeats", and the other way around
  • Application hangs if the patterns in certain form are used in the Regular expression generator
  • “Login failed for user 'user' ” error is encountered when connecting to database in CLI with not trusted connection
  • Not every data type can be parsed into string columns in the SQL table or view generator
  • "Value cannot be null" error message is encountered after canceling the progress bar while loading the previous project and than clicking the Generate button
  • "Object reference not set to an instance of an object" error message is encountered after canceling the progress bar while loading the previous project and than clicking the Edit button
  • "Object reference not set to an instance of an object" error message is encountered when applying settings to columns
  • "Object reference not set to an instance of an object" error message is encountered when selecting column on which changes are made in SQL Server Management Studio while the project was active
  • "Object reference not set to an instance of an object" error message is encountered when clicking the Edit button with no active project
  • The add-in 'ApexSQL Generate' failed to load or caused an exception message is encountered when starting SQL Server Management Studio after the ApexSQL Generate is uninstalled
  • "The ConnectionString property has not been initialized" error message is encountered when switching from Regular expression to the SQL query generator when the RegEx is assigned to the columns with tinyint, nchar(1) or nchar(2) data types
  • Columns with the same data type and shorter length should be able to be used via the SQL table or view generator
  • Currently selected table gets unselected upon clicking the Collapse all button
  • The Table drop-down list doesn't refresh its content once it's reconnected to a different database in the SQL table or view generator
  • The SQL table or view generator settings disappear after reconnecting generator to a different database and refreshing the application
  • Slider is missing for the Foreign key columns to determine the data source
  • Application flashes when switching to the SQL table or view generator
  • "Index was out of range. Must be non-negative and less than the size of the collection" error message is encountered when creating new table (manually or via Additional scripts) and then Refreshing the connection in the application
  • Multiple NULL values in the Test data preview grid when the Unique option in checked in the Regular expression generator
  • The expression for Predefined lists is inserted as a value in the Test data preview grid, when the Unique option is checked and Predefined list is inserted via the Regular expression generator
  • Not supported type GT_PREDEFINED for column with type datetimeoffset message is encountered when selecting the Predefined generator for column with datetimeoffset data type
  • The tables does not get populated when they are included for generation in the Dependent objects grid
  • "There is an error in XML document (0, 0)" error message is encountered when loading the empty project in the ApexSQL Generate
  • "Index was outside the bounds of the array" error is encountered when refreshing the database in which the filter was active
  • Files exported via CLI does not get updated when overwritten
  • "There is no data in source" message is encountered in the preview grid in the Table mapping form when SQL View is selected as a data source
  • Cannot access destination table [schema].[table] warning is encountered for all the tables in the database when one table is mapped by SQL table
  • The given key was not present in the dictionary error is encountered when selecting the Incremental generator for the column with numeric(19,5) data type
  • The application generates 0 rows in the columns with primary and foreign key constraints

Release:

2016.01.0051

Date:

October 23, 2015

Enhancements:

  • Added 85 predefined generators
  • New Cross-column generator has been added
  • New User defined generator has been added
  • New Text generator has been added along with:
    • Lorem ipsum generator option
    • Text shuffler option
    • Sentence generator option
  • New Execution by time option
  • New Execution by table proportion option
  • New SQL view option for the Table mapping feature
  • Improved Regular expression generator with an option to use columns and files as variables
  • New Pre-processing and Post-processing scripts feature has been added
  • New Warnings feature has been added
  • New Include dependent database objects option
  • Support for SQL Server 2016 CTP2
  • Support for SQL Server Management Studio integration

Fixes:

  • Missing an option to set the Share folder for User defined generators
  • No values are stored for the List generator when saved as the User defined generator
  • Missing a warning message when there is no value set for in the List generator, which is saved as a User defined generator
  • Missing an option to delete the User defined generator
  • Only one value will be inserted into a column, if the Collection based predefined generator is used on a column, using a specific data type with the Loop option unchecked
  • The Incremental generator resets its settings when changing to another column and back, while retaining the data preview results for columns that are using hierarchyid data type
  • The application installer will continue with the installation, even when the lack of necessary requirements is detected
  • "One or more errors occurred" error message is encountered when generating data for a specific database
  • The "Table proportion generation" option does not properly generate a row for a specific database
  • A trigger is shown as enabled in the "Action plan" window, even if the "Disable INSERT triggers" option is checked
  • A column for date values in the "Table mapping" window is showing the current system time, when a CSV file column is loaded, the column is switched to CurrencyCode, and a Refresh button is clicked
  • "Object reference not set to an instance of an object" error is encountered after selecting the "SQL View" option in Table mapping and selecting an object from a drop-down box
  • The warning error is shown after executing a query in the Query generator for a column, then selecting other column, and then getting back to the first one
  • There is no dialog to save the project, after the X button in the top right corner of the application window
  • The application becomes idle when generating a large number of rows for a specific database
  • The maximum allowed number of rows that will be generated, in the New project window, is 10.000
  • Missing the "Clear all values" option for the List generator
  • The file with values used in the List generator is not stored after switching from and getting back to the column for which is used for, although the values from the file are remembered
  • The list of values cannot be created in the List generator for the ntext data type
  • "Collection was modified; enumeration operation may not execute" error message is encountered when editing the table properties in SQL Server Management Studio while the table is being used in the application
  • "Cannot open database "cent" requested by the login. The login failed.Login failed for user 'Nojro-PC\Nojro'" error message is encountered when trying to generate data to a database that is deleted in the meantime
  • Missing an option to load views from a database for the Table generator
  • Missing a syntax highlighting of SQL code in the Query generator
  • The Regular expression generator should have default values according to the data type used in the column
  • When changing from the List generator to the Incremental generator there is no preview available for columns using binary and datetime data types
  • The Incremental generator default value for the time zone is not shown properly in the Preview pane for columns using the datetimeoffset data type

Release:

2015.04.0040

Date:

July 23, 2015

Features:

  • Generate test data using data from CSV file
  • Generate test data by using a valid column from the same database as foreign key
  • Generate test data using predefined generators
  • View the action plan before generating data
  • Import data from existing data sources via table mapping
  • /project CLI switch for executing the saved project

Fixes:

  • The application allows itself to be uninstalled even when it is running
  • The "ExecuteNonQuery requires an open and available Connection. The connection's current state is closed." error is encountered when generating data to a database that is in use
  • The "Apply settings to children" option is not working correctly when some changes are made and then the Cancel button is clicked
  • Predefined generators should not allow longer character lengths than the column's length
  • The Query generator doesn't allow inserting certain data type values into columns that are using nvarchar data type
  • "Exception of type 'System.OutOfMemoryException' was thrown." error is encountered when trying to generate data after opening a saved project file containing column with varbinary(max) SQL type
  • The generator settings disappear after loading a CSV file in the CSV generator and selecting that column after changing to another column
  • If there are less values to be generated than set in the table row count and the Unique option is clicked in the Random generator the application hangs
  • "Database is currently in use. Please close all connections and try again" message is encountered when changing to the Table generator
  • The SQL table mapping option doesn't link all available columns for the tables with the same name and data types used
  • "Index was outside the bounds of the array." error message is encountered when checking the Use first row as a column name option in the CSV file pane of the Table mapping window
  • SQL table mapping allows to select as the source the table which is being mapped
  • After opening the saved project settings for SQL mapped tables are not restored
  • "Object reference not set to an instance of an object." error is encountered after opening a saved project and modifying the Alias for SQL mapped table
  • The Table mapping option allows the Foreign key generator to be altered
  • No preview is being displayed and no data generated after selecting the column that is CSV mapped and using ntext as data type
  • "Object reference not set to an instance of an object." error is encountered after opening the saved project with CSV mapped columns and generating data
  • A project file cannot be saved after selecting a column that has been CSV mapped and is using ntext data type
  • The automatically set predefined generator type cannot be changed unless the predefined generator area is changed first
  • "Object reference not set to an instance of an object." error is encountered when generating data after opening a saved project containing columns with predefined generators set
  • After unchecking all tables and checking single one it behaves like it isn't selected
  • When editing Table mapping that is set a schema and a table name are displayed instead of only a table name
  • The Shuffle option should be checked by default for Predefined generator
  • There is no Up/Down box for the Days field in the Incremental generator
  • There should be an information message when both Unique and Allow null options are checked
  • The 'System. NullReferenceException' error is encountered when scrolling through the columns of a database using the keyboard
  • Some options and descriptions are cut off or distorted if certain display settings are applied in Windows 8
  • The "Apply setting to children" window should be differently organized
  • The List generator should have a combo box for True/False values
  • There should be no sound after pressing the Enter key in the Search bar
  • There should be no Time value in the Incremental generator or in the Preview pane for the Date data type
  • The AM/PM option is missing from the Random generator
  • The number of rows is not remembered after changing it in the Generation options and clicking on the "Refresh" button
  • The "Disable check constraints" option is not unchecked in database options, when its unchecked in the "Defaults" window
  • Missing the right-click menu for checking, expanding, and selecting objects in the Main grid
  • Columns in the Result grid are clickable, but they do not sort results by clicking column, as other applications do
  • After unchecking all tables and checking single one it behaves like it isn't selected
  • When changing the generator for a column from specific generators to Predefined generator empty will be displayed in the preview
  • Limited column selection in CSV mapping option after loading a CSV using a different delimiter than default one
  • The Table is wrongly set for a column after applying the SQL table mapping to a table

Release:

2015.03.0025

Date:

May 22, 2015

Fixes:

  • The "From table" generator should only allow columns with equal/smaller character length to be selected
  • The From list generator does not have an option to enter time for datetime data type
  • The "Options" button and the "Defaults" button, from the "Home" tab, are not enabled when a database is not loaded
  • The foreign key generator does not have the "Shuffle", the "Allow null", and the "Percentage of null" options
  • All tables are selected when a saved project file is restored
  • Executing query in the From query generator for the wrong data type is changing values for the other column
  • When the specific object type is selected and then a different one, the text labels distort in the Random generator control box
  • The Float data types default values for the Incremental generator are shown as (empty)
  • The Random generator seed value can be negative
  • There is no SET IDENTITY_INSERT ON/OFF statement in the exported SQL script
  • The "Save password" option in the "Alias management" window will not remember the password after the application restarts
  • The progress window does not show the name of the table for which the data is being generated
  • The "Alias management" window is opened, even if the Cancel button is clicked, after selecting the "Add new alias" option
  • The From list and the From directory generators, show larger values than allowed in the Preview panel, for specific data types
  • The "Apply settings to tables" option slows down when applying settings to all tables in a database
  • The "Unique" option is changing values for the other column, which is not selected
  • The "Apply settings to tables" option does not apply the changes immediately
  • When loading the saved project, settings for a database are set to default
  • The From directory generator and the From CSV generator should not allow longer character length than column's lenght
  • "Collection was modified; enumeration operation may not execute" error is encountered when loading project file with specific settings
  • "The process cannot access the file 'Path\FileName.csv' because it is being used by another process" error is encountered when trying to generate from an open CSV file
  • Increment values for the Incremental generator can be negative for some data types
  • The Random generator and the Incremental generator default values are too big for some object types
  • “Specified cast is not valid error” is encountered when generating data and the From query generator is executed on a column for wrong data type
  • The main window size is not remembered after closing the resized application
  • The data will not be generated, if the generator is not set for a column, even if the column’s table is unchecked
  • There is no horizontal scroll bar in the Preview pane, when a database with larger number of columns is loaded
  • The test data is not shown for specific data types in the Preview pane
  • "Object is currently in use elsewhere" error is encountered when loading the same database several times in a row

Release:

2015.02.0021

Date:

April 23, 2015

Fixes:

  • "Object reference not set to an instance of an object" error is encountered when generating data for the saved project with specific settings
  • "'minValue' cannot be greater than maxValue" error is encountered when generating data for the saved project with specific settings
  • The From CSV file generator imports column names from a CSV file as data, instead of as a column name
  • "System.IO.FileNotFoundException" error is encountered when generating the data for a saved project with the invalid link to the external data source
  • "Object reference not set to an instance of an object" error is encountered when generating the data for a saved project while using the non-existing alias
  • "Object reference not set to an instance of an object" error is encountered when changing generator type for a saved project while using the non-existing alias
  • The application GUI cannot be displayed on screen at all when using multi-monitor setup
  • The From table generator is not working properly after restoring a project
  • "Maximum cannot be less than Minimum" error is encountered when changing from any other generator to Incremental
  • "Unable to cast object of type" error is encountered when trying to connect to a SQL Server 2008 database

Release:

2015.01.0018

Date:

March 13, 2015

Features:

  • Support for Azure SQL Database V12
  • Unlimited data generation
  • Generating random set of data for all data types:
    • Repeating the result by using the same seed value
    • Create unique values
    • Set the percentage of NULL values in result
  • Generating sequential data:
    • Set start and end value
    • Generate data in incremented order
    • Generate data in decremented order
    • Set increment/decrement step
    • Set the percentage of NULL values in result
  • Generating result using data from CSV file:
    • Set delimiter character
    • Use specific column from CSV file
    • Randomize order of values from CSV file
    • Repeat original/randomized order of data
    • Set the percentage of NULL values in result
  • Generating result using custom list of values:
    • Randomize order of values from list
    • Repeat original/randomized order of values
    • Set the percentage of NULL values in result
  • Generating result by using a column with a compatible type as source:
    • Randomize order of values
    • Repeat original/randomized order of values
    • Set the percentage of NULL values in result
  • Generating result by using return values of an SQL query:
    • Randomize order of returned values
    • Repeat original/randomized order of returned values
    • Set the percentage of NULL values in result
  • Generating result by taking values from all documents in a directory:
    • Filter files based on filename and extension pattern
    • Set which encoding type is used when reading files
    • Include subfolders into search path
    • Randomize order of returned values
    • Repeat original/randomized order of returned values
    • Set the percentage of NULL values in result
  • Generate result using a generator based on Regular Expression:
    • Basic snippet insertion
    • Randomize order of returned values
    • Repeat original/randomized order of returned values
    • Set the percentage of NULL values in result
  • Executing against a live database
  • Exporting to CSV file
  • Exporting to XML file
  • Exporting to SQL file
  • Live preview of generated data
  • Top-down level settings for database, tables, and columns
  • Supports SQL Server 2014, 2012, 2008 R2, and 2008