Apex SQL Diff 2008.05

1. Support for SQL Server 2008 New Features
2. Use Source Control labels and projects as data source
3. Compare SQL Scripts to other data sources
4. Manage Projects and view project information in one compact dialog
5. Filter by Difference Codes
6. Generate richly detailed reports
7. Synchronize databases in one click
8. Choose SQL Scripts to run before and/or after synchronization
9. View script differences with your favorite file diff tool
10. Schedule and Run jobs unattended, overnight etc.

Enhancements:

• New Data Types:  all new datatypes are fully supported and objects using the ones can be compared and synchronized without limitations. This includes Date, Time, Hierarchy, and Spatial datatypes.   
• Enhancements in indexes: all new properties of the indexes are fully comparable and can be synchronized without limitations as parts of their parent objects   
• Enhancements in column properties: the application can track differences in all new column attributes, for example, SPARSE NULL against NULL; all of them are fully supported and can be synchronized in either direction along with parent objects
• Enhancements in procedure parameters and user-defined types: all the enhancements are fully supported and processed by the product   
• Data compression in tables, indexed views, indexes and constraints: differences in data compression can be tracked for any respective object and synchronized without limitations   
• Change Tracking and Change Data Capture: both features are fully supported; the application determines whether CHANGE_TRACKING is enabled or disabled for a table and can synchronize the detected changes making parent tables equal, also any calls to Change Data Capture procedures from within your objects are also be tracked, differences can be reported and synchronized and dependencies to a captured object can be taken into account on synchronizing with the dependencies