dbForge Studio for SQL Server v3.8 release notes

SQL Server 2014 is supported

Database

  • Generate Script As shortcut menu option is added
  • Database Visual Editor is added
  • Database Backup and Restore features are added
  • Possibility to attach and detach a database is added
  • Take Offline and Bring Online database states are added
  • Copying a database from one server to another using the MS Agent is possible now

    Generate Schema Script

  • Saving the options setting for future use
  • Support of command line interface
  • Automatic archiving of schema export scripts
  • Writing a report about the process into a log file
  • Automatic removing old files based on date or quantity

    Database Explorer

  • Filter settings are available now
  • Objects’ dependencies view is supported
  • Possibility to duplicate an object is added
  • Renaming a table through the Database Explorer is possible
  • Delete shortcut menu command is available for all objects’ types
  • Disable and enable trigger’s menu options are added
  • Each database state has its corresponding icon now
  • Changing an object name is possible now

    Object Editors

  • Code preview when editing columns, indexes, etc. is possible now
  • Index editor is improved
  • Database editor is added

    Code Completion

  • New CREATE COLUMNSTORE INDEX statement syntax is supported
  • New keywords in the CREATE TABLE statement are supported
  • New keywords in the CREATE INDEX statement are supported
  • New keywords in the CREATE PROCEDURE statement are supported
  • Members prompt for user-defined table type is supported
  • Refactoring aliases is possible now

    Data Compare/Schema Compare

  • Columnstore index is supported
  • Check for object existence option is added to the synchronization wizard
  • Ignore column order in indexes option is added
  • ALTER SCHEMA feature for objects transferring between the schemas is supported
  • Include print comments option is added
  • Exclude comments option is added

    SQL Profiler

  • Query plans can be saved visually
  • Results comparison is executed when the required elements are selected
  • Various queries plans can be shown vertically in one view when comparing
  • Buffer and plans cache refresh options are added
  • Zoom menu in the Profiler diagram is available

    User Interface

  • Switching tabs by the CTRL+ALT+PAGE UP and CTRL+ALT+PAGE DOWN keys combination
  • SSMS shortcut schema availability

    Other Features and Improvements

  • Coloring a database connection according to the document category is possible now
  • Database connection properties are expanded
  • SET connection options in query execution are added
  • Possibility to switch from the wizard page to the main application window is added
  • Find Objects feature is expanded
  • Restoring the documents opened in the last session is possible now
  • SQL document zooming by holding the CTRL key and rotating the mouse wheel is added

Want to Find out More?

Overview

Overview

Take a quick tour to learn all about the key benefits delivered by dbForge Studio for SQL Server.
All Features

All features

Get acquainted with the rich features and capabilities of the Studio in less than 5 minutes.
Request a demo

Request a demo

If you consider employing the Studio for your business, request a demo to see it in action.
Ready to start using dbForge Studio for SQL Server?