Provide a tool for SQL Server data comparison and synchronization
ApexSQL Data Diff is a SQL Server database comparison tool used to compare and synchronize database data and manage database version control. It also supports comparing database backups, CLI. It can automate and schedule database migrations, propagate data changes from one environment to another, identify and repair lost and/or damaged data, perform row level recovery from SQL backups without restoring. In case something goes wrong ApexSQL DataDiff can reverse any changes made by automatically creating a backup prior to database synchronization. With this tool you'll be able to create sophisticated reports to document the differences between your SQL Server databases and database backups and schedule your migration unattended, using the Command Line Interface
Features:
- Selectively limit what will be compared and synchronized with advanced filtering
- Specify comparison criteria. Create custom comparison keys
- Build complex filters to compare and sync specific data
- Save your options to a project for instant re-execution of the same session
- SQL Server 2012, 2008, 2005 and 2000 support
- Supports SSMS
- Supports FIPS What's new in this version:
The application reads data incorrectly from SQL database backups larger than 4Gb
The "Object reference not set to an instance of an object" error is encountered when comparing an SQL database backup which contains BLOBs
The "Index was outside the bounds of the array" error is encountered when synchronizing databases which contain BLOBs
The columns added to SQL tables or SQL views and SQL tables added to a SQL database, are not automatically mapped when compari... See all new features
The application reads data incorrectly from SQL database backups larger than 4Gb
The "Object reference not set to an instance of an object" error is encountered when comparing an SQL database backup which contains BLOBs
The "Index was outside the bounds of the array" error is encountered when synchronizing databases which contain BLOBs
The columns added to SQL tables or SQL views and SQL tables added to a SQL database, are not automatically mapped when comparing the SQL database using a previously saved project
Operating systems:
Windows 7, Windows Vista, Windows XP, Windows 2003, Windows Server 2008
Additional requirements:
MDAC 2.8(ADO 2.8) MSSQL Server 2012, 2008, 2005;.NET 2.0 Run time SP1; .NET Framework 3.5 SP1
Date:
11.01.2014
Related Software
