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

Entity Developer is a powerful visual model designer and code generation tool for LINQ to SQL.

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 Oracle is an enhanced ORM enabled data provider for Oracle that builds on ADO.NET technology to present a complete solution for developing Oracle-based database applications.

Entity Developer is a powerful ORM modeling and code generation tool for NHibernate, Entity Framework, LINQ to SQL. It introduces new approaches for designing ORM models, boosts productivity, and facilitates the development of database applications.

Devart Excel Add-in for SQL Server allows you to use powerful Excel capabilities for processing and analysis of data from SQL Server or SQL Azure, editing external data as usual excel spreadsheets and saving data changes back to the data source