What's new in dbForge Schema Compare for SQL Server 5.5.2
Apr 12, 2024
- Improvement:
- Integration support for SSMS 20.x
- User-reported bug fixes:
- Several user reported minor bugs are fixed
New in dbForge Schema Compare for SQL Server 5.4.8 (Dec 28, 2023)
- Resolved an issue related to determining parameter dependencies on user-defined data types that occurred when synchronizing procedures and functions
- Fixed an issue with the generation of a script for synchronizing dependent views
- Removed the unnecessary REBUILD PARTITIONS operation during the synchronization of clustered indexes
New in dbForge Schema Compare for SQL Server 5.4.5 (Jul 12, 2023)
- 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 (D118542)
- Fixed an issue with comparing schemas that contain memory-optimized tables (D91727)
New in dbForge Schema Compare for SQL Server 5.3.38 (May 12, 2023)
- Fixed the synchronization of indexes
- Fixed an error in the Schema Compare Properties wizard
- Fixed the behavior of the Ignore History Table option
New in dbForge Schema Compare for SQL Server 5.3.19 (Sep 12, 2022)
- 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 (D88584)
New in dbForge Schema Compare for SQL Server 5.3.11 (Jul 20, 2022)
- 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 (D90677)
- Fixed an error that occurred when displaying database schema synchronization script
- Fixed incorrect comparison of extended properties (D87606)
- Fixed the behavior of shortcuts in SQL Editor
New in dbForge Schema Compare for SQL Server 5.3.5 (Jun 20, 2022)
- 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 (D74074)
- Improved the behavior of wildcard-aided search in a Schema Compare document (D71799)
- User-reported and internal bug fixes:
- Fixed false syntax errors (D71494)
- Fixed an index synchronization issue (D79101)
- Fixed an issue that occurred when launching schema comparison (T324200)
- Fixed a script formatting issue (D76716, D88775)
New in dbForge Schema Compare for SQL Server 5.2.8 (Dec 21, 2021)
- 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 (Z65701, Z66830)
- Fixed an issue with comparing user-defined object schemas that differ only in spaces
New in dbForge Schema Compare for SQL Server 5.1.71 (Jun 17, 2021)
- 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
New in dbForge Schema Compare for SQL Server 5.0.57 (Oct 10, 2019)
- 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)
New in dbForge Schema Compare for SQL Server 5.7.22 (Aug 1, 2019)
- User reported bug fixes:
- Problem with saving options is fixed (T277922)
New in dbForge Schema Compare for SQL Server 4.6.60 (Jul 1, 2019)
- User reported bug fixes:
- Problem with saving options is fixed (T277922)
New in dbForge Schema Compare for SQL Server 4.6.44 (May 10, 2019)
- Several user reported bugs are fixed
New in dbForge Schema Compare for SQL Server 4.6.24 (Feb 20, 2019)
- 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
New in dbForge Schema Compare for SQL Server 4.5.90 (Dec 24, 2018)
- 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:
- Сyclic 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
New in dbForge Schema Compare for SQL Server 4.4.92 (Jul 20, 2018)
- 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)
New in dbForge Schema Compare for SQL Server 4.4.66 (Sep 25, 2017)
- Issue with backup file size limitation is fixed (T232041, T232416)
New in dbForge Schema Compare for SQL Server 4.4.63 (Sep 16, 2017)
- User-reported issue with non-working button in Generate Script Wizard is fixed (T102065)
New in dbForge Schema Compare for SQL Server 4.4.61 (Aug 31, 2017)
- 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
- Static Data comparison in Script Folder
- 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
New in dbForge Schema Compare for SQL Server 4.3.55 (Jun 16, 2017)
- Issue with command-line functionality in trial version is fixed
- Known product activation issues are fixed
New in dbForge Schema Compare for SQL Server 4.3.49 (Apr 21, 2017)
- Comparision and synchronization of system-visioned tables
- New comparision 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
New in dbForge Schema Compare for SQL Server 4.2.35 (Oct 19, 2016)
- 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)
New in dbForge Schema Compare for SQL Server 4.1.37 (Oct 19, 2016)
- Issue with SET LANGUAGE statement is fixed (T162623)
New in dbForge Schema Compare for SQL Server 4.1.32 (Oct 19, 2016)
- 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
New in dbForge Schema Compare for SQL Server 4.1.31 (Dec 16, 2015)
- 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
New in dbForge Schema Compare for SQL Server 4.0.32 (Dec 17, 2014)
- 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
New in dbForge Schema Compare for SQL Server 4.0.27 (Nov 14, 2014)
- 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
New in dbForge Schema Compare for SQL Server 3.8.252 (Jun 26, 2014)
- 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
- utomatic 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
New in dbForge Schema Compare for SQL Server 3.0.196 (Nov 22, 2013)
- NullReferenceException on editing data in the Data Editor is fixed
- An option that allows to synchronize objects with square parenthesis is added
- OutOfMemoryException on searching data in Data Editor is fixed
- TypeLoadException while describing database objects is fixed
- Wrong behaviour on comparing parameters in CLR function is fixed
- Problem with the installation of the product is fixed
- The navigation from the Error List to the specific error in a script is fixed
New in dbForge Schema Compare for SQL Server 3.0.192 (Oct 16, 2013)
- An exception while comparing schemas (on condition that before schema comparison the data comparison process was implemented) is fixed
- InvalidOperationException while executing queries on SQL Azure is fixed
- A problem related to the focus, while executing several statements is fixed
- A problem with highlighting of the IIF function is fixed
- TypeLoadException on comparing ASSEMBLY is fixed
- A problem related to the searching and replacing tabs and whitespaces is fixed
New in dbForge Schema Compare for SQL Server 3.0.186 (Oct 1, 2013)
- NullReferenceException on adding rows in Data Editor is fixed
- NullReferenceException on retrieving data from the tables containing a BIGINT field is fixed
- NullReferenceException on detecting a cyclic dependency is fixed
- Problem with saving a file's encoding is fixed
- NullReferenceException on attempting to perform synchronization into a snapshot via the command line interface is fixed
- NullReferenceException on executing a query is fixed
- Problem with removing a record in Data Editor is fixed
New in dbForge Schema Compare for SQL Server 3.0.181 (Aug 26, 2013)
- Error on opening schema synchronization script in external editor is fixed
- Problem in data editor with not assigning default values is fixed
- Problem with clearing memory on selecting data from table is fixed
- Problem with committing changes in version control system is fixed
- Problem with running the application on .NET Framework 4.5 is fixed
New in dbForge Schema Compare for SQL Server 3.0.170 (Jul 12, 2013)
- Problem with connecting to TFS on visualstudio.com is fixed
- The information is added to the report, while detecting the circular reference
- NullReferenceException on invoking Help in the Command Line is fixed
- "Statistics norecompute" options translation is fixed in Russian Edition
- TFS 2010 connection failure is fixed
- Error on changing connection in SQL document is fixed
- Work with memory is improved while redirecting data to the Output window
- The problem with inaccurate title of filter in schema comparison document is fixed
- The problem with applying a filter in Data Editor is fixed
- Incorrect behaviour with identity columns on adding data in Data Editor is fixed
New in dbForge Schema Compare for SQL Server 3.0.155 (Apr 16, 2013)
- The problem with the temporary table on schema synchronizing is fixed
- The problem with procedure's dependencies determination on schema comparison is fixed
- InvalidOperationException on executing a script is fixed
- ArgumentException on saving command line arguments in the Schema Comparison wizard is fixed
New in dbForge Schema Compare for SQL Server 3.0.152 (Apr 10, 2013)
- The problem with saving the Splitting options is fixed
- InvalidOperationException on executing a script is fixed
- The problem with changing options for code editor is fixed
- Incorrect behaviour on synchronizing a function in Schema Comparer is fixed
- NullReferenceException on trying to find a search pattern in a document is fixed
- InvalidOperationException on editing data in Data Editor is fixed
- The problem with connection to TFS 11 is fixed
- The problem with punctuation's visibility in code editor with black background being set is fixed
- NullReferenceException on executing a script is fixed
- Syntax error on executing the current statement using the Execute Current Statement command is fixed
- Wrong displaying of NULL values in comparison reports is fixed
- NullReferenceException on choosing invalid file as a snapshot file is fixed
- Syntax error on executing a script with @@ variables is fixed
- The error on choosing a snapshot in the Schema Comparison wizard is fixed
New in dbForge Schema Compare for SQL Server 3.0.133 (Jan 18, 2013)
- NullReferenceException on comparing schemas of SQL Azure is fixed
- Error on default schema mapping is fixed
New in dbForge Schema Compare for SQL Server 3.0.132 (Jan 15, 2013)
- ArgumentException on clicking Save As My Defaults in the synchronization wizard is fixed
- ArgumentException on describing view columns is fixed
- SqlTypeException on executing stored procedure with data entered out of the permissible range
- The error on working with Team Foundation Server is fixed
- Error on generating script for indexes is fixed
- Error on setting alias name in upper case is fixed
- Incorrect tables comparison when the 'Ignore Unique Key' option is on is fixed
- NullReferenceException on comparing schemas of backup copies is fixed
- Error on generation of incorrect schema synchronization script when an account with restricted rights is used is fixed
- Error 8623 on schema comparison is fixed
New in dbForge Schema Compare for SQL Server 3.0.110 (Jan 15, 2013)
- SQL Server 2012 LocalDB is now supported
- Schema comparison performance is improved
- Synchronization of procedure with dependencies is fixed
- ArgumentException on opening a file through the command line is fixed
- ArgumentException on synchronizing databases in Schema Compare is fixed
- Application's hanging when comparing snapshots is fixed
- TargetInvocationException in the Schema Comparison wizard is fixed
- Incorrect creating of foreign keys is fixed
- Incorrect trial on Windows 8 is fixed
- ArgumentNullException on finding the next occurence in text is fixed
- Old warnings that occured during comparison are removed now
- NullReferenceException on searching a text in SQL document is fixed
- NullReferenceException on applying the filter and removing it after refresh in the Schema Comparison document are fixed
- NullReferenceException on opening recent Schema Comparison document is fixed
- 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
- ComponentNotRegisteredException on comparing data with a backup as a source or target is fixed
- Incorrect behaviour with specifying file groups in synchronization scripts is fixed
- Use ALTER will be used instead of DROP/CREATE for stored procedure in all editing features
- Losing privileges on source objects after editing or synchronizing databases in Schema Compare is fixed
- Switch "/schemacompare" was added in the command line
- InvalidOperationException on closing a connection with invalid transaction is fixed
New in dbForge Schema Compare for SQL Server 3.0.93 (Sep 18, 2012)
- Incorrect resolving dependencies during synchronization of procedures is fixed
- ArgumentException on opening a document if fixed
- InvalidOperationException on executing a query is fixed
- Application suspension on comparing snapshots is fixed
- Incorrect behaviour of setting My Default Options is fixed
- Object Filter in the comparison wizard is fixed
- Incorrect behaviuor on swapping source and target is fixed
- Several improvements with users on Azure are made
- Duplicate creation of extended properties for functions is fixed
New in dbForge Schema Compare for SQL Server 3.0.61 (Sep 18, 2012)
- Error during syncronization is fixed
- Error "Empty path name is not legal" is fixed
- Problem with table inconsistency during schema comparison is fixed
- Error on a query for describing database is fixed
- Error "Object cannot be cast from DBNull to other types" is fixed
New in dbForge Schema Compare for SQL Server 3.0.57 (Sep 18, 2012)
- InvalidCastException on describing a database is fixed
New in dbForge Schema Compare for SQL Server 3.0.54 (May 23, 2012)
- Error report on the document or application closing is fixed
- Problem with Ignore Case option is fixed
- Problem with object dependency is fixed
- Problem with function describing for SQL Server 2000 is fixed
New in dbForge Schema Compare for SQL Server 3.0.48 (May 4, 2012)
- OutOfMemory exception in triggers comparison is fixed
- Error in process of describing database objects is fixed
New in dbForge Schema Compare for SQL Server 3.0.44 (Mar 1, 2012)
- Problems with installation of Trial edition are fixed
New in dbForge Schema Compare for SQL Server 3.0.43 (Feb 24, 2012)
- 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
- 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)
New in dbForge Schema Compare for SQL Server 2.00.155 (Aug 29, 2011)
- Fixed bug related to foreign key cycle dependencies is resolved
- Fixed bug related to using ignore case option
New in dbForge Schema Compare for SQL Server 2.00.150 (Apr 6, 2011)
- Fixed bug related to update nullable values
New in dbForge Schema Compare for SQL Server 2.00.149 (Mar 18, 2011)
- Fixed bug related to duplicate foreign keys (T26816)
- Fixed bug related to deadlock on connecting to the svn (S13126)
New in dbForge Schema Compare for SQL Server 2.00.148 (Jan 5, 2011)
- Fixed bug related to custom schema mapping
- Fixed bug related to saving the password for SVN
- Fixed bug related to size limits for user defined aggregate
New in dbForge Schema Compare for SQL Server 2.00.145 (Dec 16, 2010)
- CustomAttributeFormatException when reading assembly attributes was fixed
New in dbForge Schema Compare for SQL Server 2.00.143 (Oct 29, 2010)
- "Failed to sort objects" problem while comparing assemblies fixed
- "Unbreakable cycle" problem while comparing users fixed
- Added quotation of complex names for assemblies
New in dbForge Schema Compare for SQL Server 2.00.131 (Oct 29, 2010)
- 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
New in dbForge Schema Compare for SQL Server 2.00.129 (Oct 29, 2010)
- Fixed bug of restoring constraints, indexes and statistics related to renamed columns
- Fixed bug of setting NOT NULL constraint for VARCHAR(MAX) columns
- Fixed bug related to direct synchronization into a database on case-sensitive servers
- Fixed displaying extended properties of unique key and primary keys during ignoring these keys
- Fixed bug related to DML trigger dependency on a column
New in dbForge Schema Compare for SQL Server 2.00.127 (Oct 29, 2010)
- The comparison option "Synchronize database properties" is turned on by default
- Fixed bug related to simultaneous comparison and snapshot creation
- Fixed bug related to NRE while synchronization script generation
New in dbForge Schema Compare for SQL Server 2.00.127 (Oct 29, 2010)
- The comparison option "Synchronize database properties" is turned on by default
- Fixed bug related to simultaneous comparison and snapshot creation
- Fixed bug related to NRE while synchronization script generation
New in dbForge Schema Compare for SQL Server 2.00.120 (Oct 29, 2010)
- Fixed bug related to synchronizing of views with cycled dependences
New in dbForge Schema Compare for SQL Server 2.00.113 (Oct 29, 2010)
- Fixed bug related to describing of extended properties and partition functions
New in dbForge Schema Compare for SQL Server 2.00.111 (Feb 5, 2010)
- 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
New in dbForge Schema Compare for SQL Server 2.00.107 (Feb 5, 2010)
- 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
New in dbForge Schema Compare for SQL Server 1.50.336 (Sep 19, 2009)
- 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
New in dbForge Schema Compare for SQL Server 1.10.265 (Jul 18, 2009)
- 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
New in dbForge Schema Compare for SQL Server 1.10.250 (Jun 5, 2009)
- Faster comparison of database objects Synchronization of object permissions RULE and DEFAULT support Improved table synchronization