DataStar Release: 1.7.9.1

Release Date: 12th August 2020

ClickOnce 1.7.9.1 MSI Installer 1.7.9.1 Chocolatey

Please note DataStar.CmdLine is also available via the Azure Dev Ops Marketplace packaged as a VSIX file. This can be installed into Azure Dev Ops or Team Foundation to provide access to a packaged task or alternatively unzipped to extract the DataStar.CmdLine binaries.


Dependencies

This release depends on Microsoft's .NET Framework 4.7.2 - this should be installed prior to upgrading. You can find the .NET Framework 4.7.2 by following these links:

Features

FEATURE 133 - When generating object scripts DataStar will use the syntax appropriate for the version of SqlServer, for example procedure scripts generated from SqlServer 2012 will contain:

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[MY_PROCEDURE_NAME]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[MY_PROCEDURE_NAME]

However when using a later versions of SqlServer the script will be generated with the newer syntax:

DROP PROCEDURE IF EXISTS [dbo].[MY_PROCEDURE_NAME]

A new feature has been added so that the target version of SqlServer can be specified in the templates to override the default behaviour, to force DataStar to generate the scripts for SqlServer 2012 an option can be specified in the object templates to specify the SqlServer version (version 11.0 is SqlServer 2012):

<Option Name="ServerVersion" Value="11.0"/>

FEATURE 135 - A new feature has been added so that when viewing the contents of the users basket (showing the currently selected components), a user can automatically generate the deployment file from the contents of that basket.

Resolved Issues

DEFECT 132 - Applies to "DataStar.CmdLine" only. When deploying (with reversal enabled) the reversal process previously generated some temporary files, this had the potential to cause a race condition when reading and writing the files resulting in an error message "Error ADS Error creating compensation scripts: Unable to determine the data type for column...". This has been refactored so that the use of temp files is no longer required.