dbForge Data Compare for SQL Server Features

SQL Server Connectivity

  • Support of SQL server 2008, 2005 (including Express editions), and 2000 (including MSDE edition)
  • Comparison and synchronization of databases on different SQL servers
  • Connection Manager for a full control of database connections

Data Comparison

  • Accurate comparison with Data Comparison wizard
  • Comparison of tables and views
  • Custom mapping of tables, columns, views, and schemas
  • Custom comparison keys support
  • BLOB data comparison

Analyzing Data Differences and Synchronization

  • Automatic grouping of records in every compared object by type (different, equal, only in Source, only in Target, and conflict)
  • Convenient filtering of comparison results
  • One-click objects (or their records) exclusion from synchronization
  • Save and load comparison settings
  • Detailed synchronization script plan
  • Ability to backup Target database before synchronization
  • Warnings on possible data losses or errors during synchronization
  • Notifications on data overflow, roundings, etc.
  • Asynchronous data synchronization

SQL Execution and Data Management

  • Execution of SQL scripts and queries
  • 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
  • Ability to postpone sending of data updates to the server (Cached updates mode)
  • Data export wizard

Clear User Interface

  • Customizable window layout
  • Tool windows with 'auto-hide' and 'float' modes
  • Multiple shortcut schemes with full shortcut customization
  • Tabbed groups for documents
  • Toolbars customization
Order Download