Setting database options
The Databases tab of the Project Options dialog allows you to specify necessary settings to establish connection to InterBase/Firebird databases to be compared.
Database connection properties for the master and the target databases are set in the same way. If both the master and the target databases are located on the same server, you can check the Both databases on the same server option and set all the properties (except for the database name) only once.
Specify the preferable Protocol (Local, NetBEUI, TCP/IP, Novel) and the Port/service to be used for connection.
For non-local protocol you should also enter InterBase/Firebird host name in the Server field.
Afterwards you should specify authorization settings: User name and Password.
The default superuser name is 'SYSDBA' and the default password is 'masterkey'.
You also need to specify the path to the Client library and the path to the Database file (*.gdb for InterBase or *.fdb for Firebird) in the corresponding fields. For successful connection to the server it is crucial to use the appropriate client library - the one that is compatible with the server you are using: gds32.dll for Interbase and fbclient.dll for Firebird. Please note that the client library file must be located on your local machine (e.g. in the directory where the utility is installed). Bear in mind that the path to the database file should be set relatively to the InterBase/Firebird server file system.
Click this button to check the database connection with the parameters you have provided. If connection is successful, you will get the 'Connected!' message; otherwise an error message will be returned.
Both databases on the same server
Check this option if the databases are located on the same server. In this case you only need to specify the database name for the target database connection.
Select this option to enable saving database connection user name and password in the project file.
Check this option if you wish to store your passwords encrypted.
Analyze databases object by object
This option enables/disables comparing databases object by object. If the filter is set for the objects (see Setting compare options), turning on this option may significantly increase the speed of comparison.
Detailed progress log
Tick off this option if you want to get more information displayed on the screen during the database comparison.
Synchronize databases after comparing in console mode
Check this option if you want to execute the result script immediately after comparison; it may be useful if you work with the console version of DB Comparer.
Specify the direction of database comparison and synchronization: From Master to Target or From Target to Master.
Please note that you need to have sufficient privileges to be able to write to the master and/or destination database on InterBase/Firebird server.
To setup the connection via SSH tunnel, input the following values in the corresponding fields:
- SSH host name is the name of the host where SSH server is running
- SSH port indicates the port where SSH server is activated
- SSH user name stands for the user on the machine where SSH server is running (Note: it is a Linux/Windows user, not a user of InterBase/Firebird server)
- SSH password is the Linux/Windows user password
Use Private Key for authentication
Check this option to enable Private Keys usage for the connection.
For details see SSH tunneling options.
Repeat the steps above for the target InterBase/Firebird connection or just check the Both databases on the same server option to compare metadata of databases located on the same server.
When you are done, proceed to the Compare tab to set compare options.