Application Repository

CompareData is a client/server application that uses a small database to store its settings. This database is referred to as the application repository. Please note that CompareData will not work without a repository.

Embedded Firebird Repository

Starting with release 1.3.0, CompareData supports an embedded Firebird database. When you install CompareData you also install Firebird ODBC driver that allows CompareData to use the embedded repository. The application automatically creates an internal <Embedded Repository> data source to connect to the embedded database and by default uses the embedded Firebird repository if you don't have another repository already set up as the application repository from a previous release. 

Considerations

You can start out hosting the application repository on the embedded database (default) and as your need grows you can use the application to move the repository from the embedded database to another supported DBMS as described in the application help documentation.

DBMS Repository Support

The following DBMSs are supported for hosting CompareData repository:

To create a repository, you create an ODBC data source to connect you to the DBMS you want to host the application repository and then use CompareData repository wizard to create the repository.

Sharing the Repository

It is recommended to create the repository on the same client machine where CompareData is running using a "personal" DBMS server. However, you can also create the repository on a networked DBMS server where multiple CompareData users can share the same repository schema. Please see the application help for details about sharing the repository schema.

Please note that if you share the repository schema with other CompareData users, then each CompareData user should login to the repository using a different login ID to avoid over-writing other users data.