SQL Toolbelt 包括 SQL Prompt 8.0 和其他新版本。

包括带有一键式 SQL 格式化功能的 SQL Prompt 8.0，以及对 VS 2017 和 SSMS 2017 的支持。
6月 14, 2017
功能发布

特性

SQL Toolbelt includes new features to the following products:

SQL Backup Pro 9.1

  • AWS/S3 Now set uploaded files to be Encrypted AES256.
  • AWS/S3 allow configuration of proxy username/password.
  • Enable AWS uploading to folders.
  • Enable AWS uploading of tags.

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 Comparison SDK 12.2

  • Manage your SDK license through the Getting Started application.
  • Contains the following APIs:
    • SQL Compare 12.
    • SQL Data Compare 12.
  • Both engines now include support for Azure SQL Database and many SQL Server 2016 features.

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 Multi Script 1.3

  • The MultiScriptListExport tool functionality has been included in the main MultiScript application.

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 SQL Prompt Pro 8.0 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.

修补程序

SQL Toolbelt includes fixes to the following products:

SQL Backup Pro 9.1

  • AWS/S3 Ensure that V4 headers are always used on uploading to any region.
  • AWS/S3 Supports uploading to a folder with trailing backslash.
  • OLR is now digitally signed.
  • Fixed SQBHostedStorageClient occasionally failing to purge old log files.
  • fix activity history not working for keep NONE Native Backups.

SQL Compare Pro 12.4

  • SC-9475: Improved interactions around the database dropdown in the Edit Project dialog: in particular, hitting backspace will no longer clear the database name entirely.
  • SC-9437: Fixed a bug which could cause some rows in the My Projects dialog to not render correctly when there were some invalid project files in the displayed folder
  • SC-9457: SQL Compare now automatically applies the default filter (Filter.scpf) when registering from scripts folders or source control.
  • Drop and recreate PERSISTED computed columns when changes are found, rather than rebuilding their table.
  • SC-9455: SQL Compare now produces the correct existence check when renaming a table and moving it between schemas.
  • SC-9403: SQL Compare no longer leaves duplicate NOCHECK statements when deploying to scripts folders
  • SC-9404: Fixed a bug which prevented the saved sort order in the My Projects dialog from being applied correctly
  • SC-9456: Fixed some high-DPI display issues in the deployment wizard 'Deployment method' settings that occurred when the windows UI scale was set to 250% or greater
  • SC-9439: The "Edit selected file" button on the "Error parsing scripts" dialog will now correctly launch the selected editor
  • SC-9271: When an error occurs updating or dropping an extended property the current transaction will now be rolled back
  • SC-9429: When rebuilding a temporal table, SQL Compare no longer scripts out the HIDDEN property or default constraints on the new history table.
  • SC-9443: SQL Compare now correctly scripts out DATA_COMPRESSION on temporal and memory-optimized tables
  • SC-9476: SQL Compare now handles index drops correctly while disabling SYSTEM_VERISONING.
  • SC-9474: Fixed some high-DPI display issues in the deployment wizard title bar
  • SC-9441: SQL Compare now accepts SET syntax where a property on a CLR user-defined type is being set
  • SC-9440: SQL Compare can now register multiple XML indexes on a single table with several selective XML indexes per index

SQL Multi Script 1.3

  • SE-720 Crash on starting up with some legacy licences fixed.
  • SE-730 Rare crash during script execution fixed.
  • SE-731 Cancelling while running a script is now enabled.
  • SE-737 Drag-dropping a script into the selector marks the project as needing to be saved.
  • SE-744: Filenames with multiple periods are now handled correctly
  • SE-746: "Add Existing" before saving any project no longer crashes

SQL Prompt Pro 8.0

  • SP-6338 Fix where condition in parenthesis not breaking.
  • SP-6335 Fix right align where exists.
  • SP-6250 Fix Active Directory Universal authentication.
  • SP-6321 : Fix for 'Invalid name character in Workstation ID' issue.
  • SP-6345 : Fixed DB population of a SQL2005+ linked server when running in a SQL 2000 environment.
  • Prevent crash when user attempts to rename to same style name.
  • Prevent file overwrites when using invalid path characters in style names during style renames.

SQL Doc 3.2

  • SDOC-1834 Unicode database/table names now correctly rendered in HTML output.
  • SDOC-1828: The server option "Max degree of parallelism" is now included in the documentation.
  • SDOC-1827 Error causing crashes while documenting an encrypted object fixed.
  • Migrated to the SQL Compare Engine V12, (include support for Temporal Tables).
  • SDOC-1790: Objects with accented characters in their names can be selected in preview lists.
  • SDOC-1790: Objects with accented characters in their names can have their include sections turned on and off.
  • SDOC-1789: Objects with accented characters in their names can now have their description saved to the database.

SQL Test 1.7

  • Improved SQL Toolbelt installer support.
  • Improved logging around detecting server versions.
  • SQT-493 - Copy to clipboard from messages now works again, even if you have unsaved queries.
  • SQT-494 - Attempting to create an example database without a server connection no longer causes SSMS to crash.
SQL Toolbelt 包括 SQL Prompt 8.0 和其他新版本。
SQL Prompt 8.0 part of SQL Toolbelt.

SQL Toolbelt

进行比较、同步、备份、分析等功能的 SQL Server 各种工具的集合。

索取报价 立即购买

有任何疑问吗?

透过Live Chat与我们的Redgate Software 专家联络!