Download Devart dbForge SQL Complete Enterprise Edition v7.0.158

Devart dbForge SQL Complete Enterprise Edition v7.0.158

Devart dbForge SQL Complete Enterprise Edition v7.0.158
Devart dbForge SQL Complete Enterprise Edition v7.0.158


dbForge SQL Complete provides a wide range of code completion features that relieve users from memorizing long and complex object names, column names, SQL operators, etc. Instead, it allows concentrating on writing high-quality SQL code with correct formatting that is easy to understand and interpret. On this page, you will find a comprehensive list of features available in dbForge SQL Complete.

SQL Complete is an advanced solution for SQL database development, management, and administration. Available as an add-in for Visual Studio and SSMS, the tool offers excellent autocompletion capabilities. Write, beautify, refactor your SQL code easily and boost your productivity dramatically due to the features that are included in SQL Complete but are lacking in Management Studio and Visual Studio IntelliSense.

Speed up SQL query writing with IntelliSense-style SQL code completion
Beautify T-SQL code and unify code standards with a smart SQL Formatter
Get the essential information on DB objects while you are writing code
Format your SQL queries directly in SSMS or Visual Studio
Use rich SQL code snippet collection, manage and modify the existing snippets or create your own templates
Navigate through SQL documents easily and synchronize them with the code
Rename tables, columns, procedures, and functions safely with automatic correction of references to the renamed objects
Boost your productivity significantly with convenient tabs and windows, as well as intuitive management of SQL statements



SQL Code Completion
Enhance code accuracy and quality, as well as simplify the process of creating SQL queries with the following features:

Capabilities:
Context-based code completion
Code completion for CTE
Alias management
Object suggestions
Code refactoring
SQL snippets
Statement suggestions
Code highlighting
Table name autocompletion
The add-in will take care of autocompleting your SQL queries so that you can stay focused on how your code actually works.

T-SQL Refactoring
This feature allows you to improve code readability by giving meaningful and self-explaining names to tables, columns, temporary tables and columns, views, stored procedures, and functions. SQL Complete will automatically correct all references to the renamed objects.

Capabilities:
Renaming objects
Renaming variables
Finding invalid objects
You can also change the names of local and SQLCMD variables in a couple of seconds. Preview code changes in a convenient tree-view of the Rename dialog window. With the SQL Complete tool, SQL code refactoring becomes easy and seamless.

Productivity
Boost your productivity when creating, refactoring, modifying, and beautifying the code using a rich set of features:

Capabilities:
Data Grid commands
Grid aggregates
Jump between queries
Tab coloring
Jump between COLUMNS and VALUES in the INSERT statement
Execution warnings
Execution notifications
Ease of navigation, instant access to database object definitions, and other advanced options greatly facilitate the design and formatting of SQL statements.

SQL Code Formatting
Create new formatting profiles or customize the existing ones to meet your needs. Fine-tune your formatting style to easily improve code readability and introduce unified code formatting standards within your company.

Capabilities:
Formatting profiles
Formatting settings
Formatting in files and directories
Disabling formatting for a certain part of the code
Bulk formatting
With the SQL script formatter, you can work with either new or existing code. Try the online SQL Formatter without having to download or install anything!

See the differences in code before and after formatting
SQL Complete helps users create, customize, and switch between formatting styles, share them with their colleagues, as well as manage and easily format SQL scripts by applying various formatting options.

Intelligent SQL completion and suggestion
Intelligence Coding
Context-sensitive suggestion of keywords
Context-sensitive object suggestions
Context-sensitive object suggestions for T-SQL code, DDL, and security statements
Context-sensitive object suggestions for common table expressions (CTE)
Context-sensitive object suggestions in SQLCMD mode
Name suggestions for objects on linked servers
Sorting suggested keywords by relevance
JOIN clause auto generation
Disable/Enable Code Completion
Phrase completion
Semi-transparent view of the suggestion box
Auto-generation of table aliases
Custom alias mapping
Column picker for quick list building
Wildcard expansion
INSERT, EXEC, ALTER and UPDATE statements expansion
SQL snippets
Recently closed documents
Exclude databases from suggestion
Highlight occurrences of an identifier
Pair highlighting
Named regions
Highlight of matching columns in the INSERT statement
Column name in the values area for INSERT statement
Parameter information for functions
Quick object information
Rows Count information
ON condition suggestion for JOIN
Reverse ON condition suggestion for JOIN

7.0.158 05-Sep-24

Improvements

Introduced the Enterprise Edition of SQL Complete with T-SQL Code Analyzer
Added integration support for Microsoft Visual Studio 2022
Added integration support for Microsoft SQL Server Management Studio 20.2
Added support for non-aggregated columns in GROUP BY statements
Added support for viewing the MSDescription property for databases
Added support for the PERSISTENT_LOG_BUFFER construct in CREATE DATABASE statements
Added support for the RSA_OAEP algorithm in CREATE COLUMN ENCRYPTION KEY statements
Added support for the COLUMN MASTER KEY server object
Added support for T-SQL graph functions: EDGE_ID_FROM_PARTS, GRAPH_ID_FROM_EDGE_ID, GRAPH_ID_FROM_NODE_ID, NODE_ID_FROM_PARTS, OBJECT_ID_FROM_EDGE_ID, and OBJECT_ID_FROM_NODE_ID
Added support for the TERTIARY_WEIGHTS function
Extended support for the AVAILABILITY GROUP constructs
Redesigned the SQL Query history toolbar with an updated date range selection and a new Clear button
Added the ability to save user-defined column layouts in Query History
Added CLI automation for Find Invalid Objects
Added Save Command Line for Find Invalid Objects
Added Save Command Line for SQL Formatter Wizard
Support for Implicit Procedure Execution

User-reported bug fixes

Resolved issues that arose when selecting the case for automatic formatting of identifiers (T252989, T257652, T269036, T270192, T276488, T270192, D76531, D125424, p162685, T307930, T309179, u33847234, p188493, D89127)
Resolved the issue where invoking FORMAT SELECTION caused the query to become invalid (D123102)
Fixed the issue where the Convert EXEC to SQL functionality failed to function on queries without named parameters (D135198)
Fixed the behavior of CTE aliases in subqueries (D135239)
Fixed the behavior of object hints in the FROM clause within table-valued functions (D143009)
Resolved the issue where formatting scripts containing regions caused the query to become invalid (D145046)
Added the capability to set the QUOTED_IDENTIFIER and ANSI_NULLS options in queries generated by the Generate Script As functionality (D152223)
Fixed an issue that occurred when using the Encrypt and TrustServerCertificate parameters in the connection string in SSMS 20 (D155171, D152988, D153163)
Fixed an issue where refreshing snippets did not reflect the most recent changes (D156147)
Resolved the conflict of options that occurred when generating alias names: priority is now given to the mask (u39298627)
Fixed the configuration loading error (T273477, T275412)
Resolved the integration bug that caused SSMS to crash (T314781)
Addressed the issue causing Visual Studio to freeze when SQL Complete is installed (T319352)
Resolved an issue with formatting XML expressions (D124200)
Corrected the misspelling of JOIN's to JOINs in the formatting profile settings (D131175)
Optimized the retrieval of foreign key declarations, resolving the freeze issue in SQL Complete (D135673)
Fixed an issue with the formatting of identifiers when Text Case -> Identifier Case -> As in the database is selected (D137624)
Fixed an issue that occurred when formatting scripts containing the IS DISTINCT FROM predicate (D143389)
Optimized parsing and reference resolution to fix the freezing and crashing issue in SSMS (D141320)
Resolved the issue where temporary tables were not shown in the suggestions (D123955)
Improved the behavior of displaying results in the data grid (D148584)
Added a form to the Send Trace Log to Devart action for providing additional information (D95394)
Improved the behavior of script generation for tables containing IDENTITY columns when using the Script Table As CRUD functionality (D144467, D147287)
Improved the export of money data types to CSV format for the Copy Data As functionality (D149796)


ONLY for V.I.P/Platinum Members
Warning! You are not allowed to view this text.
  • 30