Developer Diary: Support of Microsoft SQL Server 2008 in ApexSQL Diff API 2008

LINKS

Site Feed

Developer Diary

Posts, comments, and articles straight from ApexSQL Developers and Analysts

Support of Microsoft SQL Server 2008 in ApexSQL Diff API 2008

As was described in one of the previous blog posts (New ApexSQL Diff Api with Microsoft SQL Server 2008 support), the new version of ApexSQL Diff API supports Microsoft SQL Server 2008.

New data types.

    Microsoft introduced new data types in SQL Server 2008: GEOMETRY, GEOGRAPHY, HIERARCHYID, DATE, TIME, DATETIME2 and DATETIMEOFFSET, VARBINARY(MAX) FILE_STREAM. ApexSQL Diff API supports comparison and synchronization of all these. All these new data types have been added to ApexSql.Diff.SqlServer.SqlDataType enum
    Storage and display of these new datatypes are different. For example, if a new row with GEOMETRY and TIME data type column is being inserted in the synchronization script, it will look as follows:

    INSERT INTO [dbo].[Table_Data] ([id], [val_geometry], [val_time]) VALUES (1, geometry::STGeomFromText('POLYGON ((1 1, 1 5, 5 5, 5 1, 1 1))', 4327), '13:59:58.0000001')

    The geometry data type value is scripted in “string” form and in hex (which is how it’s stored). For time data type value, only the time part is scripted with large precision.
    We have added new properties to DataType class to support the usage of table structures in stored procedures and functions (User-Defined Table Type): IsTableType, and TableTypeObject.

New columns and parameters attributes.

    Support for the SPARSE and XML_COLUMN_SET new table columns attributes have also been implemented by adding the IsSparse and IsColumnSet properties to ApexSql.Diff.SqlServer.Column class objects.

Spatial Indexes.

    We didn’t create a new class for the new spatial index. Instead, we just added new properties IsSpatialIndex and SpatialIndexType to the Index class. Because spatial indexes are very similar to ordinal indexes, we provided access to them using the existing Index class members.

New table attributes.

    New table attributes are implemented using new properties. These are:
    FileStreamFileGroup – property of string type that contains the file group name if unstructured table data is organized into file streams;
    FileStreamPartitionScheme – property of string type that contains partition scheme name;
    ChangeTrackingEnabled – property of boolean type that indicates if change tracking is enabled for the table or not.

New in procedures and functions.

    For stored procedures parameters , a new attribute has been added: READONLY. This parameter can be accessed in ApexSQL Diff API using IsReadOnly property of Parameter class.
    CLR Functions also have a new attribute named ORDER that specifies the order of returned columns. In Apex Diff API, this attribute can be accessed using OrderColumns property of UserDefinedFunction.

What is cooking now.

    Testing of this new version is now ongoing.

Get your developers the tools they need to do the job fast and right - ApexSQL Developer Studio is the ultimate combat multiplier for SQL Developers. Best of Class tools - one download, install and discounted price. Click Here for more info.

Labels: ApexSQL Data Diff

posted by Evgeniy Spashko on Thursday, June 25, 2009

0 Comments: