dbForge Data Compare for PostgreSQL Features

This page provides a comprehensive listing of features available in dbForge Data Compare for PostgreSQL. For a list of new features, see What's New in 3.0.

What servers are supported?

  • PostgreSQL Server versions: 8.3, 8.4, 9.0, 9.1, 9.2, 9.3, 9.4, 9.5, 9.6
  • Amazon Redshift

What objects can be compared and synchronized?

  • Tables
  • Views
  • Custom queries

What data types can be compared and synchronized?

  • smallint
  • integer
  • bigint
  • real
  • double precision
  • numeric [ (p, s) ]
  • money
  • character [ (n) ]
  • character varying [ (n)
  • quoted char
  • name
  • text
  • tsvector
  • tsquery
  • timestamp [ (p) ] [ without time zone ]
  • timestamp [ (p) ] with time zone
  • time [ (p) ] [ without time zone ]
  • time [ (p) ] with time zone
  • date
  • interval [ fields ] [ (p) ]
  • boolean
  • point
  • line
  • lseg
  • path
  • polygon
  • box
  • circle
  • bytea
  • array
  • xml
  • bit [ (n) ]
  • bit varying [ (n) ]
  • cidr
  • inet
  • macaddr
  • uuid
  • json
  • jsonb
  • pg_lsn
  • txid_snapshot
  • int4range
  • int8range
  • numrange
  • tsrange
  • tstzrange
  • daterange
  • POSTGIS: geometry
  • POSTGIS: geography
  • POSTGIS: box2d
  • POSTGIS: box3d
  • POSTGIS: geometry_dump

    Data comparison setup

    • Include tables or views into comparison by mask or individually
    • Exclude objects from comparison by mask or individually
    • Ignore columns by mask (e.g. don't compare ModifiedDate column in all tables)
    • Float types rounding option
    • Ignore Case and Ignore Trailing Spaces options for string comparison
    • LOB comparison options
    • WHERE filter for limiting data that needs to be compared (e.g. in extra large tables)

    How can I compare data in two databases with different structures?

    • User mapping feature allows comparing tables with different names and column set
    • Map one table in source with two or more tables in target (useful when table was split)
    • Custom Query feature allows comparing a table with a query result

    How can I analyze comparison results?

    • Filter and sort objects in results
    • View data differences for each pair of objects
    • Quickly navigate through data differences
    • Perform full-text search in data
    • View number of changes per column
    • Hide unmodified columns, and lock/unlock the key columns to simplify analysis
    • Select arbitrary columns for display

    How can I export data comparison results?

    • Generate data comparison report in Excel and HTML formats
    • Include actual data into report
    • Report on selected objects only

    Synchronization features

    • Create accurate synchronization scripts
    • Migrate individual records, groups of records, or all data differences
    • Toggle synchronization direction to apply data changes to both databases
    • Warnings on possible problems prior to synchronization

    How can I automate my routine tasks?

    • Save comparison project settings for future use
    • Use command line interface for automatic routine synchronizations