Online Documentation for Data Comparer for InterBase/Firebird

Step 1 - Setting connection properties

At this step you should specify necessary settings to establish connection to Interbase/Firebird databases.


Step 1 - Setting connection properties


Connection settings

First select the connection type: local or remote.

Local connection is used to connect to Interbase/Firebird server launched on the same machine where Data Comparer for Interbase/Firebird is running.

The Remote mode allows you to connect to Interbase/Firebird server launched on another computer in the network.


By default the program uses local connection. It is indicated by switch Local selected. If you wish to establish remote connection, you should select the Remote switch. For remote connection you should also enter Interbase/Firebird host name in the Host field and specify the preferable Network protocol (TCP/IP, NetBEUI, Novell SPX). For both types you should enter Interbase/Firebird port to connect through in the Port field.


Afterwards you should specify authorization settings: Login and Password.

The default superuser name is 'SYSDBA' and the default password is 'masterkey'.


Authentication type

Select the preferable type of server authentication to be used for the connection:

  • Normal (traditional IB/FB authentication with security database)
  • Win32 NTLM authentication (only FB 2.1 or above)
  • Mixed


You also need to specify Role (optionally), 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.


Please note that you need to have sufficient privileges to be able to write to the destination database on Interbase/Firebird server.




Tunneling settings


To setup the connection via SSH tunnel proceed to the Tunneling tab and 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


For details see SSH tunneling options.


Step 1 - Setting connection properties - Tunneling



Repeat the steps above for the target Interbase/Firebird connection or just check the Both databases on the same server option for comparing data from databases located on the same server.



When you are done, press the Next button to proceed to the next step.