dbForge Data Generator for SQL Server 3.10

Advertising
Software information
Platform:
Windows 7/Vista/XP
Publisher:
Devart
Price:
$249.95
File size:
20.05 Mb
Date added:
March 24, 2015
Screenshot:
Product page:
Description from the Publisher

dbForge Data Generator for SQL Server is a powerful GUI tool for a fast generation of large volumes of SQL Server test table data . The tool supports all column data types and allows to define tables and columns for data generation, set value ranges, customize parameters for each column data type, preview data before generation, edit and save data generation scripts for the future use. dbForge Data Generator for SQL Server can save your time and effort spent on test data generation by populating SQL Server tables with millions of customizable rows of test data.

Full support of all data types

The tool supports a massive range of column data types, including:

  • GEORGAPHY
  • GEOMETRY
  • HIERARCHYID
  • DATATIME2
  • DATATIMEOFFSET

Multiple generators with data customization

Data Generator comes with individual generators for each supported data type, that allow to customize:

  • Number of NULL rows
  • Data uniqueness
  • Value ranges
  • Value distribution mode

SQL data integrity support

The tool supports foreign keys for generation of consistent data across multiple tables. It also allows disabling triggers and constraints to avoid interference with database logic.

Multiple ways to populate data

The generated data population script that can immediately be executed against a SQL Server database, saved for the future use or edited in the internal editor.

Features

Supported Microsoft SQL Server versions

  • SQL Server 2014
  • SQL Server 2012
  • SQL Server 2008, 2008R2 (including Express edition)
  • SQL Server 2005 (including Express edition)
  • SQL Server 2000
  • SQL Azure
  • Working with SQL Server on Amazon RDS

Data Generator

  • Fast generation of large volumes of test data
  • Parameters customization for each column data type
  • Preview of test data to be generated
  • Generated data can be executed against a database or exported to SQL script

Execute Large Script

  • Execute Script Wizard (Schema Import)
  • File encoding setup
  • Error and status logging

Query Execution and Data Management

  • New SQL document view layout shows query text and retrieved data at the same time
  • Execution of SQL scripts and queries
  • Execute Large Script Wizard with Encoding option
  • Data editor with in-place filtering, grouping, and sorting options
  • Paginal data access for large result sets
  • Graphical card view for data editor
  • Large objects (LOB) editor
  • Text search in data editor
  • Data printing
  • Option to postpone sending of data updates to the server (Cached updates mode)
  • Code completion
  • SQL code formatter

User Interface

  • Wide collection of UI skins
  • Customizable window layout
  • Tool windows with 'auto-hide' and 'float' modes
  • Multiple shortcut schemes with full shortcut customization
  • Tabbed groups for documents
  • Toolbars customization
  • Windows connection coloring
  • Restoring document tabs from the last session
  • Switching between wizard window and primary window
  • Support of multiple monitors
Users reviews & testimonials

This software is not reviewed yet.

Advertising
Other downloads from this publisher

Devart ODBC Driver for Firebird provides high-performance and feature-rich connectivity solution for ODBC-based applications to access Firebird databases from Windows, Linux, MacOS, both 32-bit and 64-bit.

dotConnect for SQLite Standard Edition is a free of charge database connectivity solution built over ADO.NET architecture. It offers basic functionality for developing database-related applications, web sites.

Tool for quick creation of queries to SQL Server databases and extended data management. The main component of Query Builder is a visual diagram where you can "draw" your query.

Devart ODBC Driver for MySQL provides high-performance and feature-rich connectivity solution for ODBC-based applications to access MySQL databases from Windows, Linux, MacOS, both 32-bit and 64-bit.

MyDAC (Data Access Components for MySQL) is an enhanced component library for fast direct access to MySQL from Delphi, C++Builder and Lazarus, supporting Windows, Mac OS X, iOS, Android, Linux, FreeBSD for 32-bit and 64-bit platforms.