SQL Server Support
Data Types: The release supports all new data types that SQL Server 2008 introduces, as well as the enhancements to existing ones:
- date: a date/time data type that stores only the date portion.
- time: a date/time data type that stores only the time portion.
- datetime2: similar to existing datetime data type, but with a larger fractional seconds and date range.
- datetimeoffset: a date/time data type that has time zone awareness.
- geography: a new data type for geodetic spatial data defined latitude and longitude coordinates.
- geometry: a new data type for planar spatial data defined by coordinate on a plane (used mostly for maps).
- hierarchyid: used to store hierarchical relationship.
- FILESTREAM varbinary(max): a variation of varbinary(max) that stores the BLOB data as file in the file system outside the database
Change Tracking: Support for the change tracking feature of SQL Server 2008. The comparison is controlled by the option: CompareChangeTracking. The option should be set if the change tracking needs to be compared; by default change tracking is NOT compared and neither is synchronized.
Note: Change Data Capture, which is different from Change Tracking, is not supported in this version.
Data Compression: The new data compression feature of SQL Server 2008 is supported. Data compression is recognized, compared and synchronized for following objects:
- Tables
- Primary Keys
- Unique Keys
- Indexes
The comparison is controlled via the option: CompareDataCompression. By default data compression is compared and synchronized.
Indexes: The latest release supports Spatial Indexes as well as the enhancements on the relational indexes such as data compression, filestream, filter predicate.
Full-Text Indexes and Catalogs: SQL Server 2008 brings in some enhancements on full-text catalogs and indexes.
- Full-Text Catalogs: a redesign scripting functionality makes it entirely SQL Server version-specific.
- Full-Text Indexes: contains the new filegroup and stoplist clauses.
Notes: Full-text stop lists are not supported for schema synchronization. Warnings are generated when the full-text index uses a non-system stop list.
Remote Service Bindings: This release supports Remote Service Bindings. The comparison and synchronization is controlled by the schema object type: RemoteServiceBinding. By default this type of object is compared and synchronized.
Service Broker Priority: Service Broker priority is a new entity on SQL Server 2008 that is fully supported. A new object type: ServiceBrokerPriority controls the comparison and synchronization. By default broker priorities are NOT compared.
|
