| Compare Databases |
Diff Analyzer allows you comparing entire databases on the same or different servers. It compares all db object properties including table structure, referential integrity, fragmentation, and stored procedure's, trigger's and view's syntax. You can also compare individual database objects and groups of objects. |
| Generate database synchronization script | You can generate SQL script that will synchronize two selected databases or two selected tables. |
| Compare and Synchronize Table Data |
Diff Analyzer allows you comparing and synchronizing data in database tables that have identical structure. Compared tables can be located on the same or different database servers. |
| Compare ONCONFIG parameters between two servers. |
You can compare ONCONFIG parameters between two servers. For example, it is very helpful if you want to find the reason of the performance difference between development and production environment. |
| Compare Text Files |
Diff Analyzer allows you comparing any text files including SQL script files, data files, and so forth. You can also compare a stored procedure script with a stored procedure installed in a database. |
| Compare Query Result Sets |
Diff Analyzer allows you comparing any two SQL query result sets produced in the same or different SQL Editors |