KS DB Merge Tools
Documentation
for Microsoft Access
aka AccdbMerge
for SQL Server
aka MssqlMerge
for MySQL
 
for SQLite
 

Open database(s) dialog

This dialog is opened with Open database(s) toolbar action and using Open Database action on each side of the Project tab.

Server name is used to specify SQL server instance, it can be computer name followed by the SQL Server instance name and port number, here are some examples:

  • MYCOMP connect to default SQL server instance on computer named MYCOMP
  • MYCOMP\SQL2008 connect to SQL server instance named 'SQL2008' on computer named MYCOMP
  • .\nbdell connect to SQL server instance named 'nbdell' on local computer
  • 192.168.55.77\SQL2008 connect to SQL server instance named 'SQL2008' on computer with IP address 192.168.55.77
  • MYCOMP\SQL2008,1444 connect to SQL server instance named 'SQL2008' on computer named MYCOMP using non-default port number 1444

Once you specified valid server name, authentication, user name and password (last two in case of SQL Sever Authentication) - Database dropdown will be populated with database names available for that user. You can choose it from the list or type manually.

If you often connect to the same databases, you can save these connection options to *.msdbs files as suggested on this dialog using Save action for each side. However please note that 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 *.msdbs file, but usually this is an unnecessary action - *.msdbs files can be opened directly from the main application window using Open *.msdbs toolbar action or using command line arguments.

Free version limitations:

  • None

Last updated: 2019-07-04