How-to guides
--------------------------------------------------------------------
|
|
Insight into any database with SQLMerger!
|
When working with complex datasets there can be a lot of challenges.
If you have a database with just 10 tables hten you know it can start to become challenging to keep track on both detials and relationships.
You need a tool to assist you.
How it started?
In 2002 we needed a tool for working with databases in a standard business software system. This system contained hundreds of tables and
a lot of configuration data residing in the database.
This posed massive efforts in handling changes. Because of this we created the user friendly tool SQLMerger. Our tools have since been used to solve the most challenging assignemnts around the world.
You can
-
Compare data in fields,
rows and tables in e.g. backups,
produktion-databases,
test-databases, developmentdatabases
and configuraiton data structures.
-
Carry out complete mergers between databases and tabeles.
And control precicely what should be changed. The process is control in detail in a project file.
-
Syncronize a database
with the last devlopments from a 'master'.
Is this somethis you can use? then buy SQLMerger:
- You wish you would see something else than number codes, when looking directly into the database, e.g. a user name instead of the number 4?
- Have a change script colled automatically, for all the changes you make
Free trial version and 30-days-money-back-gurantee!
3 super characteristics in SQLMerger
-
Visual -
All data is color coded.
- Result orientered -
Data is retrieved in a free manner and can be transformed completely without limitations.
- User friendly -
Foreigh key data is displayed as lookup texts instead of raw key values.
Tip: The free/trial version has an interactive demonstration, running on a built-in demo database; this is a quick and easy way to get an idea of how SQLMerger functions.
Selected Features
|
Feature
|
Enterprise
|
Professional
|
Free
|
|---|
| Make changes to data
and see the changes via intuitive color coding, before SQL code generation (scripting). Checkboxes also shows if data will be updated, added or deleted
|
|
| |
|
Visual comparison
of data from different tables, coming from any database
|
|
| |
|
Lookup texts
displayed manually or automatically to ease browsing and editing with real lookup values (e.g. texts instead of keys)
|
|
| |
| - add lookups for everything in the project, together
|
|
 |
|
|
Sort differences and changes
and all other additional informationfields, e.g. sort records in "different/same", "unique", "new" categories and more. Filter and group records in any dataset
|
|
| |
|
Execute long SQL code texts (scripts)
easily
|
|
|
|
|
Projects
helps manage everything, using the well-known open, save mechanisms etc. A project can work as a process script for a large database conversion and other tasks
|
|
| |
|
Tools for merging and changing contents in a set of data
- copy selected or all, source only records
- change selected or all, difference records to match source
- delete target-only records
- and 5 other tools
|
|
|
|
|
Generate change script
along the way. All changes made to data are scripted automatically
|
|
|
|
| - script all tables together
|
|
|
|
| Log
automatically every change you make to the database in a log file
|
|
|
|
| - store the common log file on a network drive in a multi-user environment, so changes from multiple persons are logged
|
|
|
|
|
Well-format
by selecting a text column and invoking this feature to apply the same 'format' on all texts. E.g. change from "Send-to-processing" to "SendToProcessing" or "SEND_TO_PROCESSING"
|
|
|
|
|
Large texts
are displayed and edited conveniently
|
|
| |
Delete contents
in many interconnected tables, in the correct order automatically
|
|
|
|
|
|
|
|
|
Buy Now
|
Enterprise
| Professional
| Free
|
Requirements
Windows 7, Vista, XP, 2000, NT, ME, 98 or 95.