dbForge SQL Complete Releases

Released: Oct 1, 2019

Updates in 6.2.23

Features

  • Support for Microsoft SQL Server Management Studio v18.3
  • Code Completion and Snippets Manager Functionality
    • Support for the MIN_ACTIVE_ROWVERSION function
    • Extend Insert Highlight Occurrences feature shows a pop-up with a column name in the VALUES clauses
    • Display MS_Description for Azure objects.
    • Suggest properties for built-in metadata functions (SERVERPROPERTY, FILEPROPERTY, DATABASEPROPERTYEX, etc.)
    • Prompt times zones in AT TIME ZONE.
    • Prompt hint names for USE HINT option.
    • Prompt...

Released: Mar 26, 2019

Updates in 6.1.13

Features

  • Added Visual Studio 2019 support.
  • SQL format command line.
  • Summary panel visibility.

Fixes

  • Problem with aggregate panel.
  • Problem with formatting UPDATE statement.
  • Problem with formatting case-sensitive object names.

Released: Nov 23, 2018

Updates in 6.0.69

Features

  • SQL Server 2019 support.
  • SSMS 18 support.
  • Invoke Search panel instantly with a new shortcut - Keyboard shortcut Shift+Alt+F calls the Search panel in the grid.
  • Days are displayed in execution notification - If a query is runs for more than 23:59:59 hours, days are added to the time in the Execution Notification.
  • Sort snippets in Snippets Manager - You can switch between the titles and shortcuts of snippets and sort them in ascending/descending order to quickly find the one you need...

Released: Jul 19, 2018

Updates in 5.9.66

Updates in 5.9.66

  • Issue with Documentation links is fixed (T259701).
  • Some problems with activation are fixed (T246023,T257072).
  • Assembly loading issue is fixed (T259851).
  • Invalid objects finding issues are fixed (T256421,T255710).
  • Problem with Convert Exec to Script is fixed (T256047).
  • Problems with NRE after freezes are fixed (T250738, T251702).
  • Other issues are fixed (T257787,T256958).

Released: May 16, 2018

Updates in 5.9.60

Features

  • Active Directory - Universal with MFA support - Implemented new SSMS 17.2 - “Active Directory - Universal with MFA support” authentication method. This two-step authentication methond provides an extra layer of protection, such as a phone call, text message, or mobile app code, to deliver an even more secure access to data and applications.
  • Code Completion - New statement suggestions:
    • TEMPORAL_HISTORY_RETENTION
    • HISTORY_RETENTION_PERIOD
    • IDENTITY_CACHE and Automatic database tuning
  • Code...

Released: Feb 15, 2018

Updates in 5.8.178

Fixes

  • Fixed bug where a collection is modified and the enumeration operation does not execute.
  • Fxied issue with invalid procedures.
  • Fixed issues editing SQL documents.

Released: Jan 31, 2018

Updates in 5.8.173

Features

  • Code Completion Features
    • ALTER MESSAGE TYPE
    • DROP MESSAGE TYPE
    • Suggestion in SQLCMD Mode extended
    • Display a list of CHECK and DEFAULT constraints
    • Unwrap sp_executesql
    • OLE DB provider names are now suggested for OPENROWSET and OPENQUERY
    • XML methods suggestion XQuery
    • CREATE TYPE .. AS TABLE
    • CREATE TYPE .. FROM
    • SET DATEFORMAT
    • SEND ON CONVERSATION
    • CREATE QUEUE
    • CREATE AGGREGATE
    • CREATE ASSEMBLY FROM
    • DBCC CLONEDATABASE
  • Jump between BEGIN/END - Navigate through the whole block while matching...

Released: Sep 6, 2017

Updates in 5.7.195

Fixes

  • Fixed issue running several instances of SSMS 2012 and SSMS 2014.
  • Fixed issue for users with limited access to Program Data folder.
  • Other minor fixes and improvements.

Released: Apr 20, 2017

Updates in 5.6.145

Features

  • Compliance with the Federal Information Processing Standard (FIPS).
  • Improved visual style of the application with high DPI support.
  • Product now integrates into VS 2017 and SSMS 17.0 RC3.
  • Restoring last closed tab is implemented.
  • Restoring document sessions is implemented.
  • Ability to close unmodified tabs is implemented.
  • Ability to set custom SSMS main window title and caption for sql document tabs.
  • Support of the following statements:
    • BULK INSERT.
    • ALTER APPLICATION ROLE.
    • DROP...

Released: Dec 5, 2016

Updates in 5.5.218

Features

  • Adds support for Visual Studio 2017.
  • Adds support for SQL Server Management Studio (SSMS) 17.0 RC1.

Fixes

  • Fixed error during parsing and editing text.