What's New in Studio for SQL Server, v4.0

Administration

SQL Server Events Profiler

  • Create a trace
  • Watch the trace results as the trace runs
  • Store the trace results in a table
  • Start, stop, pause, and modify the trace results as necessary

Analyzer

T-SQL Code Analyzer

  • Identify possible code defects
  • Check T-SQL code for compliance with best practices
  • Code analysis profiles

SQL Editing

SQL Editing and Execution

  • Command-line interface for SQL formatting
  • Changing a snippets folder location
  • Query execution pane
  • Easy way to hide data results
  • Encoding switch in the /execute command-line operation
  • MERGE statement support (syntax checking, formatting)
  • Phrase completion
  • Updated Find&Replace feature in documents and files

Database Explorer

Database Explorer

  • Creating new schemas and displaying all existing ones
  • Alternative ways to create a new object
  • Generate Script As shortcut menu item for check and default constraints
  • Sending objects to a database diagram
  • Renaming columns
  • Displaying the objects number

Object Editors

Object Editors

  • Completely redesigned Index Editor
  • Updated Check Constraint Editor
  • Updated Database Editor
  • Support of user types when working with tables

Schema Comparison

Schema Comparison

  • Custom mapping for tables
  • Updated Synchronization wizard
  • Zooming font size in Text Comparer

Data Comparison

Data Comparison

  • Show white spaces option
  • Ignore computed columns option
  • Zooming font size in Data Viewer

Data Reporting

Data Reporting

  • Support of report parameters in command-line interface

Query Profiler

Query Profiler

  • Diagram printing options for a Query Profiler Plan Diagram

Data Editor

Data Editor

  • Data Viewer, LOB Editor, and Redirect Data to Output are combined in a single control
  • Zooming font size in Data Viewer and Editor Window

Data Export and Import

Data Export and Import

  • Updated Import and Export wizard

Generate Script

Generate Scripts

  • SQL Azure support

Security Manager

Security Manager

  • Creating and editing schemas

User Interface

User Interface

  • Support of multiple monitors

Other Features

Other Features and Improvements

  • Create Schema Snapshot and Data Report wizard windows are modeless
  • Improved application performance when executing a query, opening a table, designing a diagram, and building a query in the Query Builder
  • Windows 10 support


  • SQL Manager Tool & SQL Server IDE for Developers
  • dbForge Studio for SQL Server - Development Tools
  • dbForge Studio for SQL Server - Administration Tools
  • dbForge Studio for SQL Server - Management Tools