What’s New in dbForge SQL Complete v5.7

SQL Server Support

  • SQL Server 2016 Service Pack 1 (SP1) new syntax support
  • SQL Server 2017 CTP2 new syntax support
  • Azure SQL Data Warehouse connectivity support

Integration

  • dbForge Schema Compare can be integrated into the latest SQL Server Management Studio v17.2.

Code Completion

  • Highlight of matching columns in the INSERT statement
  • Exclusion of database elements from the Completion List prompt
  • Option to exclude schema in the ON condition of the JOIN statement
  • Option to connect/disconnect when describing/pre-describing objects of the same database
  • Query navigation
  • CASE END pair highlighting
  • Generation of the CREATE/ALTER script for server objects with the object decryption option
  • Extended suggestion in the PIVOT/UNPIVOT queries
  • Extended support for CTE
  • Prompt and QI of variables in named transactions
  • CREATE OR ALTER statement support
  • Display of the estimated row count for tables

Extended Code Completion support for:

  • Object prompting in:
    • CREATE OR ALTER statements
    • DROP ROUTE
    • ALTER ROUTE
    • DROP SERVICE
    • ALTER SERVICE
    • DROP RULE
    • DROP CONTRACT
    • ALTER QUEUE
    • CREATE PARTITION FUNCTION
  • Syntax support for:
    • CREATE ( ALTER, DROP ) COLUMN ENCRYPTION KEY
    • ALTER EXTERNAL DATA SOURCE
    • ALTER EXTERNAL RESOURCE POOL
    • CREATE EXTERNAL TABLE AS SELECT
    • CREATE REMOTE TABLE AS SELECT
    • STRING_AGG
    • CONCAT_WS
    • TRANSLATE
    • TRIM
    • BULK INSERT and OPENROWSET ( BULK… )
    • BLOB_STORAGE option of EXTERNAL DATA SOURCE
    • DBCC CLONEDATABASE
    • ALTER ANY MASK
    • BACKUP (RESTORE) DATABASE TO URL
    • ALLOW_ENCRYPTED_VALUE_MODIFICATIONS

Other Improvements

  • Tab coloring
  • Enabling/disabling SQL Complete from the menu
  • Generate Script As from the SSMS shortcut menu