2025.2.109 31-Oct-25
User-reported bug fixes
- Resolved an issue with displaying the tooltip for a document bookmark, where the tooltip window overlapped the document bookmark
2025.2.91 23-Oct-25
User-reported bug fixes
- Added the consideration of the Ignore keyword reduction option when comparing privileges (GRANT EXECUTE ON and GRANT EXEC ON) (#217201)
- Fixed an exception caused by empty values in the parameter input form in SQL Document
- Fixed an issue with clearing the DataViewer
2025.2.37 23-Sep-25
AI Assistant
- Introduced automatic error submission from the Error List to AI chat for detailed explanations and suggested fixes
- Added a Web Search option in the AI Assistant chat, allowing searches across Devart documentation, website, and blog
Connectivity
- Enhanced authentication capabilities for SQL Server when using Entra ID
- Added support for Microsoft Fabric
Improvements
- Improved encryption capabilities
- Added tooltips to the SQL document tab, showing connection and database names, document owner, full file path, and server version
- Introduced the ability to customize the position where new document tabs open
- Added Alt+Up and Alt+Down shortcuts to move selected lines up or down in the SQL document
- Added the Ctrl+Shift+A shortcut to select the entire statement in the SQL document, including all related keywords, operators, and values
- Added full support for the OPENROWSET function in Syntax Check
User-reported bug fixes
- Fixed the generation of synchronization scripts for indexes requiring the QUOTED_IDENTIFIER option to be enabled(#194733)
- Resolved an exception that occurred when displaying differences(#174617)
2025.1.230 21-Aug-25
User-reported bug fixes
- Fixed an issue that caused the suggestion list to close when typing numbers
2025.1.186 21-Jul-25
User-reported bug fixes
- Fixed an error that caused a change of a primary key to a unique key after schema synchronization (#206783)
- Added support for parsing the IGNORE NULLS and RESPECT NULLS options in the LAG and LEAD functions (#204058)
- Removed opening the connection on the main thread when opening the parameter input form
- Fixed an issue with the automatic display of Data Editor: when the Activate Data Editor after query execution option is enabled, Data Editor now opens automatically after a query runs, even if no data is returned
- Fixed an issue with long file names
2025.1.134 23-Jun-25
User-reported bug fixes
- Fixed column alias suggestions in INSERT ... SELECT expressions
2025.1.124 16-Jun-25
AI Assistant is added
- Context-aware query generation
- Conversion of natural language to SQL
- Query optimization
- SQL explanations
- SQL troubleshooting
- Error analysis and recommendations
- AI chat
- Integration with the dbForge tools
Connectivity
- Added support for dedicated and serverless SQL pools in Azure Synapse Analytics
Improvements
- Updated color palettes for the Light and Dark skins
- Refined font rendering and the coloring of syntax errors
- Added Brief View to the Start Page to switch between displaying full paths to recent files and a more compact list
- Supported integration with SSMS 21.0
User-reported bug fixes
- Added error messages for various failure scenarios (#166902)
- Fixed the "Object reference not set to an instance of an object" error (#100179)
7.1.63 14-May-25
Improvements
- Supported integration with SSMS 21.0 Preview 7
User-reported bug fixes
- Several minor bugs are fixed
7.1.45 18-Apr-25
Improvements
- Supported integration with SSMS 21.0 Preview 6
User-reported bug fixes
- Fixed an error with reading the database list when connecting to the server
7.1.37 07-Apr-25
Improvements
- Added support for SQL Server 2025
- Supported integration with SSMS 21.0 Preview 5
- Supported compatibility with Windows Server 2025
User-reported bug fixes
- Several minor bugs are fixed
7.1.37 07-Apr-25
Improvements
- Added support for SQL Server 2025
- Supported integration with SSMS 21.0 Preview 5
- Supported compatibility with Windows Server 2025
User-reported bug fixes
- Several minor bugs are fixed
7.0.362 07-Mar-25
User-reported bug fixes
- Fixed duplicate creation of FULLTEXT indexes when generating table creation scripts (#179480)
- Fixed an issue in Schema Compare where SPATIAL index coordinate values were incorrectly processed, leading to data corruption (#177894)
7.0.249 14-Nov-24
User-reported bug fixes
- Fixed an issue that occurred when processing queries containing JOIN clauses
7.0.210 18-Oct-24
User-reported bug fixes
- Several minor bugs are fixed
7.0.158 05-Sep-24
Improvements
- Added the Show Ignored Differences option for schema comparison
- Added a new shortcut ALT+(arrow down) that allows going to each subsequent difference in a schema comparison document
- Added support for the ADD SENSITIVITY CLASSIFICATION command
- Added a new Issues page in Schema and Data Synchronization Wizards
- Added a new index option STATISTICS_INCREMENTAL
- Added a new group of options called Sequences, comprising Ignore START WITH in sequences and Ignore MIN VALUE in sequences
- Added new comparison options: Ignore MIN VALUE, Ignore START WITH, Ignore CYCLE, Ignore INCREMENT BY, and Ignore CACHE
Connectivity
- Renamed the Azure Active Directory authentication type to Microsoft Entra ID
- Added support for ApsaraDB
SQL Query History
- Redesigned the SQL Query history toolbar with an updated date range selection and a new Clear button
- Added the ability to save user-defined column layouts in Query History
Documents
- Added options to rearrange tab opening order
- Added new options in Tabs and Windows: Tab layout, Show tabs in multiple rows, and Close tabs with middle-click
- Added a new shortcut CTRL+SHIFT+/ that comments selected pieces of code
Data Editor
- Added an option to set a cell value to a unique identifier from the shortcut menu
User-reported bug fixes
- Fixed the object comparison error that occurred when the object body contained CONTAINS and FREETEXT functions (#156614)
- Fixed the exit code returned when synchronizing identical schemas from the Command Line (#139863)
- Resolved an issue with searching for dependencies in historical tables (#142753, #144751)
- Resolved an issue where quotes in the Command Line string led to errors (#137931)
- Corrected the handling of column collation when comparing database schemas (#134365)
- Fixed the schema synchronization error that occurred when comparing script folders (#148643, #156199)
- Fixed the script generation for SYSTEM-VERSIONING tables (#126009)
- Fixed the script generation for Extended Property (#139082)
- Enhanced DDL generation for FILETABLE constraints (T323671)
5.5.2 12-Apr-24
Improvement
- Integration support for SSMS 20.x
User-reported bug fixes
- Several user reported minor bugs are fixed
5.4.8 28-Dec-23
User-reported and internal bug fixes
- Resolved an issue related to determining parameter dependencies on user-defined data types that occurred when synchronizing procedures and functions (#125015)
- Fixed an issue with the generation of a script for synchronizing dependent views (#130309)
- Removed the unnecessary REBUILD PARTITIONS operation during the synchronization of clustered indexes (#124571)
5.4.5 12-Jul-23
Performance improvements
- Optimized the process of describing scripts folders
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
User-reported and internal bug fixes
- Fixed an error in the generated synchronization script for SQL Server 2014 and earlier versions (#118542)
- Fixed an issue with comparing schemas that contain memory-optimized tables (#91727)
5.3.38 12-May-23
User-reported and internal bug fixes
- Fixed the synchronization of indexes (#117448)
- Fixed an error in the Schema Compare Properties wizard (#109596, #110572)
- Fixed the behavior of the Ignore History Table option (#105263)
5.3.29 30-Dec-22
New features and improvements
- Support for macOS & Linux via CrossOver
- SSMS v19 Preview 4 integration is added
- Added the ability to set the object filter file from the CLI (#92620)
- Added the behavior to open the Objects Filter window when creating a Schema Compare document (#95034)
- Improved the metadata reading behavior - the VIEW DATABASE STATE privilege is no longer required (p135909, T308355, #71423, #98539, #103313)
User-reported and internal bug fixes
- Fixed the permissions issues that occurred when comparing database objects(#94100)
- Fixed an issue with creating a comparison report in Schema Compare (#99243)
- Fixed an object syntax error in Scripts Folder (#100298)
- Fixed an issue with the output of the object synchronization script to internal editor (#92445)
- Fixed a bug that occurred when synchronizing objects (#95971)
- Fixed an issue with the incorrect completion (#96627)
- Fixed an issue with the inaccurate comparison of the Scripts Folder objects (#92621)
5.3.19 12-Sep-22
New features and improvements
- Connectivity support for SQL Server 2022 CTP 2.1
User-reported and internal bug fixes
- Fixed incorrect script generation for table-based types in specific environments (#88584)
5.3.11 20-Jul-22
New features and improvements
- SSMS v19 Preview 2 integration is added
User-reported and internal bug fixes
- Fixed an error that occurred during the installation of the SQL Tools products (#90677)
- Fixed an error that occurred when displaying database schema synchronization script
- Fixed incorrect comparison of extended properties (#87606)
- Fixed the behavior of shortcuts in SQL Editor
5.3.5 17-Jun-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 (#74074)
- Improved the behavior of wildcard-aided search in a Schema Compare document (#71799)
User-reported and internal bug fixes
- Fixed false syntax errors (#71494)
- Fixed an index synchronization issue (#79101)
- Fixed an issue that occurred when launching schema comparison (T324200)
- Fixed a script formatting issue (#76716, #88775)
5.2.8 21-Dec-21
New features and improvements
- Improved the behavior of data sorting in Data Editor
- Added the ability to resize the search text field
- Added a warning when trying to save read-only files with the applied changes
- Improved the display of the database server name on the Start Page
User-reported and internal bug fixes
- Fixed false positives of Syntax Check
- Fixed a syntax error in the STRING_AGG construction
- Fixed an issue with synchronizing objects with data recovery when comparing schemas
- Fixed an issue that occurred when comparing a database with the Script Folder (#65701, #66830)
- Fixed an issue with comparing user-defined object schemas that differ only in spaces
5.1.83 10-Sep-21
New features and improvements
- Ability to simultaneously connect with different ApplicationIDs to Azure SQL Server
User-reported bug fixes
- Errors in the synchronization script in Schema Compare
- Error with synchronizing Extended Properties for views (#61745)
- Error with canceling the operation in Data Editor
- Improved behavior with the active Paste As New Records command in Data Editor
- 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
- Error when completing the procedure with parameters in Data Editor
- 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
- Processing of the Ctrl+A, Ctrl+C shortcuts in Data Viewer
5.1.71 16-Jun-21
New features and 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
- Formatting profiles added
- Options search
- Ignore History Tables option
- Integration into MS SSMS v18.9
User-reported and internal bug fixes
- Schema Compare add-in failed when connecting to Reporting Services via SSMS (T323577)
- Error with synchronizing indexes (T324729)
- Work with nullable types was fixed (T324729)
- Error with generation of the command-line arguments (T311865, T307784)
- Error with the Ignore case in objects names option (T321992)
- Error with the function parsing (T317519)
- Error with comparing indexes (T317209)
- Critical error with outputting DDL of the objects in the Comparison document (T304038, #55356)
- Error with closing the Schema/Data Compare window (T307231)
- Error with generation of the command-line arguments (T311865, T307784)
- Error when working with columnstore index on Azure (T306938)
- Error with running the application (T288980, T293290)
- Error with metadata reading (T297124, T297125)
- Work with temporary folders was improved
- Error with processing the comparison results (T298426)
- Error with running Schema Compare add-in (T288801)
- Value quoting mechanism was improved (T296626)
- Filter work was fixed (T294347, T297706, T303524, T303973, T305908)
- Issue with updating the application (T262581)
- Sync script generation error when processing FOREIGN KEY (T294023)
- Issue with incorrect error processing (T289736)
5.0.57 08-Oct-19
User reported bug fixes
- Problem with filter criteria is fixed (T292861)
- Problem with assembly loading is fixed (T292706)
- Problems with false table diffences are fixed (T277907, T277941)
5.0.34 02-Sep-19
New features and improvements
- Object filter
- Redesigned objects text diff control
- Redesigned schema comparison report window
- Redesigned schema comparison report in HTML
- Redesigned schema comparison ssms add-in window
User reported bug fixes
- Problem with constraint renaming is fixed (T286474)
4.6.60 27-Jun-19
User reported bug fixes
- Problem with saving options is fixed (T277922)
4.6.44 10-May-19
User reported bug fixes
- Several user reported bugs are fixed
4.6.24 20-Feb-19
New features and improvements
- Support for the Active Directory - Universal with MFA authentication
- Comparison performance improved dramatically
User reported bug fixes
- Several user reported bugs are fixed
4.5.90 21-Dec-18
New features and improvements
- Connectivity support for SQL Server 2019
- Product now integrates into SSMS v18
- Lots of Azure improvements implemented
User reported bug fixes
- Cyclic dependencies issue is fixed (T268571)
- Problem with assembly loading is fixed (T270855)
- Problem with syntax which depends on compatibility level is fixed (T253682)
- Missing command-line interface in non activated product is fixed (T222242)
- Other user reported bugs are fixed
4.4.92 19-Jul-18
User reported bug fixes
- Problems with wrong determined encrypted Azure objects are fixed (T243967,T251547)
- Issues connected with integration into MSSMS are fixed (T243967,T251547)
- Null Reference Exception is fixed (T259516)
- Problem in command line is fixed (T248206)
4.4.66 25-Sep-17
- Issue with backup file size limitation is fixed (T232041, T232416)
4.4.63 15-Sep-17
- User-reported issue with non-working button in Generate Script Wizard is fixed (T102065)
4.4.61 30-Aug-17
- SQL Server 2016 Service Pack 1 (SP1) new syntax support
- SQL Server 2017 new syntax support
- The latest SQL Server Management Studio v17.2 integration support
- Azure SQL Data Warehouse support
- Support for external objects
- Support for the MASKED columns
- Extended support for Azure v.12
- Support for the SECURITY POLICY objects
- Support for the column encryption keys
- Support for the column master keys
- Extended support for comparison of the SQL Server 2014-2016 backup files
- New database creation through the Schema Comparison wizard
- Redesigned logging in the command line
- Opening the Schema Comparison wizard instead of the comparison autorun when opening the .scomp files
- Command-Line Master which greatly simplifies creation of the command line execution files
4.3.38 18-Apr-17
New features and improvements
- Comparison and synchronization of system-visioned tables
- New comparison and synchronization options
- PowerShell supported
- Trial product activation implemented
- Extended comparison reports functionality
- Command-line interface for the scripts folder comparison
- Comparison and synchronization of memory-optimized tables
- Support for SECURITY POLICY objects
- Compliance with the Federal Information Processing Standard (FIPS)
- Connection to Microsoft Azure SQL Database by using identities in Azure Active Directory
- Specific exit codes added
- Greatly improved visual style of the application with high DPI support
4.2.35 16-Sep-16
- SQL Server 2016 support
- Product now integrates into SSMS 2016
- Many new comparision and synchronization options added
- Enchanced backup support
- Sequences support greatly improved
- Improved security during synchronization process
- Valid support of "WITH CHECK" and "WITH NOCHECK" constraints
- Use reported bugs fixed (T186644, T168482, T126588)
4.1.37 02-Mar-16
- Issue with SET LANGUAGE statement is fixed (T162623)
4.1.32 22-Dec-15
- Schema comparison performance increased
- TFS 2005, TFS 2008, TFS 2013 and TFS 2015 are now supported by comparision with version control systems
- Other minor bug fixes and improvements
4.1.31 30-Nov-15
Redesigned Comparison Document UI
SSMS Integration Support
- SQL Server Management Studio integration enables starting the schema comparison directly from SSMS
Database script folder creation and comparison
Comparison with database script folder in version control
Support for all popular version control systems:
- Subversion (SVN)
- Team Foundation Server (including TFS Cloud)
- Git (including GitHub)
- Perforce (P4)
- Mercurial (Hg)
- SourceGear Vault
Minor bug fixes and improvements
4.0.29 16-Dec-14
-
Issue with changing a location of backup folder (T119187)
-
Error when creating a snapshot is fixed (T117992)
-
Other user reported bug fixes and minor improvements
4.0.26 13-Nov-14
SQL Editing and Execution
-
Command-line interface for SQL formatting
-
Query execution pane
-
Easy way to hide results
-
Encoding switch in the /execute command-line operation
-
Updated Find&Replace feature in documents and files
Schema Comparison
-
Custom mapping for tables
-
Updated Synchronization wizard
-
Zooming font size in Text Comparer
Generate Script
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
User Interface
-
Support of multiple monitors
-
New skins
-
Updated Start Page
Other Features and Improvements
-
Create Schema Snapshot wizard window works in modeless mode.
-
Improved application performance
-
Windows 10 support
3.8.252 25-Jun-14
SQL Server 2014 is supported
Code completion
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
Generate Schema Script
- Saving options settings for the future use
- Support of command line interface
- Automatic archiving of schema export scripts
- Writing report about the process into a log file
- Automatic removal of old files based on date or quantity
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
- SQL document zooming by holding the CTRL key and rotating the mouse wheel is added
- Restoring documents from the last session is possible now
3.0.196 21-Nov-13
-
NullReferenceException on editing data in the Data Editor is fixed (T89961)
-
An option that allows to synchronize objects with square parenthesis is added (T89073)
-
OutOfMemoryException on searching data in Data Editor is fixed (T88817)
-
TypeLoadException while describing database objects is fixed (T88526, T88531)
-
Wrong behaviour on comparing parameters in CLR function is fixed (R27916)
-
Problem with the installation of the product is fixed (R28557)
-
The navigation from the Error List to the specific error in a script is fixed (T88471)
3.0.192 15-Oct-13
-
An exception while comparing schemas (on condition that before schema comparison
the data comparison process was implemented) is fixed (T84523, T87411)
-
InvalidOperationException while executing queries on SQL Azure is fixed (T84559)
-
A problem related to the focus, while executing several statements is fixed (T84632)
-
A problem with highlighting of the IIF function is fixed (T84653)
-
TypeLoadException on comparing ASSEMBLY is fixed (T88526, T88531)
-
A problem related to the searching and replacing tabs and whitespaces is fixed (R28253)
3.0.186 19-Sep-13
-
NullReferenceException on adding rows in Data Editor is fixed (T84511)
-
NullReferenceException on retrieving data from the tables containing a BIGINT field
is fixed (T74907, T75124, T75355, T75356, T75357, T75440, T83022)
-
NullReferenceException on detecting a cyclic dependency is fixed (T66662)
-
Problem with saving a file's encoding is fixed (T83954)
-
NullReferenceException on attempting to perform synchronization into a snapshot
via the command line interface is fixed (T83705)
-
NullReferenceException on executing a query is fixed (T83825, T84358, T84425, T84827)
-
Problem with removing a record in Data Editor is fixed (R26432)
3.0.181 23-Aug-13
-
Error on opening schema synchronization script in external editor is fixed (R24795)
-
Problem in data editor with not assigning default values is fixed (T70859, R10060)
-
Problem with clearing memory on selecting data from table is fixed (T71228)
-
Problem with committing changes in version control system is fixed (T75228)
-
Problem with running the application on .NET Framework 4.5 is fixed (T75603)
3.0.170 12-Jul-13
-
Problem with connecting to TFS on visualstudio.com is fixed (R24383)
-
The information is added to the report, while detecting the circular reference (T72560)
-
NullReferenceException on invoking Help in the Command Line is fixed (R23315)
-
"Statistics norecompute" options translation is fixed in Russian Edition (T69944)
-
TFS 2010 connection failure is fixed (T73129)
-
Error on changing connection in SQL document is fixed (R23354)
-
Work with memory is improved while redirecting data to the Output window (R22051)
-
The problem with inaccurate title of filter in schema comparison document is fixed
(T68928)
-
The problem with applying a filter in Data Editor is fixed (T70060)
-
Incorrect behaviour with identity columns on adding data in Data Editor is fixed
(T69095)
3.0.155 15-Apr-13
-
The problem with the temporary table on schema synchronizing is fixed (T66662, T69085,
T69895, T69951)
-
The problem with procedure's dependencies determination on schema comparison is
fixed (T67595)
-
InvalidOperationException on executing a script is fixed (T69522)
-
ArgumentException on saving command line arguments in the Schema Comparison wizard
is fixed (R20898)
3.0.152 09-Apr-13
-
The problem with saving the Splitting options is fixed (T60064)
-
InvalidOperationException on executing a script is fixed (R17828)
-
The problem with changing options for code editor is fixed (T65707)
-
Incorrect behaviour on synchronizing a function in Schema Comparer is fixed (T66941)
-
NullReferenceException on trying to find a search pattern in a document is fixed
(R19287)
-
InvalidOperationException on editing data in Data Editor is fixed (T67547)
-
The problem with connection to TFS 11 is fixed (T61250)
-
The problem with punctuation's visibility in code editor with black background being
set is fixed (T65696)
-
NullReferenceException on executing a script is fixed (T65230)
-
Syntax error on executing the current statement using the Execute Current Statement
command is fixed (T68993)
-
Wrong displaying of NULL values in comparison reports is fixed (T68678)
-
NullReferenceException on choosing invalid file as a snapshot file is fixed (R18487)
-
Syntax error on executing a script with @@ variables is fixed (T62139)
-
The error on choosing a snapshot in the Schema Comparison wizard is fixed (T66590,
T67465)
3.0.133 16-Jan-13
-
NullReferenceException on comparing schemas of SQL Azure is fixed (T65593)
-
Error on default schema mapping is fixed (R17170)
3.0.132 15-Jan-13
-
ArgumentException on clicking Save As My Defaults in the synchronization wizard
is fixed (T64077)
-
ArgumentException on describing view columns is fixed (T38076)
-
SqlTypeException on executing stored procedure with data entered out of the permissible
range (T64333)
-
The error on working with Team Foundation Server is fixed (T61250)
-
Error on generating script for indexes is fixed (R13720)
-
Error on setting alias name in upper case is fixed (T15105)
-
Incorrect tables comparison when the 'Ignore Unique Key' option is on is fixed (R15118)
-
NullReferenceException on comparing schemas of backup copies is fixed (R15144)
-
Error on generation of incorrect schema synchronization script when an account with
restricted rights is used is fixed (T63740)
-
Error 8623 on schema comparison is fixed (T39594)
3.0.110 08-Nov-12
-
SQL Server 2012 LocalDB is now supported (R14621)
-
Schema comparison performance is improved (T39594)
-
Synchronization of procedure with dependencies is fixed (R11464)
-
ArgumentException on opening a file through the command line is fixed (T45824)
-
ArgumentException on synchronizing databases in Schema Compare is fixed (T50581,
T59826, T60281)
-
Application's hanging when comparing snapshots is fixed (T51789)
-
TargetInvocationException in the Schema Comparison wizard is fixed (R13555)
-
Incorrect creating of foreign keys is fixed (T59065)
-
Incorrect trial on Windows 8 is fixed (T59119, T59496, T59563, T59698, T59827, T59847)
-
ArgumentNullException on finding the next occurrence in text is fixed (R13847)
-
Old warnings that occurred during comparison are removed now (T59484)
-
NullReferenceException on searching a text in SQL document is fixed (T59700)
-
NullReferenceException on applying the filter and removing it after refresh in the
Schema Comparison document are fixed (T59720)
-
NullReferenceException on opening recent Schema Comparison document is fixed (T59751)
-
TargetInvocationException on getting schemas with insufficient privileges in the
Schema Comparison wizard is fixed
-
Non-working command line on operating systems with only .NET Framework 4 installed
is fixed (T61027)
-
ComponentNotRegisteredException on comparing data with a backup as a source or target
is fixed (T61163)
-
Incorrect behaviour with specifying file groups in synchronization scripts is fixed
(T60183)
-
Use ALTER will be used instead of DROP/CREATE for stored procedure in all editing
features (R13499)
-
Losing privileges on source objects after editing or synchronizing databases in
Schema Compare is fixed (T59672)
-
Switch "/schemacompare" was added in the command line (T59533, T61107)
-
InvalidOperationException on closing a connection with invalid transaction is fixed
(R14818)
3.0.93 18-Sep-12
-
Incorrect resolving dependencies during synchronization of procedures is fixed (R11464)
-
ArgumentException on opening a document if fixed (T45824)
-
InvalidOperationException on executing a query is fixed (T42960, T41492)
-
Application suspension on comparing snapshots is fixed (T51789)
-
Incorrect behaviour of setting My Default Options is fixed (R9707)
-
Object Filter in the comparison wizard is fixed (R9973)
-
Incorrect behaviour on swapping source and target is fixed (R12697)
-
Several improvements with users on Azure are made (R12639)
-
Duplicate creation of extended properties for functions is fixed (R11761)
3.0.61 19-Jul-12
-
Error during synchronization is fixed (T41418)
-
Error "Empty path name is not legal" is fixed (T42223)
-
Problem with table inconsistency during schema comparison is fixed (T40709)
-
Error on a query for describing database is fixed (T40967, T42175, T42258)
-
Error "Object cannot be cast from DBNull to other types" is fixed (T42176, T42178,
T39967)
3.0.57 19-Jun-12
-
InvalidCastException on describing a database is fixed (T40967)
3.0.54 21-May-12
-
Error report on the document or application closing is fixed (T38835)
-
Problem with Ignore Case option is fixed (R8948)
-
Problem with object dependency is fixed (R8625)
-
Problem with function describing for SQL Server 2000 is fixed (R8983)
3.0.48 07-Mar-12
-
OutOfMemory exception in triggers comparison is fixed (T37588)
-
Error in process of describing database objects is fixed (T36833)
3.0.44 28-Feb-12
-
The problem with the trial version installation is fixed (T37284, T37332)
3.0.43 22-Feb-12
New SQL Server versions support
-
SQL Server 2012 is supported (T33916, T34810, T35044)
-
Support of SEQUENCE, SEARCH PROPERTY LIST, FILETABLE objects is added
-
Support of new users' properties is added
-
New databases properties are supported
-
Support of native SQL Server backup
-
Decryption of encrypted objects is supported
-
SQL Azure is supported
GUI improvements
-
Ability to search Action Plan is added
-
Search in comparison options and comparison document is improved - on entering values
into the search field, search results are highlighted
-
Description field for options in the comparison and synchronization wizards is added
-
Product start page is improved
-
Ability to solve problems that may occur during synchronization manually is added
-
Ability to order columns and constraints alphabetically on viewing DDL is added
New options
-
Option to synchronize assemblies through files on disks is added
-
Connection timeout property is added to the connection settings (T32569)
-
'Add constraints and keys to tables using WITH NOCHECK' synchronization option is
added (T31903)
User Reported Bugs
-
Ability to generate snapshots from the command line is added (T29483)
-
Error on reading XML is fixed (T31388)
-
Null reference exception on closing *.scomp file during comparison is fixed (T29459)
-
Null reference exception on viewing tables in Update Script is fixed (T14538)
-
Problems on moving Sharepoint database are fixed (T14969)
-
Out Of Memory exception on performing Refresh is fixed (T36392)
-
Error with extended properties on clear 2.0 Framework is fixed (T22010)
-
Error on large database is fixed (T18243)
-
Error on synchronizing directly into a database if connection is unstable is fixed
(T21500)
2.00.155 29-Jul-11
-
Fixed bug related to foreign key cycle dependencies is resolved
-
Fixed bug related to using ignore case option
2.00.150 28-Mar-11
-
Fixed bug related to update nullable values (S13166)
2.00.149 17-Mar-11
-
Fixed bug related to duplicate foreign keys (T26816)
-
Fixed bug related to deadlock on connecting to the SVN (S13126)
2.00.148 30-Dec-10
-
Fixed bug related to custom schema mapping (T24734)
-
Fixed bug related to saving the password for SVN (T10675)
-
Fixed bug related to size limits for user defined aggregate (T24734)
2.00.145 15-Dec-10
-
CustomAttributeFormatException when reading assembly attributes was fixed (T24734)
2.00.143 11-Oct-10
-
"Failed to sort objects" problem while comparing assemblies fixed
-
Another "unbreakable cycle" problem fixed (T23404)
2.00.131 07-Jul-10
-
Fixed bug of restoring spatial and xml indexes
-
Fixed bug related to describing of schemas
-
Fixed bug related to exceptions on a script generating
-
Fixed bug related to reading database properties from snapshot
2.00.129 05-Jul-10
-
Fixed bug of restoring constraints, indexes and statistics related to renamed columns
(T17184)
-
Fixed bug of setting NOT NULL constraint for VARCHAR(MAX) columns (T16979)
-
Fixed bug related to direct synchronization into a database on case-sensitive servers
(T16960)
-
Fixed displaying extended properties of unique key and primary keys during ignoring
these keys
-
Fixed bug related to DML trigger dependency on a column
2.00.127 3-Jun-10
-
The comparison option "Synchronize database properties" is turned on by default
-
Fixed bug related to simultaneous comparison and snapshot creation (T15751)
-
Fixed bug related to NRE while synchronization script generation (CR52378)
2.00.120 19-Apr-10
-
Fixed bug related to synchronizing of views with cycled dependences (T12264)
2.00.113 05-Feb-10
-
Fixed bug related to describing of extended properties and partition functions (T10322)
2.00.111 22-Jan-10
-
Fixed bug related to describing of extended properties (T10161, T10179)
-
Fixed bug related to memory releasing before refreshing comparison results (T10209)
-
Few bugs related to DML triggers synchronization were fixed
2.00.107 15-Jan-10
-
Support of native SQL Server backups
-
Version control system integration for database change tracking
-
Database comparison and synchronization via command line
-
Generating comparison and synchronization reports
-
Expanded list of comparison options
-
Start page with quick access to previously saved comparison projects and high-usage
tools
-
Text Comparer toolbar
-
Character-oriented comparison
-
Synchronization of database properties
-
Synchronization of change tracking for tables and databases
1.50.336 17-Sep-09
-
Table data verification after synchronization
-
Comparison and synchronization of all database objects
-
Capability to create schema snapshots and compare them with each other or with a
database
-
Multiple bug fixes to improve the program stability and performance
1.10.265 14-Jul-09
-
Fixed bug with synchronization of extended properties of DateTimeOffset type (T3731,
T5978)
-
Fixed critical bugs during database comparison (T4050, T6238)
-
Many other bug-fixes and improvements
1.10.250 05-Jun-09
-
Faster comparison of database objects
-
Synchronization of object permissions
-
RULE and DEFAULT support
-
Improved table synchronization
1.00.235 05-Jun-09
-
Fixed bug with table columns describe (41024)
-
Fixed bug with foreign key describe (41025)
1.00.233 05-May-09
-
Resolving dependencies for DML triggers, computed columns, default and check constraints
added (40388)
-
SQL expressions and source objects comparison improved
-
Cyclical references resolving improved
-
Many other bug-fixes and improvements
1.00.222 13-Apr-09
-
System.ArgumentOutOfRangeException is removed when comparing stored procedures (40123)
1.00.202 25-Mar-09
First release of dbForge Schema Compare for SQL Server
© 2025 Devart. All rights reserved.