Apex SQL Data Diff

ApexSQL Data Diff 2008 is a high performance and sophisticated database comparison tool that will compare the contents of two databases as well as database Backups. - Quickly and accurately Compare Database content - Compare database backups against each other or against live databases- Automate Database comparisons with a powerful Command Line Interface (included as a standard option)- SQL Server 2008 support Support for SQL Server 2008 New Features New Data Types: all new datatypes are fully supported; data in tables and indexed views exposing these types can be compared and synchronized without limitations Date and Time simplifying your work with date and time data, providing increased date range, fractional seconds precision, and time zone support: * Date defines a date within the accuracy of one day * Time defines a time of a day based on a 24-hour clock within the accuracy of 100 nanoseconds * Datetimeoffset defines a date that is combined with a time of a day that has time zone awareness and is based on a 24-hour clock within the accuracy of 100 nanoseconds * Datetime2 defines a date that is combined with a time of day that is based on 24-hour clock within the accuracy of 100 nanoseconds: can be considered as an extension of the existing datetime type Hierarchy allowing you to construct relationships among data elements within a table * Hierarchyid represents position in a hierarchy and sets the desired relationship Between rows Spatial predefined CLR data types in SQL Server allowing you to represent information about the physical location and shape of Geometric objects * Geography represents data in a round-Earth coordinate system and stores ellipsoidal (round-earth) data, such as GPS latitude and longitude coordinates * Geometry represents data in a Euclidean (flat) coordinate system