All-in-One Powerful SQL Server GUI Tool for your Windows PC

dbForge Studio for SQL Server

Join our mailing list

Stay up to date with latest software releases, news, software discounts, deals and more.

Subscribe
Download dbForge Studio for SQL Server Professional 6.5.140

dbForge Studio for SQL Server

  -  87.2 MB  -  Trial
  • Latest Version

    dbForge Studio for SQL Server Professional 6.5.140 LATEST

  • Review by

    Daniel Leblanc

  • Operating System

    Windows 7 / Windows 8 / Windows 10 / Windows 11

  • User Rating

    Click to vote
  • Author / Product

    Devart / External Link

  • Filename

    dbforgesql58pro.exe

dbForge Studio for SQL Server is a powerful IDE for SQL Server management, administration, development, data reporting, analysis, and a lot more. SQL developers and DBAs performing complex database tasks can use the tool to speed up almost any database experience, such as designing databases, writing SQL code, comparing databases, synchronizing schemas and data, generating meaningful test data, and much more. There is no need to waste time searching for and purchase SSMS plugins across the Internet to get your work done – dbForge Studio SQL Server for Windows PC has it all.



Features and Highlights

Database Development
Database development is a sophisticated process that covers many steps and techniques, not just creating tables and filling them with data. dbForge Studio for SQL Server provides extensive functionality and a bunch of built-in tools that will automate routines and make developers truly agile in the database development process.
  • Edit and run queries in a new SQL document
  • Build queries in a visual designer
  • Run a large script without loading it into memory
  • Track changes in a production database
  • Create unit tests using tSQLt framework
  • Debug stored procedures and functions
  • Source control database changes
  • Create database objects in a visual editor
  • Generate database scripts


Database Management
Database management tools included in dbForgeStudio for SQL Server (Windows Edition) help DBAs to protect data and resolve problems before they harm your database health.
  • Compare and synchronize database schemas
  • Compare and synchronize data of two databases
  • Copy databases
  • Generate database documentation in HTML, PDF, or Markdown file format
  • Create schema snapshots
  • Generate test data and instantly populate a database
  • Export/import table data to a file (CSV, Excel, XML, etc.)
Database Administration
Database administration is a complex and time-consuming work that requires high skills and experience. That's why Studio for SQL Server provides professional SQL Server administration tools for secure database management.
  • Automate deployment to a production server
  • Set up user accounts and permissions
  • Copy, move or upgrade an SQL Server database
  • Backup and restore databases
  • Monitor SQL Server performance in online mode
  • Generate schema and database scripts
  • Diagnose server problems using traces
  • Find and fix database index fragmentation issues
Note: 30 days trial version.

  • dbForge Studio for SQL Server Professional 6.5.140 Screenshots

    The images below have been resized. Click on them to view the screenshots in full size.

What's new in this version:

dbForge Studio for SQL Server Professional 6.5.140
- Added support for the CREATE TABLE AS SELECT statement in Azure Synapse

Fixed:
- Fixed an error that occurred when comparing databases with full-text indexes
- Improved the behavior of the Enclose identifiers within square brackets option when generating triggers
- Improved the parsing of the Output Clause in DML statements
- Enhanced the functionality of the Paging Mode in the Data Editor Card View
- Improved the behavior of the restoration of the Template Card settings in the Data Editor Card View when re-executing a SELECT query
- Fixed an issue with the data input popup window in the Data Editor closing unexpectedly
- In Source Control, DDL object comparison now considers whitespace characters; previously, they were ignored
- Fixed an error that occurred when exporting data to Google Sheets
- Fixed an issue with the connection lists to the server disappearing when multiple Studios are used concurrently
- Fixed an error that occurred when expanding the MEMORY_OPTIMIZED table nodes in Database Explorer
- Fixed the UI issues that occurred when working with the Studio launched under Crossover on MacOS
- Fixed an error that occurred when executing scripts containing a variable named @go
- Fixed an internal application error that occurred when retrieving database properties


dbForge Studio for SQL Server Professional 6.5.16
Code Completion improvements:
- Added support for the GENERATE_SERIES and OPENQUERY relational operators
- Added support for the following functions: LEFT_SHIFT, RIGHT_SHIFT, BIT_COUNT, GET_BIT, and SET_BIT
- Added support for the APPROX_PERCENTILE_CONT and APPROX_PERCENTILE_DISC aggregate functions
- Added support for the DATETRUNC function

Schema/Data Compares and Source Control:
- Optimized the process of describing scripts folders

User-reported bug fixes:
- Fixed a data loss issue that occurred during XML import
- Resolved an error related to reading server event profiling templates
- Fixed an error that occurred when the SQL document was closed while processing the parameter list for functions
- Fixed an error that could occur when launching the synchronization wizard in Schema Compare
- Resolved an error that occurred when trying to open Security Manager while connected to SQL Server 2022
- Expanded the list of conditions in the Filter Editor for columns of type int in the Data Editor
- Fixed an error that occurred when debugging a script containing a system procedure
- Resolved a freezing issue that occurred when editing values in large tables in Data Editor
- Improved the reading of JSON files, detection of NULL values, and error handling within the Data Import feature
- Fixed a false warning in the Data Editor that incorrectly indicated missing unique keys for SQL Server 2000
- Fixed an issue with sudden crashes that occurred during complex script editing


dbForge Studio for SQL Server Professional 6.4.124
Added:
- DML triggers sorting in Source Control
- the syntax support for calling procedures/functions without the EXEC/EXECUTE keyword

Fixed:
- an issue with locking the user interface when switching between SQL Document windows
- an issue that occurred when displaying the informational window
- an issue with the text search across DDL objects in Object Search
- an error that occurred when using the Google Sheets data export template
- the behavior of the Ignore History Table option
- the display of the datetime data type in the data comparison grid
- the display of the Generate Script As command for an empty table
- Supported the EXEC command in Syntax Check


dbForge Studio for SQL Server Professional 6.4.7
New features:
- Optimized system resources consumption when preparing the Quick Info and Code Completion hints
- Support for macOS & Linux via CrossOver

Improved:
- Added the behavior to open the Objects Filter window when creating a Schema Compare document
- Added support for modifying a view comment in the Object Editor
- Added disk folder cleanup for the Unlink command in Source Control
- Added the ability to set the object filter file from the CLI for Schema Compare
- Improved Code Completion on the MFA connections
- Improved the behavior of the Ctrl+C/Ctrl+X shortcut to copy the entire line of text if nothing is selected
- Implemented the output of the original text of the view object for the MoDify command
- Improved the metadata reading behavior - the VIEW DATABASE STATE privilege is no longer required
- Improved formatting under the Text Case - Identifier Case - As in the Database configuration
- Improved syntax check
- Improved query profiling on SQL Server 2019/2022
- Improved the Backups report in Monitor
- Improved the Source Control informational message displayed in case of the presence of a non-existent schema object
- Improved formatting under the Text Case - Identifier Case - As in the Database configuration
- Improved syntax check
- Improved query profiling on SQL Server 2019/2022
- Improved the Backups report in Monitor
- In Source Control, added the ability to link a database to a subfolder in a Git repository

Fixed:
- an issue with extended properties in Source Control
- a bug that occurred when importing data
- a bug that occurred when configuring the Table or View generator
- the Data Editor issue with the UID data type
- the Window menu bug
- the behavior of saving changes in the Table Editor
- a bug that occurred after closing the SQL document
- the 'Database files are not found' error in Transaction Log
- the export of boolean values to JSON format
- a bug that occurred when creating a comparison report in Data Compare
- text color in the ODBC data export grid
- a bug that occurred when executing the Generate Script As command
- the disappearance of the DESC keyword in Query Builder
- an error that occurred when generating a trigger DML script
- 'The connection was not closed' error
- an Object Viewer bug
- an issue with saving an object in the Object Editor
- an error that occurred when working with statements containing the PIVOT/UNPIVOT clause
- an error that occurred when getting object metadata on Azure servers
- an issue with the hints behavior that occurred when changing the database context in the script using the USE statement
- the logic of handling the Description property for Azure SQL Database objects
- the logic of handling permissions in Schema Compare
- the permissions issues that occurred when comparing database objects with Schema Compare
- an error that occurred after linking a database in Source Control
- an object synchronization error in Schema Compare
- a bug that occurred when working with UDT


dbForge Studio for SQL Server Professional 6.3.9
General:
- Connectivity support for SQL Server 2022 CTP 2.1

Expanded keyword suggestions:
- Added support for CREATE INDEX and ALTER INDEX for SQL Server 2022
- Added support for CREATE CLUSTERED INDEX for SQL Server 2022
- Added support for CREATE TABLE and ALTER TABLE for SQL Server 2022
- Added support for ALTER DATABASE SCOPED CONFIGURATION for SQL server 2022

New query hints and syntax constructs:
- Added query hints for the DELETE, INSERT, SELECT, UPDATE, and MERGE statements
- Added support the BACKUP SYMMETRIC KEY syntax construct
- Added support the RESTORE SYMMETRIC KEY syntax construct
- Added support for the DATE_BUCKET function in the Completion List, Quick Info, and Parameter Information

Improvements:
- Improved performance of the Refresh operation in Source Control
- Updated the query execution plan for SQL Server 2022

User-reported bug fixes:
- Fixed incorrect script generation for table-based types in specific environments
- Fixed poor Data Editor and Data Viewer performance when operating huge data sets
- Fixed a syntax error that occurred when using built-in functions
- Fixed a bug in Table Editor that occurred when changing table options in a script
- Fixed a syntax error that occurred when accessing columns whose names match the names of the built-in functions
- Fixed a bug that occurred when working with Query Builder
- Fixed symbol duplication that occurred when placing separators (Insert Semicolon) in the script
- Fixed an issue with fetching data in Data Editor
- Added support for creating constraints on the computed columns in Table Editor
- Fixed a bug that occurred when working with Static Data in Source Control


dbForge Studio for SQL Server Professional 6.2.52
Fixed:
- an error that occurred when displaying database schema synchronization script
- an error that occurred when switching between the pages of the Link Database to Source Control wizard
- an error that occurred when connecting to the Azure server
- an issue with hinting objects in the CROSS APPLY context
- an issue with generating a Scripts Folder
- a false positive syntax check error
- an unexpected exception that occurred when dragging and dropping database objects
- a bug with editing functions
- the behavior of shortcuts in SQL Editor
- incorrect comparison of extended properties in Schema Compare
- static data processing in Source Control
- the processing of shortcuts for Outline commands
- an error in executing the Generate Script As command for a trigger


dbForge Studio for SQL Server Professional 6.2.22
New features and improvements:
- Added support for new functions in the Completion List, Quick Info, and Parameter Information: GREATEST, LEAST, CURRENT_TIMEZONE, CURRENT_TIMEZONE_ID
- Added support for the FORMATFILE_DATA_SOURCE parameter for bulk_options in the OPENROWSET function
- Extended support for the comparison of SQL Server 2014-2019 backup files
- Improved the server connection behavior to avoid blocking connected databases
- Improved the behavior of wildcard-aided search in a Schema Compare document
- Improved the display of the object type list in the filter window of a Schema Compare document
- Improved the grid display in the Monitor document
- Improved the logic of column width auto-adjustment in Data Editor
- Improved the diagnostics of false syntax errors in Query Builder

User-reported bug fixes:
- Fixed an issue that occurred when launching schema comparison
- Fixed the performance of the source control update operation
- Fixed an issue that occurred when working with static data in source control
- Fixed an issue with the formatting of spatial data types
- Fixed a text editor issue
- Fixed an issue that occurred when closing the application
- Fixed an issue that occurred when comparing data
- Fixed an index synchronization issue
- Fixed the performance of the commit and push operations in source control
- Fixed an issue that occurred when changing the database in a SQL document
- Fixed a command-line editor issue
- Fixed an issue with displaying a container header on a diagram
- Fixed a documentation generation issue
- Fixed an issue with displaying text comparison differences
- Fixed an issue that occurred when working with the file system
- Fixed an issue with displaying nodes in Database Explorer
- Fixed a data generation issue
- Fixed an issue that occurred when working with transactions during schema synchronization
- Fixed an issue with the installation package
- Fixed an issue with document generation for encrypted procedures and functions in Documenter
- Fixed an icon display issue in the Monitor document
- Fixed a log file initialization issue that occurred when opening the application
- Fixed an issue with the CONTRACT permission type in Security Manager
- Fixed an issue with the search and replacement of values in Data Editor
- Fixed an issue with creating a foreign key on a database diagram
- Added the capability to control the column width for text data in Profile Server Events
- Fixed a data filtering issue in Data Editor
- Fixed an issue that occurred when opening Data Compare
- Fixed the Close all unmodified command for object editors
- Fixed an issue that occurred when opening a Monitor document
- Fixed an unexpected exception that occurred when copying data to clipboard
- Fixed an application uninstallation issue
- Fixed an unexpected exception that occurred when creating data reports for non-SELECT scripts
- Fixed an unexpected exception that occurred when building dependencies for Queue objects while generating documentation
- Fixed an unexpected exception that occurred when describing database objects during search
- Fixed an unexpected exception that occurred when working under the Azure Active Directory connection
- Fixed an issue with the interception of external exceptions by SQL Tools
- Fixed an issue that occurred when performing Analyze Code for a script with NOCOUNT ON
- Fixed an issue with the display of differences in the XLS comparison reports in Data Compare
- Fixed an unexpected exception that occurred when generating HTML documentation
- Fixed the behavior of the Reseed Identity Columns option for Azure connections in Data Compare
- Fixed an unexpected exception that occurred when exporting data to the Excel format
- Fixed an unexpected exception in Data Editor
- Fixed an issue with defining columns in a script for Python Generator in Data Generator
- Fixed an unexpected exception that occurred when describing databases with identical names for Schema and Assembly objects in Documenter
- Fixed an issue with connecting a database to a version control system
- Fixed an issue with reading data from the server when executing a script
- Fixed false syntax errors
- Removed an error report thrown upon switching to the Design tab in cases when the query contained syntax errors or was not supported by Query Builder
- Fixed an issue that occurred when inserting a drop-down list element into the text
- Fixed an issue with calculating the Parameter Info of a function that was referred to via a synonym
- Fixed a script formatting issue
- Fixed an issue that occurred when updating the database object cache for hints
- Fixed an issue that occurred when loading SSMS extensions
- Fixed the highlighting of the system statistical functions in SQL Editor
- Fixed a text editor issue on the Windows Build 22567 or later
- Fixed the behavior of the Parameter Info hint
- Fixed the behavior of the Quick Info hint
- Fixed an issue that occurred when working with the table editor
- Fixed the display of data in the login_time and last_batch columns on the Sessions tab in Monitor
- Fixed an issue that occurred when working with a data comparison document
- Fixed an issue that occurred when selecting view columns from its query
- Fixed an issue that occurred when viewing trigger dependencies in Database Explorer
- Fixed an issue with loading an SQL script from a saved file to a document
- Fixed an issue that occurred when analyzing differences in Queue objects while executing the Get Latest command


dbForge Studio for SQL Server Professional 6.1.14
New features and improvements:
- Support for the Execution step for the Jenkins, TeamCity, and Bamboo plugins
- Support for the UPDATETEXT, SEMANTICSIMILARITYTABLE, SEMANTICKEYPHRASETABLE, and SEMANTICSIMILARITYDETAILSTABLE functions
- Added the check constraints hints for the ALTER TABLE statements
- Support for the WAIT_AT_LOW_PRIORITY option for the ALTER TABLE ... SWITCH PARTITION statements
- Added the DISTRIBUTED_AGG hint for the SELECT - GROUP BY queries
- Added the suggestion of keywords for ALTER/DROP DATABASE SCOPED CREDENTIAL statements
- Added the suggestion of keywords for the ALTER DATABASE SCOPED CONFIGURATION statement
- Added the suggestion of keywords for MEMORY_OPTIMIZED in the ALTER SERVER CONFIGURATION statements
- Support for the CREATE/ALTER/DROP EVENT SESSION session_name ON DATABASE statements
- Support for Query Store options in the ALTER DATABASE statements
- Improved the behavior of data sorting in Data Editor
- Improved the display of table relationships on the Query Builder diagram
- Improved the error diagnosis when working with Source Control
- Added the ability to resize the search text field
- Added a warning when trying to save read-only files with the applied changes

Fixed:
- Excluded collations from elements falling into the category of identifiers when working out the Enclose identifiers within square brackets option (U36183154)
- search behavior for the UNIQUEIDENTIFIER columns
- unexpected exception thrown when creating a connection
- unexpected exception thrown when generating database documentation
- unexpected exception thrown when closing the SQL Document with the running Query Profiler
- unexpected exception thrown when running the application tracer
- an issue with saving changes in the table editor
- a request to get events in Event Profiler
- a definition of columns and data for importing data from a JSON file in which JSON properties are missing
- an issue that occurred when starting the application with the Object Viewer open and the Database Explorer closed
- an issue with getting the name of the branch for the Git repository
- the 'Connection Timeout' error in the SQL Document
- the 'The connection is closed' error in the SQL Document
- an issue with data export freezing on a database with a large quantity of objects
- an issue with reading comparison parameters in console mode in Data Compare
- a query execution error in the SQL Document in Data Compare
- an issue with using the object names mapping options in Data Compare
- an issue with defining unique keys when using object names in different registers in Data Editor
- a bug in the Link Database to Source Control wizard in Source Control
- an issue with synchronizing the list of connections to database servers
- an error in the document service that occurred when starting the application
- an issue with accessing partition functions for SQL Server 2000 Storage options in Object Editor
- an issue with generating Excel and HTML reports when the 'Hide unmodified columns' option is enabled in Data Compare
- the behavior of Code Completion on case sensitive servers
- false positives of Syntax Check
- an issue with calculating Quick Info
- an issue with launching Monitor
- an issue with highlighting associated IF/ELSE keywords
- an issue with calculating Parameter Info when accessing the procedure using a synonym
- an issue that occurred when performing Refresh Suggestions
- an issue with Output that occurred when working with SQL Tools versions integrated into SSMS
- an issue with data import through templates
- an issue with navigating to the similarly named triggers in different schemas
- an issue with calculating Parameter Info
- an issue with creating an incorrect tooltip for a connection element when starting the application
- an error that occurred with comparing data
- an issue with comparing user-defined object schemas that differ only in spaces
- an issue with reading data in the table editor
- an issue that occurred when comparing a database with the Script Folder
- an issue with synchronizing objects with data recovery when comparing schemas
- an issue with renaming a snippets folder
- an error that occurred when starting SSMS
- an issue that occurred when creating a connection with custom parameters
- an issue that occurred when starting the application
- an issue when starting the application with the opened Start Page
- an problem with poor performance when working with TFS
- the OutOfMemoryException error that occurred when synchronizing schemas
- an issue with generating a data comparison report in the XLS format
- an issue that occurred when closing the application
- a syntax error in the STRING_AGG construction
- an error that occurred when comparing a database with an empty folder
- an issue in Source Control when working with a case sensitive database server
- the behavior of keyboard shortcuts
- an error that occurred when starting the SQL Server Monitoring Tool
- an issue with zooming text in the SQL Server Monitoring Tool
- Returned the capability to insert a JOIN condition after an open parenthesis


dbForge Studio for SQL Server Professional 6.0.563
- The application fails with a critical error when trying to create diagram objects after installing the KB5006670, KB5006672 or KB5006674 Windows update


dbForge Studio for SQL Server Professional 6.0.560
New features and improvements:
- Ability to simultaneously connect with different ApplicationIDs to Azure SQL Server

Fixed:
- Unexpected exception when selecting Style in Documenter on Azure connection (Z55517)
- Unexpected exception when changing a database on the connection
- Error during the data export to an Excel file (Z62513)
- Unexpected exception with the filter in Documenter
- Error during the data export through ODBC (Z57386)
- During data import, the values from default constraints for the columns of the target table were ignored
- Error during the data generation for the tables with composite primary keys
- Error with the integration of several add-ins
- Improved behavior of linking system databases in Source Control
- Error with updating a document in Source Control
- Error with getting a list of schemas on the SqlServer 2000
- Error with getting a list of files in the Browse for Folder window
- Error with canceling the operation in Data Editor
- Error with changing databases on the SQL Server connection
- Error with editing data for the selection from tables of different schemas in Data Editor
- Typos in the Filter window of Data Editor (Z59481)
- Error with closing a parallel connection in Data Editor (Z53577)
- Improved behavior with the active Paste As New Records command in Data Editor (p195068)
- Error when executing the Go To Definition command to a remote connection to the server
- Improved behavior of active control of changing the current database when executing the query in SQL Document
- Coloring of cells with the NULL values in Data Editor (Z57818)
- Error when completing the procedure with parameters in Data Editor (Z57682, Z61911)
- Error when executing a query with parameters of the Date type in Paginal Mode in Data Editor
- Error with specifying an incorrect value in the Filter window in Data Editor
- Error with updating transaction operations in a SQL Document
- Error with closing wizards when getting a list of databases
- Generation of a DDL trigger when executing a command from Database Explorer (Z56348)
- Description of the column in Database Explorer (p45705)
- Issue with deploying a tSQLt framework on the Azure SQL database (Z58747)
- Invalid response to syntax check (Z60052, Z59176, Z60241)
- Issue with saving changes in the procedure to the server (Z59244)
- Error with closing SQL documents (Z55637, Z58342)
- Error with updating a table
- Bug when scrolling the drop-down list with the mouse wheel
- Incorrect change of a query when updating it in Query Builder (p196244, Z60596)
- Bug when launching Data Compare from the command line
- Update of a procedure script after modification (Z56348)
- Processing of the Ctrl+A, Ctrl+C shortcuts in Data Viewer (Z56062)
- Bug with Commit in Source Control
- Added the ability to connect with MFA through a proxy (Z59810)
- Errors in the synchronization script in Schema Compare (Z55541)
- Bug when deleting a column in the table editor
- Handling of CTRL + 0 on the numeric keyboard (p194936)
- Error with synchronizing Extended Properties for views


dbForge Studio for SQL Server Professional 6.0.383
- ALTER for views was generated incorrectly
- Error with duplicating the max size for varchar, nvarchar, and varbinary when generating CREATE
- Critical error when reading metadata for an external table
- Error with processing a procedure during synchronization
- Temporary Schema Compare synchronization script files duplicated in Recent Files
- Error with closing the Data Comparison document
- Error with the report generation
- Critical error when processing mapping during comparison
- Mechanism of deletion of temporary folders
- Critical error with processing metadata for nullable columns
- Error with working with documents when closing the application
- Display of the 'Hide unmodified columns' button in the comparison document
- Issue with activation of the application
- Issue with opening SqlDocument when navigating from the Error List window
- Issue with the 'Create or Alter' command when copying to clipboard
- Issue with opening the trigger editor from another schema
- Query execution with USE in SqlDocument
- Behavior in the view editor when working with Query Design was tweaked
- Behavior when editing a query with comments in Query Builder was tweaked
- Inputting fractional values in the parameter editor when executing a procedure
- Error with working the TFS version control system
- Error with starting the application
- Error when changing the connection status in SqlDocument,
- Date and time formats for data editor were improved
- Option for enclosing identifiers within square brackets when generating scripts was added
- Incorrect parsing of types enclosed within square brackets
- Possible error with closing IDE with a floating document
- Customized toolbar buttons order was not restored after restarting IDE
- Code completion failed to suggest columns from CTE
- IFF function was not highlighted by the code editor
- Build step of Azure for Release pipeline failed to proceed
- IDE failed to parse specific complex scripts
- Incorrect syntax check for AT TIME ZONE clauses
- Code completion failed to suggest objects from schemas except for the default one
- Pressing Backspace within the search dialog led to the selection of the last character from the remaining text
- Text from the clipboard was pasted to incorrect locations in case of the multiline selection
- Error when exporting to ODBC Dynamics Driver
- Unexpected exception when saving document cache
- Exception occurred during the application activation
- Exit codes output in the command line for the unit testing functionality


dbForge Studio for SQL Server Professional 6.0.330
User-reported bug fixes:
- Error with loading the application with certain OS (Z49539, Z49498)


dbForge Studio for SQL Server Professional 6.0.237
The DevOps Automation feature:
Now dbForge Studio for SQL Server takes part in DevOps Automation. On the start page, in the DevOps tab, added links to install the following plugins:
- Plugin for Jenkins
- Plugin for TeamCity
- Plugin for Azure DevOps
- Plugin for Bamboo
- PowerShell module that helps with organizing database DevOps processes for your SQL Server databases. It allows you to develop, source-control, and safely automate the deployment of database changes by using dbForge for SQL Server tools via the PowerShell interface.

Connectivity improvements:
- Heroku Cloud connectivity support
- Display of the SQL Server version when testing connection

Code Completion improvements:
- Column sensitivity classification information available in the completion list and Quick Info
- Support for functions: NEWSEQUENTIALID, CERTPRIVATEKEY, CERTENCODED, PWDENCRYPT, PWDCOMPARE, MIN_ACTIVE_ROWVERSION
- Support for statement: GRANT ALTER ANY SECURITY POLICY
- Support for statement: GRANT ALTER ANY SENSITIVITY CLASSIFICATION
- Support for statement: GRANT ALTER ANY DATABASE SCOPED CONFIGURATION
- Support for statement: GRANT ALTER ANY COLUMN MASTER KEY
- Support for statement: GRANT ALTER ANY COLUMN ENCRYPTION KEY
- Support for statement: GRANT EXECUTE ANY EXTERNAL SCRIPT
- Support for statement: GRANT ALTER ANY EXTERNAL DATA SOURCE
- Support for statement: GRANT ALTER ANY EXTERNAL FILE FORMAT
- Support for statement: GRANT ALTER ANY EXTERNAL LANGUAGE
- Support for statement: GRANT ALTER ANY EXTERNAL LIBRARY
- Support for statement: GRANT ADMINISTER DATABASE BULK OPERATIONS
- Support for statement: CREATE/ALTER/DROP EXTERNAL LANGUAGE for SQL Server 2019
- Expanded support for the function PREDICT for SQL Server 2019
- Expanded support for CREATE USER for Azure SQL Database
- Expanded support for CREATE INDEX for SQL Server 2019
- Expanded support for CREATE EXTERNAL LIBRARY for SQL Server 2019
- Expanded support for ALTER DATABASE for SQL Server 2019
- Expanded support for ALTER TABLE for SQL server 2019
- Expanded support for ALTER EXTERNAL LIBRARY for SQL Server 2019
- Expanded support for ALTER AVAILABILITY GROUP for SQL server 2019
- Expanded support for DROP EXTERNAL RESOURCE POOL for SQL Server 2019
- Expanded support for DROP EXTERNAL LIBRARY for SQL Server 2019
- Expanded support for ACCELERATED_DATABASE_RECOVERY in ALTER DATABASE for SQL Server 2019
- Temporary tables suggestion
- OPENJSON objects suggestion
- Properties suggestion for built-in metadata functions
- Prompting hints names for the USE HINT option
- Prompting time zones in AT TIME ZONE
- Displaying MS_Description for SQL Azure database objects
- Prompting objects in the context of DBCC SHOW_STATISTICS
- New options suggestion for the ALTER DATABASE SCOPED CONFIGURATION statement

- Code Refactoring improvements:
- Converting stored routines execution into a script
- Unwrapping dynamic SQL into parameterized queries
- Find Invalid Objects to get to know if any objects are referencing objects that have been dropped and no longer exist in the database

- Code Navigation improvements:
- Jump between CASE/END
- Jump between BEGIN TRY/END TRY
- Jump between BEGIN CATCH/END CATCH
- Extend INSERT Highlight Occurrences feature to show a popup with the column name in the values area

- Code Execution improvements:
- Run a single script against multiple databases in parallel or serial mode
- Execution Warnings to warn of UPDATE or DELETE statements without a WHERE clause as well as TRUNCATE and DROP statements
- Export of execution history to CSV file format

SQL Formatter improvements:
- New formatting profiles introduced: Collapsed; Commas before; Compact; Extended; Indented; MSDN SQL; Right aligned; Stack compact
- Quick select formatting profile from context menu of SQL file

Data Editor improvements:
- Cached Updates Mode to defer posting updates to a table to a later time
- New Web view for Data Viewer
- Unified display of DATE in the Results Grid and Data Viewer
- Ability to customize colors for Data Viewer JSON view in the dark skin
- Export data from a data grid to the CSV, XML, HTML, and JSON formats
- Settings for the export data from a data grid to the CSV
- Copy data as CSV, XML, HTML, and JSON formats to clipboard as well as to a file
- Keyboard shortcut for the Apply Changes command

Data Export/Import improvements:
- Data Export/Import to Google Sheets
- Output Settings tab is added to Data Export Wizard
- Information about the export format is added to the Data Export Wizard header
- Remember the Save an Export Project checkbox value

Schema Compare improvements:
- Redesigned Progress Window for schema comparison and synchronization
- In-place SQL Formatting option for the text compare control
- Pre/Post-scripts execution tab in Schema Synchronization Wizard
- Append Timestamp to the File Name option in Schema Synchronization Wizard
- Colors for Modified, Added, and Deleted blocks are changed in the text compare control

Data Compare improvements:
- Redesigned Progress window for data comparison and synchronization
- Exclude newly added objects option in Data Compare Wizard
- Ignore Whitespaces option in Data Compare Wizard
- Tolerance Interval option in Data Compare Wizard
- Pre/Post-scripts execution tab in Data Synchronization Wizard
- Hide empty columns options for Only in Source and Only in Target view of Data Compare document

Data Generator improvements:
- Redesigned Progress Window for data generation
- Documenter improvements<
- Auto-line-break of long headings

Other improvements:
- Generate Script As for DML Commands
- Access to SQL Designer from the context menu is added
- Search for options is introduced
- Remember the size of the column properties window
- DevExpress controls updated to v20
- New vector HiDPI skins

User-reported and internal bug fixes:
- The "Arithmetic operation resulted in an overflow." issue is SQL Profiler (T310029)
- Unexpected exception occurred when generating data via the command line(T320298)
- The freeze when describing user database in Data Generator (T319445)
- Improved generation of data previews in the data generator for tables with composite indexes (T316409)
- Bug during generation of data preview in Data Import (T308286)
- Unexpected exception occurred during data generation for tables with circular dependencies (T278700)
- Improved object search. When editing a search query, a new search occurred according to the previous query (T304247)
- Changes to the Description field in the generated documentation were not saved in Documenter (T293113)
- Unexpected exception was thrown when opening any execution plan saved in SQL Server 2012 (T294320)
- Display of controls in dark skin in the table editor (T277001)
- Mapping settings when comparing data in backups (T323655)
- Critical parsing error (T312403)
- Error with displaying data in the Data Compare grid (T319144, T297723)
- Critical error with mapping when opening the data compare document (T306175)
- Error occurred in Comparison Wizard when connecting to TFS (T308893)
- Incorrect parsing of the FUNCTION parameters (T317519)
- An option to exclude versioned tables from comparison is added (T309869)
- Error with setting connection in the Script Folder creation form (T294568)
- Initial values were missing for SEQUENCE when retrieving DDL (T307257)
- Error with defining compatibility of the columnstore indexes when working with Azure SQL (T306938)
- Error with parsing DDL script of objects containing brackets (T303303)
- Script parsing error occurred (T283445)
- Incorrect synchronization script was generated when setting IDENTITY for the NOT NULL column (T275640)
- Data display in the Data Compare document (T268482)
- Generation of CREATE and CREATE OR ALTER scripts (T267680)
- Display of equal objects (T293657)
- The Insert Semicolons menu item put semicolons in wrong places making the script invalid (T323877)
- Incorrect behavior of the split/combined layout toggle when retrieving data for tables from Database Explorer (T318219)
- Code Completion did not suggest columns for table aliases (T304419, T305484)
- When selecting the dark color scheme and applying the dark mode in the Windows settings, the text in an SQL document remained black (T309895)
- The Edit.GotoBeginEnd command was missing from shortcuts configuration table
- Possible critical error after printing an SQL document (T317747)
- The Unexpected Object Already Exists errors were popping up frequently within the database objects editor (T304855)
- The procedure script was reformatted unexpectedly when trying to modify the latest (T304521)
- The multiline string was incorrectly highlighted within an SQL document
- The toolbar customizations are lost after restarting the program (T298461)
- The modify method for the XML data type was treated incorrectly by the syntax checker (T297890, T297936)
- Possible critical error within text comparison module when comparing database schemas (T297377, T297515, T297919, T298365, T298573,T302658, T304732, T305199, T305378, T305599, T306396, T309922)
- The FOR JSON clause was not allowed in the CURSOR statement (T289629, T320446, T314673)
- It was impossible to select multiple lines at once within an SQL document (T281370)
- The syntax checker did not accept user variables within the SEND statement (T283619)
- The syntax checker did not accept the FORCESEEK hint with the brackets
- Items in the completion list were scrolled by pixels but not rows, thus it was impossible to use mouse wheel for navigation (T280133)
- The formatter failed to process queries containing column aliases defined via the 'alias = column' syntax
- The Alt + R accelerator in the Find and Replace window did not work (T270967)
- The JSON_QUERY was not recognized correctly by the syntax checker (T266900)
- Incorrect statement was highlighted with the error marker when profiling specific statements (T264205)
- The WHERE keyword was not highlighted in case the JOIN condition was incomplete (T263709)
- Improved generation of DDL script of a trigger for the Modify command in Database Explorer (T318082)
- Error with defining the server version in (T309862, T309689)
- Description of the Schema Export options is improved (T313400)
- Error occurred when updating the values of the joined tables in Data Editor (Modif298178)
- Behavior with the window focus when executing queries in SQL document is tweaked (T294116)
- Error occurred when opening the Database Diagram file in the previous version (T294212)
- The work of the Filter Editor window in Data Editor is tweaked (T276373)
- Support for the SSDT folder structure in Script Folder and Source Control (T251625)
- Issue with connecting to the cloud Git repositories (T306465)
- Error when working with a SEQUENCE with large values (T281220)
- Improved performance when displaying data with a large number of columns (T283046, T289442)
- Formatting was disabled when generating the script objects script
- Error when executing SELECT queries with the FOR JSON clause (T244543, T264914, T272571)


dbForge Studio for SQL Server Professional 5.8.127
Bug fixes:
- Problem with Generate Script As on SQL Server 2019 is fixed
- Problem with connecting to azure managed instance is fixed
- Problem with freezing on refresh Source Folder is fixed
- Problem with displaying comperison result is fixed
- Other User-reported bugs are fixed


dbForge Studio for SQL Server Professional 5.8.107
Data Compare improvements:
- Redesigned data compare control
- Redesigned data comparison report window
- Redesigned data comparison report in CSV

Schema Compare improvements:
- Object filter
- Redesigned objects text diff control
- Redesigned schema comparison report window
- Redesigned schema comparison report in HTML

User reported bug fixes:
- Problem with execution of push command is fixed
- Problem with virtual relation on database diagram is fixed
- Problem with constraint renaming is fixed
- Problem with data view in data editor is fixed
- Other user reported bugs are fixed


dbForge Studio for SQL Server Professional 5.7.99
Fixed bugs:
- Problems with data refreshing in data editor are fixed
- NRE in view editor is fixed


dbForge Studio for SQL Server Professional 5.7.98
Fixed:
- Problem with connecting to GIT using proxy is resolved
- Problems with incorrect query generation are fixed
- Problem with procedure creating in the editor is fixed
- Problems with conneting to repository are fixed
- Problems with parser error are fixed
- Problems with opening database diagram are fixed
- Problems with saving changes when modifying an object in the object editor are fixed
- Other user reported bugs are fixed


dbForge Studio for SQL Server Professional 5.7.31

Connection:
- Support for the Active Directory - Universal with MFA authentication

Schema & Data Compare:
- Comparison performance improved dramatically

User reported bug fixes:
- Problem with column order is fixed
- Problem with wrong error messages is fixed
- Problem with lost user shortcuts is fixed
- Problem with check constraints is fixed
- Problems with drag and drop several tables to diagram are fixed


dbForge Studio for SQL Server Professional 5.6.104
Bugs fixed:
- Problems with a virtual relation on a database diagram
- Problem with the connection to Azure
- Problem with mapping a foreign key on a database diagram
- Problem with shortcuts
- Problem with wrong differences after data comparing


dbForge Studio for SQL Server Professional 5.6.62
SQL Server support:
- Connectivity support for SQL Server 2019
- Lots of Azure improvements implemented

Data Generator
- Foreign Key Generator for a group of unique table columns

Source Control:
- Support for TFS 2018

User reported bug fixes:
- Synchronization issue using command line is fixed
- Problem with false different records is fixed
- Problem with view renaming is fixed
- Problem with script generating for system-versioned table is fixed
- Problem with connect to TFS is fixed
- Problem with inserting data in data editor is fixed
- Problem with editing table structure is fixed
- Problem with renaming file for data export to CSV is fixed
- Problem with documentation generation is fixed
- Problem with object duplicate is fixed
- Problems with activation are fixed
- Other user reported bugs are fixed


dbForge Studio for SQL Server Profesional 5.5.369
- Problem with popup menu in database explorer is fixed

Join our mailing list

Stay up to date with latest software releases, news, software discounts, deals and more.

Subscribe