Compares and synchronizes rows in tables (or views) for SQL Server and SQL Azure. World's fastest, most reliable, and convenient tool, which has lots options and superb user interface. With Optillect Data Compare SQL you can: analyze data difference in details; synchronize production database with development one; migrate data to new version of SQL Server or SQL Azure; generate T-SQL script for tables; generate optimum synchronization script. Optillect Data Compare SQL features: support for all SQL Server versions (2000, 2005, 2008, 2011, SQL Azure); automatic object mapping; compare all possible data types including data conversion; full data transfer or partial data synchronization; lots of options; WHERE clause to filter rows; generate optimum T-SQL script to update target database; automate daily data synchronization via command line interface; build comparison reports in HTML, XML, and CSV formats; generate INSERTs for particular tables or views (even for particular columns and rows); ultra convenient and stylish user interface.
Keywords: compare data, compare two tables, sql server, sql azure, generate inserts, transfer data, row difference,
Recent Changes: Licensing, minor bug-fixes.
Install Support: Install and Uninstall
Supported Languages: English
Additional Requirements: .NET Framework 3.5 SP1
PAD file URL: http://optillect.com/downloads/products/datacomparesql/pad_file.xml