Page 1 of 1

Meet dbForge SQL Complete functionality in SQL Server Management Studio 2016

Posted: Thu 21 Jul 2016 08:54
by Devart
Today, we are very pleased to announce the new version of dbForge SQL Complete v5.5 with support for SQL Server 2016 and SQL Server Management Studio 2016.
If you already use the tool, just "Check for Updates” in dbForge SQL Complete to upgrade to the new version. The new features and enhancements increase the power and productivity of database specialists who design, develop, and maintain databases and data storage systems.

What’s new?

Expanded suggestions support for SQL Server 2016 grammar
The latest release of SQL Server introduced a bunch of new features and new SQL syntax. The tool now offers code suggestions for the new syntax when you are developing in SSMS or Visual Studio.

New formatter options and profiles
There are three predefined formatting profiles available. You may use them to save some time on customization process.

Suggestions in CROSS / OUTER APPLY constructions
Now suggestions are available in queries that include a correlated subquery.

Execute statements to cursor position
One simple command to execute all the SQL code located above the current cursor position. To add more convenience to stored procedure debugging and designing related queries.

Compound phrase suggestions
The suggestion engine prompts key phrases along with keywords. For instance, instead of CREATE XML you will get CREATE XML SCHEMA COLLECTION or CREATE XML INDEX.

Object and schema suggestions while writing cross-database queries
The suggestion list prompts database objects as well as schemas while writing cross-database queries.

Download a trial version of dbForge SQL Complete now and evaluate its benefits for free during a 30-day trial period.

Re: Meet dbForge SQL Complete functionality in SQL Server Management Studio 2016

Posted: Thu 21 Jul 2016 15:07
by phoffman81
The installer does not appear to work with the August release of SSMS 2016...the "Management Studio 2016" option is not clickable in the installation wizard.

I reverted my installation to the previous version and was able to install it, though.

Re: Meet dbForge SQL Complete functionality in SQL Server Management Studio 2016

Posted: Thu 21 Jul 2016 19:11
by fwholt
I just installed the update for SSMS version: 13.0.15600.2 successfully. Tested a few features and all looks good.

Re: Meet dbForge SQL Complete functionality in SQL Server Management Studio 2016

Posted: Thu 21 Jul 2016 20:21
by JDSX
phoffman81 wrote:The installer does not appear to work with the August release of SSMS 2016...the "Management Studio 2016" option is not clickable in the installation wizard.

I reverted my installation to the previous version and was able to install it, though.
Yeah, that was a super-fast roller coaster of disappointment just now.

Devart, any chance of a quick update?

Re: Meet dbForge SQL Complete functionality in SQL Server Management Studio 2016

Posted: Fri 22 Jul 2016 00:40
by plebsori
Installer doesn't detect 2016 is installed.

My version info is:

Microsoft SQL Server Management Studio - 13.0.15600.2
Microsoft Analysis Services Client Tools - 13.0.1605.86
Microsoft Data Access Components (MDAC) - 10.0.10586.0
Microsoft MSXML - 3.0 6.0
Microsoft Internet Explorer - 9.11.10586.0
Microsoft .NET Framework - 4.0.30319.42000
Operating System - 6.3.10586

Re: Meet dbForge SQL Complete functionality in SQL Server Management Studio 2016

Posted: Fri 22 Jul 2016 07:33
by alexa
We will fix this issue in the next product build and will notify you once it's available for downloading.

Re: Meet dbForge SQL Complete functionality in SQL Server Management Studio 2016

Posted: Tue 26 Jul 2016 14:58
by alexa
We would like to let you know that dbForge SQL Complete v5.5.145, where the issue you reported is fixed, is available for downloading https://www.devart.com/dbforge/sql/sqlc ... nload.html

Thank you for your help in improving dbForge SQL Complete.