DBA xPress Release Notes

2019

2019

Version 2019.4.1 [September 24, 2019]

Features

  • Feature 53237: Added SQL Server 2019 support to DBA xPress
  • Feature 55361: DBA xPress Command Line
2018

2018

Version 2018.2.3 [April 27, 2018]

Important:  The 2018.2.3 release for DBA xPress will be the last supported release for SQL Server 2008 and 2008 R2.

Fixes

  • Fix 16031: Schema Inspector's 'Use Case Sensitive Matching' option does not function as expected
  • Fix 16339: Workbench Update Advisor shows 'Updated software is available' on latest version

Version 2018.1.4 [February 8, 2018]

Fixes

  • Fix 11112: Schema Inspector does not always add table store / restore when rebuilding tables
2017

2017

Version 2017.4.5 [November 6, 2017]

Updated Features

  • Update 11979: Online help documentation now includes a rolling list of release notes that include all product release notes within a single file
  • Update 10376: For better clarification, Licensing Registry and Deactivation buttons have been moved

Fixes

  • Fix 12026: Scale is not specified when scripting out tables that include datetime2 columns.
  • Fix 13051: Schema Inspector throws "Object reference not set to an instance of an object." error when not using "Find Object in Any Schema" option

Version 2017.3.3 [August 7, 2017]

New Features

  • New 11677: Added support for SQL Server 2017
  • New 2846: Licensing now works within environments that use FIPS compliant algorithms for encryption

Updated Features

  • Update 11142: Schema Inspector now includes output control for selecting items to include within change script
    • Enabling output control allows you to skip individual elements from change scripts. By doing so, you may end up with a script that is broken (for example, because a dependent object can no longer be created). Please carefully check any generated scripts.
  • Update 11978: License activator now includes a "Copy Details to Clipboard" button

Fixes

  • Fix 11164: Schema Inspector elects to perform a table rebuild before it knows the synchronization direction
  • Fix 12027: Schema Inspector should issue a SP RENAME if the only difference is the object name.
  • Fix 12419: Schema Inspector Report button throws Null Reference Exception error
  • Fix 12403: Denied Access to registry key "HKEY_CURRENT_USER"

Version 2017.2.3 [May 1, 2017]

Fixes

  • Fix 4711: The correct row counts are not displayed when comparing results from two tables that share the same binary(32) or varbinary(32) key
  • Fix 9839: Unable to install two versions of Workbench on the same machine.

Version 2017.1.3 [February 2, 2017]

New Features

  • New 7825: Schema Inspector's modification scripts now include PRINT statements

Updated Features

  • Update 8739: Improved product version logging at start up
  • Update 7430: Help page now includes a button for each installed product that launches local help documentation
  • Update 8755: Help documentation for System Requirements, Permissions and Setup for BI xPress, DBA xPress, DOC xPress and LegiTest combined
    • Since BI xPress, DBA xPress, DOC xPress and LegiTest are all installed within the same Workbench installer, including the system requirements, permissions and setup for the other products within each individual help documentation can help with setup 

Fixes

  • Fix 7816: Schema Inspector sometimes shows duplicate objects
  • Fix 8776: Schema Inspector generated scripts do not include column changes
  • Fix 9142: The license expiration date does not appear in the License Manager
2016

2016

Version 2016.3.7 [August 1, 2016]

New Features

  • New 1478: Workbench now supports high DPI scaling on High Density displays as well as non-default DPI settings

Updated Features

  • Update 4726: Extended 2016 support for DBA xPress
  • Update 4767: Schema Dependencies between Security Policy, Functions, Table and User now included within Schema Surf

Fixes

  • Fix 3815: Preview script can show a blank entry at the start
  • Fix 4916: Either the parameter @objname is ambiguous or the claimed @bjecttype (OBJECT) is wrong
  • Fix 4261: When filters are enabled at launch in High DPI Scaling, the non-filtered plugins won't scale accordingly

Version 2016.2.4 [May 4, 2016]

New Features

  • New 3688: Change chocolatey package ids to those without hyphens
  • New 4118: License Activator available with Product Install
  • New 4167: Update help doc to indicate which components are 2012 and up
  • New 4293: Integrate the Command Line License Acivator and the License Manager into Workbench, Workbench Server, and Task Factory

Fixes

  • Fix 4094: Snapshot Filtering on SQL Server source in IS provider
  • Fix 4264: Notification Engine won't send notifications in a parallel manner although they are received via concurrent connections.

Fixes Workbench

  • Fix 4307: Workbench triggers an /exportlzma and /importlzma notification when opening SSIS packages in (2008) BIDS
2015

2015

Version 2015.2.6 [September 14, 2015]

Updated Features

  • Update Workbench
  • Update installer to be compatible with Windows 10

Version 2015.2 [September 3, 2015]

Fixes

  • Fix Data Inspector
    • (DBA-TFS-10714): Resolve issue where Data Inspector would attempt to insert explicit values into a timestamp column
5.x

Version 5

Version 5.8.5.505 [April 2, 2015]

Fixes

  • Fix Data Surf
    • (DBA-TFS-10352): Resolve generation error that occurred when saving a Data Surf session.
  • Fix Object Browser
    • (DBA-TFS-10352): Resolve generation error that occurred when saving an Object Browser session.
  • Fix Schema Surf
    • (DBA-TFS-10352): Resolve generation error that occurred when saving a Schema Surf session.

Version 5.7.0.929 [September 29, 2014]

Updated Features

  • Update Data Surf
    • (DBA-TFS-8375): Include user input validation when setting the Criteria

Fixes

  • Fix Schema Inspector
    • (DBA-TFS-7819): Fix generated syntax for altering computed columns
  • Fix Schema Surf
    • (DBA-TFS-8400): Update Schema Surf XML and Schema Icon colors so that they are displayed properly

Version 5.5.1.711 [July 11, 2014]

New Features

  • New SQL 2014 Support
    • (DBA-TFS-5241 - DBA-TFS-5243): SQL Server 2014 support is here! All features of DBA xPress have been updated with support for SSIS 2014 & SQL 2014 and is being released in BETA form. Please try this latest release out and let us know what you think.
  • New General Usability      
    • Include DBA xPress Version History with DBA xPress help documentation

Updated Features

  • Update Schema Surf
    • (DBA-TFS-7231): Improve usefullness of connectivity errors

Fixes

  • Fix Data Inspector
    • (DBA-TFS-7140): Update Data Inspector so synchronizing columns containing long literal strings will succeed.
  • Fix Schema Inspector
    • (DBA-TFS-7510): Prevent Schema Inspector from adding TEXTIMAGE_ON to columns of data type hierarchyId
    • (DBA-TFS-7031): Update Schema Inspector to provide valid DDL Scripts for Certificates, Symmetric Keys, Search Property Lists, and Broker Priority objects.

Version 5.1.1.411 [April 11, 2014]

Fixes

  • Fix Data Surf   
    • (DBA-TFS-6651): Update Data Surf to correctly utilize the Preference Load Limit from within the Pragmatic Workbench preferences page.

Version 5.0.20.121 [January 21, 2014]

New Features

  • New Pragmatic Workbench
    • (DBA-TFS-6145): Enable installing multiple versions of Workbench (including BI xPress, DBA xPress, and DOC xPress) on the same computer.

Fixes

  • Fix Data Inspector
    • (DBA-TFS-5363): Allow comparisons between columns of data type sql_variant.
4.x

Version 4

Version 4.9.17.930 [September 30, 2013]

Updated Features

  • Update General Usability
    • (DBA-TFS-4549): Update DBA xPress help documentation to include information on taking snapshots with Schema Inspector Snapshot Tool and Object Browser.

Version 4.7.30.729 [July 30, 2013]

Fixes

  • Fix Schema Inspector
    • (DBA-TFS-3770): Generating HTML Report no longer throws error.

Version 4.5.23.411 [April 19, 2013]

New Features    

  • New Data Inspector
    • (DBA-TFS-1950): Include synchronization summary list that displays total inserts, updates, and deletes occuring.

Updated Features

  • Update Data Inspector
    • (DBA-TFS-1948): Include "Hide Grid" button
    • (DBA-TFS-1946): Update Data Inspector top/bottom ribbons better utilize design space
  • Update Schema Surf
    • (DBA-TFS-2264): Improve navigation pane to better utilize design space 
    • (DBA-TFS-2112): Update welcome screen information  
  • Update General Usability        
    • (DBA-TFS-1886): Server Selection Dialog now saves frequently used servers 

Fixes

  • Fix Data Surf
    • (DBA-TFS-2011): Fix stability issue when selecting tables
  • Fix Schema Surf
    • (DBA-TFS-2263): Fix object border for objects with no designated name so that the object border properly wraps the entire image and title for the object

Version 4.1.70 [January 28, 2013]

New Features 

  • New Schema Surf       
    • (DBA-TFS-2264): The navigation pane now focuses on the most important portions of the tool, including increasing the space allotted to the tree view.
  • New Data Inspector
    • (DBA-TFS-1950): Summarizes and explicitly details the Total Inserted, Updated, and Deleted in a clean, concise, easy-to-read manner.
    • (DBA-TFS-1946): Created a "Settings" container for the Options, Filter, and Map Columns buttons, creating a more user friendly workspace.

Version 4.0.0 [October 3, 2012]

New Features

  • Pragmatic Workbench
    • (DBA-TFS-1639):Pragmatic Works Workbench is now the home to DBA xPress. Each of DBA xPress' features can be accessed from the Features view.
  • Data Inspector
    • Create detailed comparisons between the data stored in two different databases and then synchronize the data so that the target will match the source database's data.
  • Data Space Analyzer
    • Easily manage your SQL Server instances through the display graphs providing you with disk space usage and other server information
  • Data Surf
    • Quickly and easily view the data of a table as well as how that data relates to other tables
  • Object Browser
    • Browse, search, and filter through the content of a SQL Server instance in a way that quickly grants you access to the scripts of each object.
  • Schema Inspector
    • Create detailed comparisons between the schemas of two different databases and then synchronize the schemas so that the target will match the source database's schema.
    • Create point-in-time copies of database objects in the form of XML files using the Schema Inspector Snapshot Tool.
  • Schema Surf
    • Quickly gather information on your SQL Server's schemas and how they relate to each other.