dbForge Schema Compare for SQL Server Revision History

2026.1.77 25-Jun-2026

User-reported bug fixes

  • Fixed clipboard data corruption when copying data from Text Comparer(#233417)
  • Fixed the Object Filter functionality in schema comparison console mode(#242721)
  • Fixed a false-positive syntax error triggered by Transact-SQL expressions referencing objects named window
  • Added the MFA Application ID to the settings export
  • Fixed an issue with filtering in the command-line interface
  • Resolved clipboard data corruption when copying HTML data with duplicate column names
  • Fixed an issue with errors in Source Control

2026.1.39 15-May-2026

Improvements

  • Added support for SSMS 22.6

2026.1.31 11-May-2026

Schema Compare

  • Added the Discard Changes option to the Objects Filter toolbar

AI Assistant

  • Improved AI Assistant by adding support for database index metadata

Text Editor

  • Added the Enclose identifiers in quotes feature to the SQL Editor
  • Added indexed column icons in Quick Info

Improvements

  • Added the ability to pin document tabs
  • Added the ability to restore document tab order

User-reported bug fixes

  • Fixed the behavior of the "Ignore column order in indexes" option; it now correctly applies to the INCLUDE column list (#232427, #232433)
  • Improved view dependency resolution (#202918)
  • Fixed an issue where the document database was lost for recovered documents
  • Fixed the behavior of the "SQL Look In" option in the Find and Replace control
  • Fixed MFA authentication when connecting under different user accounts
  • Fixed an error in the data editor that occurred when executing a modified query before the previous query had finished fetching data
  • Updated the installation wizard to not display the "Successful Install" page during dbForge product updates
  • Fixed the auto-hint behavior for server selection on the Connection form
  • Improved saving of window layouts and restoration of window positions after restarting the Studio

2025.3.149 25-Mar-26

User-reported bug fixes

  • Fixed the Look In drop-down list in the Find and Replace window

2025.3.107 12-Feb-26

User-reported bug fixes

  • Fixed an issue that occurred when comparing columns with the TIMESTAMP and ROWVERSION types; their equivalence in SQL Server is now taken into account (#229350)

2025.3.93 29-Jan-26

User-reported bug fixes

  • Fixed queries for retrieving foreign keys
  • Added support for the FORCESEEK table hint in FROM clauses for the Text Editor

2025.3.61 24-Dec-25

Text Editor Improvements

  • Added scroll bar annotations
  • Added an option to automatically surround selections
  • Added camelCase formatting for identifiers

Other Improvements

  • Added support for SSMS 22

User-reported bug fixes

  • Fixed an issue with accessing AppData in non-interactive mode (#221944)
  • Fixed an issue where the application attempted to show a message box in console mode (#221944)
  • Fixed an issue where including a system-versioned table in the comparison caused the synchronization script to include extra dependencies
  • Stopped disabling table versioning during schema synchronization for operations that don't require it
  • Fixed an issue where floating-point values lost precision when copied to Excel

2025.2.138 20-Nov-25

User-reported bug fixes

  • Resolved an issue with data recovery during table rebuilds in schema comparison. Values are no longer inserted into computed columns (#220980)

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

SSMS Integration Support

  • SQL Server Management Studio integration enables starting the schema comparison directly from SSMS

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

  • 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

  • SQL Azure support

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

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.