Altova DiffDog 2024 Enterprise Edition

Quick Comparison of SQLite and Access Databases

Home Prev Top Next

When SQLite or Access databases are involved in the comparison, you can easily start the comparison directly from Windows Explorer. Starting database comparisons from Windows Explorer is applicable only to SQLite and Access databases, since they are file-based. This is an easier alternative to starting the comparison from DiffDog, as described in Running a Database Data Comparison and Running a Database Schema Comparison.

 

For example, when the two database files to be compared are SQLite or Access, you can quickly start the comparison as follows:

 

Having selected the two database files in Windows Explorer, right-click any of them, and then select Compare with DiffDog from the context menu.

 

This action opens a database schema comparison and populates both sides of the comparison, for example:

dd-sqlite-access-comparison-01

Note that the left side may be a SQLite file and the right side may be an Access file, or vice versa.

 

You can also start a database comparison by selecting just one database file, for example:

 

Right-click the SQLite or Access database file in Windows Explorer, and then select Compare with DiffDog from the context menu.

 

If DiffDog is not running already, this action opens a database schema comparison, and populates the left side of the comparison with the selected database file. If DiffDog is already running, then the outcome is one of the following:

 

If a data comparison window is open, in focus, and one of the sides already contains a database, then DiffDog shows a dialog box similar to the one below:

dd-sqlite-access-comparison-02

Click Yes to add the new file to the current data comparison, or otherwise No to open a new comparison window.

 

If a schema comparison window is open, in focus, and one of the sides already contains a database, then DiffDog shows a dialog box asking you to add the new database to the current schema comparison.

If no data or schema comparison is active, or if both sides already contain databases, DiffDog opens a new database schema comparison.

 

To turn a schema comparison into a data comparison, right-click an empty area in the comparison window and then select the Open in new Data Comparison from the context menu. A similar menu command is available in a schema comparison window, for turning a data comparison into a schema comparison.

© 2017-2023 Altova GmbH