Download Devart dbForge SQL Complete Professional Edition v6.11.3.0

Devart dbForge SQL Complete Professional Edition v6.11.3.0

Devart dbForge SQL Complete Professional Edition v6.11.3.0
Devart dbForge SQL Complete Professional Edition v6.11.3.0


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

6.11.3 24-Jun-22
New features and improvements

SSMS v19 Preview 2 integration is added
User-reported and internal bug fixes

Fixed an application error that occurred when starting SSMS 2014
Fixed the display of data in Data Viewer when changing the order of columns in the Editor
Fixed an error that might occur when opening documents
Fixed an issue with displaying Quick Info on an incomplete script
Fixed an issue with missing hints for Linked Server objects
Added temporary table hints that do not depend on the selected database
Fixed the problem with incorrect formatting of procedure parameter names
Fixed an unexpected exception that might occur when copying data to the clipboard (D89130)
Fixed the reset of tabs color settings after closing SSMS with SQL Complete activated (D85351)
Fixed an issue with setting the database name in the Query Editor window when starting SSMS using the -d argument ** (D81862)
Fixed the disappearance of the Document Outline window (D81156)
Fixed an error that occurred when starting SSMS (D87321, D89325, D90091, D90192, D90396, D90381, D90374, D90368)
Fixed memory leak issue that occurred when executing large scripts (D89598, D90100)


Only for V.I.P
Warning! You are not allowed to view this text.
  • 16