SQL Toolbelt Essentials includes SQL Prompt 8.0および他の新バージョン

SQL Toolbelt Essentials includes new features to the following products:

SQL Compare Pro 12.4

• Summary view of detailed differences - New summary view, which lists the semantic differences between two tables now makes it easier to understand why two objects are different.
  This will help people in situations where the SQL diff isn't representative of the differences between two objects, for example:
  • When comparing tables without the "force column order" option.
  • When comparing different database versions so a constraint is inlined on one side and not the other.
  • When ignoring names of constraints, indexes etc.
• Summary View - Increased default text size, removed some extra whitespace around the top row of the results and added scrollbars to make the summary view easier to use. The summary view tab will also now stay selected when switching between different objects in the comparison.
• The authentication type for databases (Windows/SQL Server) is now specified as a dropdown. This allows more authentication types to be added in the future.
• Now accepts the 'CREATE OR ALTER' syntax introduced in SQL Server 2016 SP1.

SQL Data Generator 3.2

• Support for SSMS 2017.
• Updated to the latest SQL Compare engine, featuring a number of fixes and enhancements. Allows generating data for temporal tables.
• A password can be specified on the command line on its own.
• The C# example generators have been updated.

SQL Prompt Pro 8.0

• Improved Formatting options.
  The formatting styles are now much more customizable. Added new options based on customer feedback including:
  • Add options for CASE WHEN ELSE END.
  • Disable SQL Prompt on certain blocks of code.
  • Quick switching between styles.
  • Indent comments consistent with code.
  • Support a common intending option for SELECT.
  • Expose all formatting options in the UI.
  • Format common table expressions (CTEs).
  • Simple, but toggle indenting of else if statements.
  • Column aliases alignment.
  • Moving commas from "end" to "start" is always buggy when comments exist.
  • Remove extra space between statements option is needed.
  • Line up type declarations.
  • Place semicolon on new line.
  • Option to place Table names on the same line as the keyword.
  • Do not indent FROM and WHERE clauses.
  • Merge command formatting options.
• Support for SSMS 2017 and Microsoft Visual Studio 2017.
• Added basic support for connecting to Microsoft SQL Server 2017
• SP-6253 Type column overlayed
• SP-6330 INLINE EXEC chops off END when sproc body is wrapped in BEGIN/END
• SP-6213 Format exec parameters as insert source
• SP-6340 Formatting/multiple collapse interaction
• SP 6334 SQL Prompt 8 have issues formatting options HAVING BETWEEN
• SP-6268 New option to insert table on new line
• SP-6342 Comments swapping on same line
• Allow renaming styles in edit mode
• SP-6365 : Nested clause indent support (Insert/select statement).
• SP-6348 : Indent body of create view.
• SP-6361 : Add support for 'ALTER DATABASE SCOPED CONFIGURATION'.
• SP-6362 : Format 'CREATE VIEW' columns correctly.
• SP-6356 : Column list indent and 'Align items across clauses' not working always.
• SP-6352 : 'Collapse short DML statements' option not working with some WHERE breaking combinations.

Please note that this release no longer supports SSMS 2008 R2 or earlier versions.

SQL Doc 3.2

• Supports SSMS 2017.
• New command line switch /server_alias that allows a user to replace an instance name with an alias.
• Password can now be specified on the command line on its own.

SQL Test 1.7

• Now supports SSMS 2017.
• Streamlined new update checking interface.