Altova DiffDog 2024
Altova DiffDog is the unique XML-aware diff / merge tool that lets you compare and merge text or source code files, XML or JSON files, and Word documents. Compare and synchronise directories, database schemas and content, and much more.
With a straightforward and consistent user interface, DiffDog is a powerful diff/merge tool for all common comparison tasks.
Compare and Merge:
- Text Files
- XML Files & XSDs
- Folders & Directories
- CSV and Databases
- ZIP Archives
- OOXML Documents
- Word Documents
- Compare 3 Files
- Diff/merge tool
- File differencing
- Folder differencing
- 2- and 3- way file compare modes
- Compare database content and schemas
- Compare CSV-to-CSV and CSV to database content
- Generate diff reports
- XSLT code for XML Schema differences
- Save comparison settings for easy reuse
- DiffDog Server for automating diff report generation
File Comparison Tool
DiffDog includes powerful capabilities that let you compare and merge any type of text-based file, with support for Unicode, ASCII, MBCS, and any other file formats.
DiffDog allows bi-directional merging as well as direct editing of both compared files. DiffDog automatically creates a backup of each file, allowing you to re-load the original file from the server or disk at any time should you need to start over.
DiffDog also supports unlimited undo, so you can backtrack to any point in the editing and merging process.
XML Diff/Merge/Edit Tool
The XML differencing and editing features in DiffDog draw on Altova’s legacy as creator of XMLSpy, the world’s leading XML development. With robust features such as well-formedness and validation checking, code completion, DTD/schema based entry helpers, and more, DiffDog is a must-have differencing utility for Web and software developers working with XML.
DiffDog recognises when two files are XML equivalent even if they contain differences in namespace prefixes, order of XML attributes, or order of child elements that can be irrelevant to XML processors, but prevent files from appearing equal in a simple text comparison.
DiffDog offers two options for displaying XML files: advanced text view and enhanced grid view. Advanced text view includes visual and navigation aids such as line numbers, book marks, and a source folding margin.
Enhanced Grid View displays the hierarchical structure of an XML document through a set of nested containers. These can be easily expanded or collapsed to visualize the document’s tree-like structure.
3-Way File Comparison
DiffDog allows users to compare and merge differences between three files side-by-side. This feature is especially relevant for files managed in any source control system where two users may started from the same source file then make different changes which must be reconciled.
A three-way file compare permits display and navigation of all differences between both new versions and the common ancestor file. For each encountered difference, DiffDog users can decide which change (“left”, “right”, or “middle”) should be kept.
XML Schema Comparison
DiffDog includes powerful XML Schema differencing functionality that extends and complements XML-aware file comparison of .xsd documents and eases conversion of XML data.
The DiffDog Schema comparison tool automatically maps schema elements with the same names. You can select different root elements for each XML Schema, and you can also manually connect dissimilar elements to map them, or override automatic element mappings.
After you map two XML Schemas, DiffDog lets you generate an XSLT file to transform existing XML documents for the new schema, saving significant time and effort compared to writing and debugging XSLT code by hand.
DiffDog lets you generate a fully editable MapForce mapping file between the schemas for more complex mappings that require data processing functions.
Folder Compare and Directory Sync Tool
The diff/merge tool is a powerful, easy-to-use tool for comparing and merging directories on your workstation, the local network, and even folders on local and remote FTP and HTTP servers (based on user privileges).
DiffDog provides five options to compare folders: Quick compare mode compares files by size and date only, Text comparison mode compares actual textual content of files in each directory, XML comparison mode compares actual file content with XML-aware intelligence, and Binary comparison mode for non-text files such as EXEs, MP3s, JPGs, etc. Extension comparison mode automatically selects a specialised mode based on the file pair extension.
You can open a file comparison directly from the directory comparison window by simply double-clicking the desired file.
The Synchronize Directories dialog lets you set the rules for merging folders. You can review all the scheduled file updates across both folders, then click the Start button to synchronize.
Zip File Differencing Tool
Altova DiffDog includes enhanced support to diff/merge ZIP archives and the files contained in them.
DiffDog ZIP differencing lets you compare and merge text or source code files stored in ZIP archive just like comparing uncompressed files. Or, compare and edit XML files stored in ZIP format with advanced XML-aware functionality. DiffDog even recognizes whether binary files stored in ZIP archives are identical or different.
DiffDog applies the correct comparison options based on file extensions, so you examine the files and merge differences with the same functionality available when comparing the uncompressed originals.
Word Document Compare Tool
DiffDog includes a special compare feature for Microsoft Word documents. If Microsoft Word 2003 or later is installed on your computer, DiffDog can compare document files by opening two embedded Microsoft Word windows and display the document differences side-by-side.
DiffDog Word comparison is especially useful to manage document revisions over time, particularly where change tracking was not used.
You can directly edit the content of the files in the DiffDog Word file diff windows using all the features of Microsoft Word via the context menu or keyboard shortcuts. When your edits are complete, use the DiffDog Save or Save As buttons in each Word file comparison window, or the File / Save menu option to save your work.
Compare CSV and Database Data
CSV is often used for exporting database data, and the ability to compare such data – either with another version of a database dump or to the data in the database itself – is a common requirement. DiffDog supports CSV as a native format for comparison, allowing you to:
- Compare CSV to CSV
- Compare CSV data to database data
- Merge changes in either direction one by one or all together
A CSV comparison is similar to file comparisons: once you connect your data sources will be displayed as left and right components. A “component” is just a representation of the CSV or database structure from where you can conveniently select the tables or columns that are to be compared.You can either merge all differences as one batch, or you can display the differences for each table in a data grid, and then review and merge each difference individually at row level.
Database Content Comparison Tool
In addition to CSV to database comparison, Altova DiffDog lets you easily compare and merge the contents of tables between two databases. DiffDog displays database comparisons in an intuitive graphical table representation with connecting lines to illustrate column mapping between tables.
DiffDog can compare different versions of a table in the same database type, or you can compare and merge the content of equivalent tables in different database types. When you compare different database types, DiffDog even resolves datatype naming inconsistencies.
Automatic table mapping options let you instruct DiffDog to map columns based on name, datatype, or column position. If the results of automatic mapping are inaccurate or incomplete, you can also manually map comparisons by dragging connecting lines between table columns.
- Firebird 2.5, 3
- IBM DB2 for iSeries v6.1, 7.1, 7.2, 7.3, 7.4
- IBM DB2 8, 9.1, 9.5, 9.7, 10.1, 10.5, 11.5, 11.5.7
- Informix 11.70, 12.10, 14.10
- MariaDB 10, 10.3, 10.4, 10.5, 10.6.5, 10.9.2
- Microsoft Access 2003, 2007, 2010, 2013, 2019
- Microsoft Azure SQL
- Microsoft SQL Server 2005, 2008, 2012, 2014, 2016, 2017, 2019
- MySQL 5, 5.1, 5.5, 5.6, 5.7, 8, 8.0.25, 8.0.28
- Oracle 9i, 10g, 11g, 12c, 18, 19
- PostgreSQL 8, 9.0.10, 9.1.6, 9.2.1, 9.4, 9.6, 10, 11, 12, 13, 14.1, 14.5
- Progress OpenEdge 11.6
- SQLite 3.x
- Sybase ASE 15, 16
- Teradata 16
Database Schema Diff/Merge Tool
DiffDog lets you compare database structures and visually identify and merge differences. You can compare databases of the same type or you can compare two schemas of different database types.
You can choose to compare individual tables, groups of tables, or entire database schemas.
You can merge differences by clicking either the left- or right-merge button on the toolbar. The right-click context menu offers more comprehensive merge options, including a choice to immediately open a database content comparison for the selected tables.
Whichever merge option you select, DiffDog always creates a SQL change script for the target database for you to review. You can save the SQL change script to a file, send the script to a SQL Editor window in DatabaseSpy, execute the SQL change script directly from DiffDog, or cancel your merge request and abandon the script.
OOXML Differencing Tool
Altova DiffDog includes enhanced support to diff/merge Microsoft Office Open XML (OOXML) files.
Many diff/merge tools treat Office Open XML (OOXML) files as binary file types that are simply recognized as identical or different based on file size and modification date. DiffDog empowers you to compare and display detailed differences in the contents of Office 2007 (and higher) OOXML file pairs.
DiffDog lets you merge differences in either direction, with full support for all the advanced XML-aware differencing options DiffDog offers during XML file comparisons. You can also display and edit file pairs stored inside OOXML files in Grid View. In many cases Grid View can provide a more easily comprehensible representation of the file contents.
Diff Report Files
Developers and other project stakeholders often want to keep a record of changes to source code and other important files. DiffDog can create diff reports for all comparisons of text-based files, including source code files.
DiffDog can also create differences reports for directory comparisons. The Export differences dialog lets you choose to create a diff report in text format or as an XML file. Text format reports follow the well-accepted Unix diff style. Report files in XML format are human-readable with descriptive element names and record the comparison mode and the paths of the directories compared.
You can also use the DiffDog directory report functionality to create diff reports for comparisons of Zip archives or OOXML documents.
DiffDog Server is high-performance server software that takes advantage of the power of today’s parallel computing environments to automate high-volume comparisons and generate diff reports comparing files, directories, and URLs.