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.