Comparing two production databases or doing a migration or upgrade project? Now you can have this powerfull and simple tool that every DBA and database developer needs.

Schema compare

Data compare

Bundle

SQL Server 2005/2008 with SQL Asure

SQL Server 2005/2008 with SQL Server 2005/2008

SQL Server 2005/2008 with SQL Oracle

SQL Server 2005/2008 with SQL Sybase

Total: $

 
  • Overview

    The product is developed by the team that originally created Microsoft SQL Server Migration Assistant (SSMA). It fills the gap that many DBAs complain about — whether it's a production, development, test, migration, or upgrade scenario — comparing schema and data. Also complements SSMA and Upgrade Advisor for validating results.

    Features

    Schema comparison.

    Includes tables, columns, user defined data types, indexes, constraints, stored procedures, functions, triggers, packages. Identifying differences and creating scripts to synchronize between source and target schemas. Supports homogeneous and heterogeneous databases (e.g. SQL-SQL, SQL-Azure, Oracle-SQL, Sybase-SQL).

    Data comparison.

    Identifying differences between selected tables for all columns or only selected columns. Creating scripts to synchronize data between source and target tables. Supports homogeneous and heterogeneous databases.

    Command line and GUI-based version.

    Easy way to integrate into development and test environments. Ideal fit for cross platform database development, unit testing and functional testing. Perfect tool for production DBAs supporting multiple databases with similar structure.

    Screenshots

  • Watch the screencast

          

    Customer quotes

    «This Database Compare tool saved me tons of time!»

    Alan Smith, Production DBA.

     

    «Can't imagine doing migration project without DB Best Database Compare Suite.»

    Tom D., Microsoft Consulting Services

          
          

    System requirements

    Database compare suite requires that the following software is installed on your computer.

    Operating system

    Windows Server 2003; Windows Server 2008; Windows XP; Windows Vista

    100 MB of available hard disk space

    Additional software

    Microsoft .NET Framework 3.5 SP1 Oracle Client Software with Oracle Data Provider for .NET version 8.1.7 or higher (only for Oracle databases)