Datanamic DataDiff

KS DB Merge Tools is an easy to use diff & merge tool for MySQL, MariaDB, Oracle Database, SQL Server, PostgreSQL, SQLite, MS Access and Cross-DBMS databases allowing to compare and sync both schema and data. Starting with a schema changes summary, results can be narrowed down to object lists of particular object type (table definitions, views, etc.), and then down to definition of particular object. Data changes can be retrieved as a high-level list of changes totals across all tables in the database, each total row count can be observed as a side-by-side list of rows for the given table, each changed row can be analyzed for changes in each column. Various diff results provide quick filters to show only new/changed/new+changed items (schema objects or table data rows), ability to select required changed items and generate scripts to apply these changes to the other side database. This script can be executed immediately or saved for future use.

dbForge Schema Compare for SQL Server is a powerful tool designed for comparing and synchronizing schemas in SQL Server databases. It detects all discrepancies in the schemas and presents them in a neat and informative visual interface so that users can immediately synchronize changes — either fully or selectively — and deploy them onto supported platforms. Key Features: - Supports for live databases, snapshots, and native backups as data sources - Easy task configuration through intuitive wizards - Restoration of missing or damaged schema objects from native backups - Deployment of changes to SQL Server, SQL Azure, and SQL Server on Amazon RDS - Generation of schema synchronization scripts that can be executed immediately or saved for future use - Automation of regular schema synchronization tasks via command-line dbForge Schema Compare for SQL Server integrates with (SSMS), allowing the database developers and managers to use it in a familiar environment.