SQLMerger for merging, moving or converting data in databases

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 you know it can become challenging to keep track on both details and relationships. You need an assisting tool.

How it started?

Years ago we ourselves 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 SQLMerger. Our tool have since then been used to solve the most challenging assignments around the world.

Is this something you can use?
• Compare data in fields, rows and tables in e.g. backups, production-databases, test-databases, development-databases and configuration data structures.
• Carry out complete mergers between databases and tables. And control precisely what should be changed. The process is controlled in detail in a project file.
• Synchronize a database with the latest developments from a 'master' database.
• 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 collected automatically for all the changes you make.

.. then get SQLMerger, it’s easy

Free trial version and 30-days-money-back-gurantee!

and did you know?
• It’s visual - All data is color coded.
• It’s result oriented - Data is retrieved in a free fashion style and can be transformed completely without limitations.
• It’s user friendly - Foreign key data is displayed automatically as lookup texts instead of raw key values.

Selected Features

Feature	Enterprise	Professional	Free
Make changes to data and see the changes via intuitive color coding. Checkboxes also show if data will be updated, added or deleted
Visual comparison of any data coming from any database via intuitive color coding
Lookup texts add automatically to ease browsing and editing with real lookup values (e.g. show display-texts instead of raw keys values)
- add lookups for everything in the project, in one go
Lists differences and possible changes - you can use any standard grid feature to e.g. sort you data on this information
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 in on go
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". Search and replace in tables
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.