You'll receive

Bi-weekly updates

Exclusive discounts

Product update alerts

 

ApexSQL DevOps toolkit - Web dashboard release notes

Release:

2018.07.0145

Date:

December 25, 2018

Enhancements:

  • Navigating away from the General options page now displays confirmation dialogue in case changes are not saved
  • Pipeline configuration changes can now be saved or discarded with Save and Cancel buttons
  • The Audit step now automatically excludes tables with existing auditing triggers from new triggers implementation
  • Syntax in the additional parameters text field is now highlighted

Fixes:

  • The Customer service link under the About tab lead to the wrong page
  • The Bottom part of all displayed pages cannot be reached when scrolled down
  • Deploy step shows success status even when the synchronization process fails
  • Editing SQL script data source goes to blank view and creates duplicate data source after save
  • “Unable to find package” error is encountered when using NuGet as a data source in the Sync and Deploy steps
  • Unable to automatically use database script folder as data source in the Build step due to missing folder path definition
  • Cached data from a source control repository remains indefinitely in the application’s source control working folder
  • Summary display window resets to minimum size after changing views
  • Session timeout value is not stored with Save as my defaults option
  • Output folder path under the General options is not restored to default when the ApexSQL defaults button is clicked

Changes:

  • Breadcrumb navigation link now displays "Edit pipeline" text instead of pipeline name when editing an existing pipeline
  • The view mode toggle option is now streamlined in the Pipeline and Data sources view
  • Source and target database connection fields are no longer mandatory when project file is included in a step configuration
  • The text labels that show a pipeline trigger type are replaced with icons
  • Execution button now has Scheduled label for the Pipeline with On schedule type trigger
  • Execution button now has Pending commit label for the Pipeline with On commit type trigger
  • Schema sync step is now Sync step
  • Data sync step is now Sync data step
  • Default installation folder is now changed to ‘C:\Program Files\ApexSQL\ApexSQL DevOps toolkit’
  • Default execution output folder path is now changed to ‘%AppData%\ApexSQL\ApexSQL DevOps toolkit’
  • Default projects folder path is now changed to ‘MyDocuments\ApexSQL\ApexSQL DevOps toolkit dashboard\Projects’

Release:

2018.05.0120

Date:

November 01, 2018

Enhancements:

  • Application session timeout behavior is added with the session timeout settings in general options
  • Custom user name can be created now for initial application account creation in installation wizard
  • Execution summary with SQL Server messages is created after Deploy step execution
  • Pipeline execution summary now includes individual summary details from step executions

Fixes:

  • “Cannot create ‘%project_file_path%’ because a file or directory with the same name already exists” error is encountered when including ApexSQL Diff project file in Schema sync step
  • “Could not connect to server” error is encountered when configuring Team Foundation Server hosted repository with custom collection name as Source control type data source
  • “Define script data source for schema and data synchronization of the selected database” error is encountered when using only schema/data synchronization script
  • “Invalid filename: sqlcmd.exe” error is encountered when executing Schema and Data synchronization scripts simultaneously in Deploy step
  • Application reverts to Light theme on new login
  • Application opens Home page when direct page URL is used
  • Application account password is not encrypted in the application install log
  • Deploy step does not execute the synchronization scripts when they are used as data source
  • Deploy step remains "In progress" status indefinitely when Schema synchronization script is missing as input
  • Deploy step fails when used with Data sync step in the same pipeline while the Data sync step is first enabled and then disabled in two consecutive pipeline executions respectively
  • Incorrect formatting of execution summary texts when shown in summary view window
  • Missing application shortcuts in Start menu and Desktop
  • Resources links are opened in the current browser tab and application session ends
  • Schema changes cannot be deployed when using the script data sources for the Deploy step
  • Step execution outputs remain in default location after changing the output folder path in general options view

Changes:

  • Removed the "open details" text in the link for opening pipeline summary
  • Visual styles in control combo boxes have been changed

Release:

2018.04.0076

Date:

October 11, 2018

Enhancements:

Changes:

  • ApexSQL CI/CD toolkit – Web dashboard name is changed into ApexSQL DevOps toolkit – Web dashboard

Release:

2018.01.0052

Date:

July 02, 2018

Fixes:

  • Populate step always overrides fill row number settings saved in the ApexSQL Generate project file

Release:

2018.01.0051

Date:

June 12, 2018

Features:

  • Standalone graphical web user interface
  • Continuous integration
    • Build a SQL Server database directly from source control and optionally include static data
    • Fill empty tables with synthetic data
    • Integrate trigger-based audit trails and reporting into change sensitive database objects
    • Generate full or differential documentation for the SQL Server database
    • Test SQL Server database using unit tests
    • Enforce database best practices by reviewing, detecting and fixing issues
    • Create a clean database package for easy deployment
    • Publish package to a designated NuGet feed
  • Continuous delivery
    • Compare SQL Server database schemas and create a script for schema synchronization
    • Compare SQL Server static data and create a script for data synchronization
    • Push schema and data changes to a target database
  • Archive all output files in a central folder
  • Fill empty tables with synthetic data
  • Support for multiple data source types:
    • SQL Server database
    • Source control (Git, Mercurial, Perforce, Team Foundation Server, Subversion)
    • SQL script
    • Script folder
    • NuGet package (local or feed)
  • Automatically create rollback scripts
  • Predefined user roles
  • Per user CI/CD pipeline access
  • Visual themes