Released: Sep 14, 2017

Updates in 8.1

Features

New in SQL Prompt Pro v8.1

• Overhauled parenthesis style options UI to improve usability and remove possibility of unusual styles.
• The Parentheses, DDL and CTE pages now have a new way to choose the style of your parentheses.

Fixes

Fixes in SQL Prompt Pro 8.1

• SP-6450 : No longer fail when formatting of valid selection.
• SP-6604 : Fix missing whitespace near AS clause when formatting TRY_CAST statement.

Released: Aug 8, 2017

Updates in August 2017

Features

• SQL Data Compare Pro 12.4
  • Now supports Azure Active Directory authentication with integrated and password authentication methods.
  • The authentication type for databases (Windows/SQL Server) is now specified as a dropdown. This allows more authentication types to be added in the future.
• SQL Monitor 7.1
  • Support for collection of vmware metrics is now out of beta.
• SQL Source Control 5.8
  • Updated the comparison options dialog to display more information and allow searching for specific...

Released: Jun 13, 2017

Updates in 9.1

Features

• AWS/S3 Now set uploaded files to be Encrypted AES256.
• AWS/S3 allow configuration of proxy username/password.
• Enable AWS uploading to folders.
• Enable AWS uploading of tags.

Fixes

• AWS/S3 Ensure that V4 headers are always used on uploading to any region.
• AWS/S3 Supports uploading to a folder with trailing backslash.
• OLR is now digitally signed.
• Fixed SQBHostedStorageClient occasionally failing to purge old log files.
• fix activity history not working for keep NONE Native Backups.

Released: Jun 12, 2017

Updates in 3.2

Features

• Support for SSMS 2017.
• Updated to the latest SQL Compare engine, featuring a number of fixes and enhancements. Allows generating data for temporal tables.
• A password can be specified on the command line on its own.
• The C# example generators have been updated.

Released: Jun 12, 2017

Updates in 3.2

Features

• Supports SSMS 2017.
• New command line switch /server_alias that allows a user to replace an instance name with an alias.
• Password can now be specified on the command line on its own.

Fixes

• SDOC-1834 Unicode database/table names now correctly rendered in HTML output.
• SDOC-1828: The server option "Max degree of parallelism" is now included in the documentation.
• SDOC-1827 Error causing crashes while documenting an encrypted object fixed.
• Migrated to the SQL Compare Engine V12, (include...

Released: Jun 12, 2017

Updates in 1.7

Features

• Now supports SSMS 2017.
• Streamlined new update checking interface.

Fixes

• Improved SQL Toolbelt installer support.
• Improved logging around detecting server versions.
• SQT-493 - Copy to clipboard from messages now works again, even if you have unsaved queries.
• SQT-494 - Attempting to create an example database without a server connection no longer causes SSMS to crash.

Released: May 16, 2017

Updates in 9.0.3

Features

Updates in SQL Backup Pro 9.0.3

• Support for copying SQL Backups to Amazon AWS S3 Bucket.
• Support to allow sqbdir to work using ActiveDirectory Groups.
• Allow jobs to be enabled/disabled from GUI.
• SqbHostedStorageClient can access AWS Command Line Configuration.
• SqbHostedStorageClient can store custom meta tags.
• All current AWS S3 regions are supported - that is, Mumbai, Canada Central, London and Ohio are added in this version.

Fixes

• Improved error messaging/logging when the GUI...

Released: May 16, 2017

Updates in 12.4

Features

• Summary view of detailed differences - New summary view, which lists the semantic differences between two tables now makes it easier to understand why two objects are different.
  This will help people in situations where the SQL diff isn't representative of the differences between two objects, for example:
  • When comparing tables without the "force column order" option.
  • When comparing different database versions so a constraint is inlined on one side and not the other.
  • When ignoring names...

Released: May 10, 2017

Updates in 8.0

Features

• Improved Formatting options.
  The formatting styles are now much more customizable. Added new options based on customer feedback including:
  • Add options for CASE WHEN ELSE END.
  • Disable SQL Prompt on certain blocks of code.
  • Quick switching between styles.
  • Indent comments consistent with code.
  • Support a common intending option for SELECT.
  • Expose all formatting options in the UI.
  • Format common table expressions (CTEs).
  • Simple, but toggle indenting of else if statements.
  • Column aliases...

Released: Apr 11, 2017

Updates in 7.5

Features

Updates in SQL Prompt 7.5

• Add support for SQL Server 2016's WITHOUT_ARRAY_WRAPPER.
• Support for Visual Studio 2017.
• Formatting improvements:
  • ON and WHEN keywords in MERGE statements can now be right-aligned.
  • ELSE IF statements are now indented the same as IF statements.
  • Fix for error when formatting some server broker statements.
  • Short ALTER TABLE statements now respects the 'Collapse Short DDL statements' option.
  • Fix issue with parenthesised expressions sometimes removing spaces between...