Apex SQL Diff 2008.04

ApexSQL Diff 2008 offers users a speedy and functional Database comparison and synchronization tool. Automatically generate scripts to synchronize two databases, graphically view object script differences, run unattended via the command line or programmable API.
Quickly and accurately compare database structures. Compare live databases, snapshots, and even Source Control Projects/Labels. Automate Database comparisons with a powerful Command Line Interface (included as a standard option). SQL Server 2008 support

Major Features:

1. Support for SQL Server 2008 New Features
2. New Data Types: all new datatypes are fully supported and objects using the ones can be compared and synchronized without limitations
3. Date and Time – simplifying your work with date and time data, providing increased date range, fractional seconds precision, and time zone support. The application can track and synchronize differences in the datatypes scale where it’s applicable, for example, time(5) against time(7)
4. Hierarchy – allowing you to construct relationships among data elements within a table
5. Spatial – predefined CLR data types in SQL Server allowing you to represent information about the physical location and shape of geometric objects
6. Enhancements in indexes: all new properties of the indexes are fully comparable and can be synchronized without limitations as parts of their parent objects
7. 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
8. Enhancements in procedure parameters and user-defined types: all the enhancements are fully supported and processed by the product
9. Data compression in tables, indexed views, indexes and constraints: differences in data compression can be tracked for any respective object and synchronized without limitations
10. 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
11. With the optional ApexSQL Source Control Add-in, developers can leverage the full power of popular source control systems like Subversion, Microsoft Team Foundation Server, and SourceGear Vault. ApexSQL Diff allows you to compare live databases against Source Control labels and projects.
12. Directly compare SQL files (object-creation scripts) to other data sources (live databases, snapshots, etc.).
13. The Difference Code Filter allows you more granular filtering of your comparison result set.
14. ApexSQL Diff offers you several ways to view the comparison results in a well designed HTML Report. You can also use Printable version of the report.
15. The Synchronization wizard is designed for “one-click” synchronization using default options.

Enhancements: updated product

System Requirements:

1. MDAC 2.8(ADO 2.8)
2. MSSQL Server v7
3. 2000, 2005, or 2008
4. .NET 2.0 SP1 Run time

WareSeeker Editor