SQLMerger - How-to Guides

Below you will find a list of easy to understand- and follow guides that will show you how a number of common tasks are performed in SQLMerger and how everyday problems can be solved smoothly with this database tool.

Screenshots are embedded in the guides.

•  Visualize the difference between data in a table in two databases
•  Merge differences between data in a table in two databases
•  Browse data with lookup texts instead of raw number codes
•  Reuse favorite queries easier than ever
•  Edit large text fields with multiple lines with no hassle
•  Merge master/details tables where the primary keys are 'colliding'
•  Create new data as modified copies of an existing master/detail data set copy
•  Execute very large updates without exhausting the database
•  Copy records via single record inserts , instead of using a bulk insert statement
•  Find and replace sub text content in string fields
•  Re-style texts contents to uniform style on e.g. user interface labels
•  Connect directly to SQL Server, MySQL, Sybase and other database types
•  Connect to all databases via ODBC aliases

 

 

General Information

Log in

Before using the examples, it must be possible for SQLMerger to log into the databases. This is configured in the "Database" tab, in the main window. You can either log in via ODBC aliases or log in directly into the databases, for a number of database types (SQL Server, MySQL, Sybase, and many more).

Generic ODBC log in

Via ODBC you can log into any database. However it can sometimes be a little work to establish a functioning ODBC alias in Windows. You can find lots of resources on the Internet on this topic. We only offer support regarding the establishment of ODBC aliases, for a fee. The last of the guides ("Connect to all databases via ODBC aliases)") shows you one example of setting up an ODBC alias, and explains how to use ODBC aliases.

Once this is done, i.e. connection information is specified, SQLMerger can log into the database whenever needed. You can also log on immediately, to test, by clicking one of the "Connected" check boxes.
SQLMerger can log into all databases where you have first created an ODBC alias.

 

Next...