KS DB Merge Tools logo KS DB Merge Tools
Documentation
KS DB Merge Tools for Oracle logo for Oracle
 
KS DB Merge Tools for MySQL logo
MssqlMerge logo
KS DB Merge Tools for PostgreSQL logo
KS DB Merge Tools for SQLite logo
AccdbMerge logo
KS DB Merge Tools for Cross-DBMS logo

Open database(s) dialog

This dialog is opened with Open database(s) toolbar action and using Open Database action on each side of the Home tab. Also, if we are opening any previously loaded DB using the 'Recent projects' panel on the Home tab, and that DB was loaded previously without 'Save passwords' - this dialog will be opened to enter the password again.

for Oracle, open database dialog

Use connection strings - use this option to open a database using connection strings. This can be convenient if you already have a connection string and this can be necessary if you can't connect specifying just server, user, password and database. Application uses ODP.NET connection string format. Here is an example of the valid connection string: Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=MyOracleSID)));User Id=myUsername;Password=myPassword;

Use the same server name and credentials for both databases - use this option to compare DBs located on the same server. In this case only 'Database' field will be active for the right side, all other options will be used from the left side.

Display passwords shows user password text.

Save passwords (to reopen from recent DB list without password request) as mentioned simplifies work with recent databases, however please note that encrypted passwords are saved on your computer in the application settings file.

DB Server name is pre-populated with recent used values (same as in Recent databases panel on the Home tab). Database dropdown is populated with recent database names available for that server. You can choose these values from the dropdown or type manually.

If you often connect to the same databases, you can save these connection options to *.ordbs files as suggested on this dialog using Save action for each side. Please note that if 'Encrypt passwords' is not selected then passwords are saved as a plain text, so you should save these files to the safe location. Load action populates server name, credentials and db name back from saved *.ordbs file, but usually this is an unnecessary action - *.ordbs files can be opened directly from the main application window using Open *.ordbs toolbar action or using command line arguments.

Free version limitations:

  • None

Last updated: 2023-10-02