Press Release - New SQLMerger 2.5: Side by Side Database Merge Tool
May, 2009
SQLMerger makes it easier to work with making changes in database data, copying sets of data, database conversions and other data transformation tasks. In SQLMerger you work visually and more hands-on with data than with other solutions. This means you get a stronger overview, a more profound understanding of what is in the databases and better insight about changes in your data. The net result is fewer errors, safer modifications and rich opportunities to use the tool for leveraging your expert skills.
The unique graphical approach and live SQL generation supported in SQLMerger have put high demands towards SQLMerger's developers. However they succeeded making the code more than 10 times faster with the new version where speed optimization has been a major focus point. It now offers the possibility to handle conversion of databases with a million+ records in ten minutes or better, making it possible to use the side by side visual approach on large corporate databases.
The gain is, together with a good speed, SQLMerger provides a high degree of being in touch with what is going on because it is so visually oriented. This allows for a quite different - and nicer - way to work with data, because of the software’s unique design.
How it Works
The primary functionality is to display two sets of data and compare them visually with colors and automatic lookup texts. SQLMerger provides a very user-friendly method for browsing database data. The data displayed can be edited and manipulated through a series of smart data copy- and merging operations. Finally SQLMerger keeps track of all changes and it scripts changes automatically. The script is annotated with old values when changing data. Many data extraction and merging operations can be pieced together in a project that can be used again and again. This way a database conversion can be rehearsed many times before a final conversion giving more assurance for getting it right when it finally counts.
Ultimately all this results in a robust, flexible and open-ended way of working with data. Eventually SQLMerger starts being used by the user to conveniently do more and more things, e.g. complete database conversions; editing by foreign key fields (because it is possible to see a display text from a foreign table automatically); copying of configuration data in databases and much more.
SQLMerger is the obvious tool for developers and database administrators. Additionally it can also be used by business users, e.g. for master data tables maintenance and for comparing data in database backups with the current database.
SQLMerger logs all changes made in the data in SQL log files, both for traceability and so that the script can be run again if you need.
Also the logging mechanisms are improved in the new version related to very large amounts of data. The tool can now seamlessly handle the very large scripts that can be generated for large database conversions.
SQLMerger in new free version!
Also new in version 2.5, the system is now available in a free version with zero cost! Yet there are many useful features to be found such as the visual comparison of databases through color marking of differences and editing of data via automatic lookup texts. Since 1993, Auisoft ApS has been working with advanced software development. The company now also offers database-related services, such as conversions, database design, data washing, optimizations and constructing database queries.
SQLMerger is available at $ 225 (U.S.) (Professional) and $ 395 (U.S.) (Enterprise). (Volume discounts available). It works on all common Windows versions and can connect to virtually all databases (e.g. SQL Server).
###