SQL Data Merge
SQL Data Merge is a Windows .NET 2.0 service that can be used to merge MS SQL Database tables. It provides 2 modes of operation: Append and Merge. The Append mode is used for tables that have historical records based on a Date. The target table is evaluated for the most recent entry. Only missing data is pulled from the source table and inserted in the target table. Append supports multiple sources and multiple targets. The Merge mode is used to keep 2 tables in sync - when data changes in the 1st table, SQL Data Merge will make the same change in the 2nd table, and vice versa.

        » Supports unlimited configurations each multi-threaded for high performance
        » Each configuration has its own timing setup
        » Runs as a windows service
        » Append mode supports multiple sources for redundant applications
        » Tested on Windows Server 2000, 2003, and 2008
        » Tested on MS SQL Server 2000, 2005, and 2008

Contact Us for more information