What's new in dbForge Data Compare for SQL Server 5.4.4
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 bug fixes:
- Resolved an issue with displaying incorrect row counts for tables (D104947)
New in dbForge Data Compare for SQL Server 5.3.4 (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
- User-reported bug fixes:
- Fixed the behavior of the Reseed Identity Columns option for Azure connections in Data Compare (D78869)
- Fixed an issue with the display of differences in the XLS comparison reports in Data Compare (D79090)
- Fixed an issue that occurred when opening Data Compare (D73600)
New in dbForge Data Compare for SQL Server 5.2.4 (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
- User-reported bug fixes:
- Fixed an issue with generating a data comparison report in the XLS format.
- Fixed an issue with reading comparison parameters in console mode in Data Compare.
- Fixed a query execution error in the SQL Document.
- Fixed an issue with using the object names mapping options
- Fixed an error that occurred with comparing data
- Fixed the interception of third-party exceptions in dbForge add-ins.
- Fixed an issue with generating Excel and HTML reports when the 'Hide unmodified columns' option is enabled in Data Compare
New in dbForge Data Compare for SQL Server 5.1.61 (Jun 17, 2021)
- New features and improvements:
- Redesigned Progress window for data comparison and synchronization
- Exclude newly added objects option in Data Compare Wizard
- Tolerance Interval option in Data Compare Wizard
- Pre/Post-scripts execution tab in Data Synchronization Wizard
- New formatting profiles
- Options Search
- Integration into MS SSMS v18.9
- User-reported and internal bug fixes:
- Error with loading the application assemblies (T298119, T286039, T288576)
- Quotation marks were added to string type when generating report in HTML file format (T302672)
- Error with skipping Data Generator schema in data synchronization script (T292907)
- Error with generating data for the tables with circular dependencies (T306370)
New in dbForge Data Compare for SQL Server 5.0.52 (Oct 10, 2019)
- Problem with assembly loading is fixed (T291513)
New in dbForge Data Compare for SQL Server 5.0.33 (Sep 3, 2019)
- Redesigned data compare control
- Redesigned data comparison report window
- Redesigned data comparison report in CSV
- Redesigned data comparison ssms add-in window
New in dbForge Data Compare for SQL Server 4.5.48 (Jul 1, 2019)
- Problem with assembly loading is fixed (T279738)
New in dbForge Data Compare for SQL Server 4.5.43 (May 10, 2019)
- User reported bug fixes:
- Errors when SSMS starting are fixed (T274282, T279738)
- Minor user reported bugs are fixed
New in dbForge Data Compare for SQL Server 4.5.26 (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 Data Compare for SQL Server 4.4.44 (Dec 26, 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:
- Synchronization issue with using command line is fixed
- Problem with assembly loading is fixed (T270855)
- Problem with false 'Different Records' is fixed (T266252)
- Problem with opened connections is fixed (T72044)
- Other user reported bugs are fixed
New in dbForge Data Compare for SQL Server 4.3.106 (Jul 20, 2018)
- Constraint synchronization issue is fixed (T257966)
- Foreign keys synchronization issue is fixed (T256473)
New in dbForge Data Compare for SQL Server 4.3.85 (Oct 6, 2017)
- Issue with backup comparision is fixed (T233029)
New in dbForge Data Compare for SQL Server 4.3.80 (Sep 4, 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
- MASKED columns are supported
- Option to automatically select a key for comparing objects without a suitable unique key
- Added option to turn ONOFF Generation of IF NOT EXISTS on inserting
- Possibility to open the comparison wizard instead of the comparison autorun when opening the .dcomp files
- Command-Line Master which greatly simplifies creation of the command line execution files
New in dbForge Data Compare for SQL Server 4.2.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
- Comparison and synchronization of memory-optimized tables
- 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 Data Compare for SQL Server 4.1.38 (Sep 29, 2016)
- Issue with export of comparision report to XLS is fixed (T186361)
New in dbForge Data Compare for SQL Server 4.1.35 (Sep 29, 2016)
- SQL Server 2016 support
- Product now integrates into SSMS 2016
New in dbForge Data Compare for SQL Server 4.0.32 (Sep 29, 2016)
- SET LANGUAGE statement fixed (T156828, T157882)
- Command line error fixed (T139324)
- Some problem related to synchronization solved (T152622)
- Executing in batch mode fixed (T156691)
New in dbForge Data Compare for SQL Server 4.0.26 (Dec 16, 2015)
- Redesigned Comparison Document UI
- SSMS Integration Support:
- SQL Server Management Studio integration enables starting the data comparison directly from SSMS
New in dbForge Data Compare for SQL Server 3.9.287 (Dec 17, 2014)
- Minor improvements
- User reported bug fixes
New in dbForge Data Compare for SQL Server 3.9.284 (Nov 15, 2014)
- Data Comparison:
- Show white spaces option
- Ignore computed columns option
- Zooming font size in Data Viewer
- SQL Editing and Execution:
- Query execution pane
- Easy way to hide results
- Command-line interface for SQL formatting
- Encoding switch in the /execute command-line operation
- 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
- Other Features and Improvements:
- Create Schema Snapshot and Data Report wizard windows now work in the modeless mode.
- Windows 10 support
- Updated Start Page
- New skins
New in dbForge Data Compare for SQL Server 3.8.265 (Jun 28, 2014)
- SQL Server 2014 is supported
- Code Completion
- Data Compare and Synchronization:
- Columnstore index is supported
- Ignore column order in indexes option is added
- Include print comments option is added
- Exclude comments option is added
- User Interface:
- SET connection options in query execution are added
- Switching tabs by the CTRL+ALT+PAGE UP and CTRL+ALT+PAGE DOWN keys combination
- SSMS shortcut schema availability
- Possibility to switch from the wizard page to the main application window is added
- Coloring a database connection according to the document category is possible now
- SQL document zooming by holding the CTRL key and rotating the mouse wheel is added
- Restoring the documents opened in the last session is possible now
New in dbForge Data Compare for SQL Server 3.0.209 (Nov 30, 2013)
- NullReferenceException on editing data in the Data Editor is fixed
- OutOfMemoryException on searching data in Data Editor is fixed
- Problem with the installation of the product is fixed
- Wrong behaviour on synchronizing data with a target database in Data Compare is fixed
- The navigation from the Error List to the specific error in a script is fixed
New in dbForge Data Compare for SQL Server 3.0.205 (Nov 30, 2013)
- 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
- A problem related to the searching and replacing tabs and whitespaces is fixed
New in dbForge Data Compare for SQL Server 3.0.199 (Sep 23, 2013)
- NullReferenceException on adding rows in Data Editor is fixed
- NullReferenceException on retrieving data from the tables containing a BIGINT field is fixed
- Problem with saving a file's encoding is fixed
- NullReferenceException on executing a query is fixed
- Problem with removing a record in Data Editor is fixed
- Computed columns are now excluded from synchronization by default
New in dbForge Data Compare for SQL Server 3.0.194 (Aug 23, 2013)
- Problem in data editor with not assigning default values is fixed
- Problem with clearing memory on selecting data from table is fixed
- Problem with application freezing on switching between tabs after data synchronization script generation is fixed
- Problem with running the application on .NET Framework 4.5 is fixed
New in dbForge Data Compare for SQL Server 3.0.183 (Jul 15, 2013)
- NullReferenceException on invoking Help in the Command Line is fixed
- Error on changing connection in SQL document is fixed
- Work with memory is improved while redirecting data to the Output window
- InvalidCastException on editing a subquery in Query Builder is fixed
- The 'Round float types up to 3 digits' option is added in data comparison wizard
- 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 Data Compare for SQL Server 3.0.168 (Apr 15, 2013)
- InvalidOperationException on executing a script is fixed
- ArgumentException on saving command line arguments in the Data Comparison wizard is fixed
New in dbForge Data Compare for SQL Server 3.0.165 (Apr 15, 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
- 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
- Syntax error on executing a script with @@ variables is fixed
- The problem with using store procedures as Custom Query in data comparison is fixed
- NullReferenceException on switching to the Mapping page in the Data Comparison wizard is fixed
New in dbForge Data Compare for SQL Server 3.0.145 (Apr 15, 2013)
- ArgumentException on clicking Save As My Defaults in the synchronization wizard is fixed
- Saving of changes in object mapping to *.dcomp files is fixed
- ArgumentException on describing view columns is fixed
- SqlTypeException error on executing stored procedure with data entered out of the permissible range
- Error on setting alias name in upper case is fixed
- NullReferenceException error on opening a *.dcomp file is fixed
New in dbForge Data Compare for SQL Server 3.0.123 (Nov 10, 2012)
- SQL Server 2012 LocalDB is now supported
- ArgumentException on opening a file through the command line is fixed
- Incorrect trial on Windows 8 is fixed
- Old warnings that occured during comparison are removed now
- Incorrect values on generating DELETE statements in Data Compare are fixed
- NullReferenceException on searching a text in SQL document is fixed
- Option "Disable Check Constraints" is saved in the Data Comparison document now
- NullReferenceException on saving Data Comparison document 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
- "Error Number: 80121040" on opening MS Management Studio was fixed
- InvalidOperationException on closing a connection with invalid transaction is fixed
New in dbForge Data Compare for SQL Server 3.0.106 (Sep 18, 2012)
- InvalidOperationException on executing a query is fixed
- Incorrect width for column is fixed
- Incorrect sequence of columns in the grid is fixed
- Problem with NCHAR and NVARCHAR is fixed
- Performance in comparison result document was increased
New in dbForge Data Compare for SQL Server 3.0.89 (Jul 24, 2012)
- Error while running Microsoft SQL Server Management Studio is fixed
New in dbForge Data Compare for SQL Server 3.0.79 (May 5, 2012)
- User reported bug fixes:
- Execute the script directly against the target database error is fixed
New in dbForge Data Compare for SQL Server 3.0.74 (May 5, 2012)
- User reported bug fixes:
- Error with Next and Synchronize buttons in Synchronization Wizard is fixed
- Error on Update Form is fixed
- Error on Action Plan and Warnings tabs of Synchronization Wizard is fixed
- Error with synchronization into database from command line is fixed
- Error during installation is fixed
- Integration problem with Microsoft Management Studio is fixed
New in dbForge Data Compare for SQL Server 3.0.54 (May 5, 2012)
- SQL Server 2012 Support:
- Databases on SQL Server 2012 can be compared and synchronized as easily as the ones on previous server versions. dbForge Data Compare for SQL Server fully supports SQL Server 2012 database connection and processing.
- User reported bug fixes:
- Dialogue windows always pop up on the primary monitor
- Reporting via command line options problem is fixed
- Error while reading columns is fixed
New in dbForge Data Compare for SQL Server 3.0.52 (Nov 11, 2011)
- Integration problems with Microsoft Management Studio are fixed (T32152, T32397, T32555)
- Module loading error is fixed (T31423)
- Error while comparing Datetimeoffset type is fixed (T31423)
- Error while comparing using command line with user id unspecified is fixed
- Null reference exception on Visible columns button pressing is fixed (T32786)
- Input string is not in a correct format error is fixed (T32922, T33087)
- Comparison key too long eror is fixed (T33078)
- SQL Filter saving error is fixed (T33731)
New in dbForge Data Compare for SQL Server 3.0.38 (Nov 11, 2011)
- T31486 Problem with datetime values on Arabic culture
- T31471 Problems with trial checking on Microsoft Management Studio are fixed
New in dbForge Data Compare for SQL Server 3.0.33 (Nov 11, 2011)
- Problems with trial checking are fixed
New in dbForge Data Compare for SQL Server 3.0.23 (Nov 11, 2011)
- SQL Azure Support:
- Comparing data and synchronizing SQL Azure databases has just become as easy as processing common ones. dbForge Data Compare for SQL Server fully supports SQL Azure database connection and processing.
- SQL Server Management Studio Integration:
- From now on you can quickly launch your comparison right from the Object Explorer context menu as well as from the SSMS main menu.
- New extended data comparison reports:
- Possibility to analyze comparison results in the offline-mode due to export of real data into the report.
- New Comparison Report wizard is added.
- Possibility to include only columns containing differences for the rows that contain differences into comparison report.
- Possibility to include the number of changes for each column into the comparison report.
- Custom query result comparison:
- If you don't need to compare all data in your database, but need some customized comparison (for example, you need to see what has changed in your database over some period of time), you can compare the results of specific queries. For this, use the custom query result comparison feature available in the new version of the product.
- More flexible comparison settings:
- "One-to-many" objects mapping can be used when some columns in the target database were separated as a table.
- Possibility to include objects into comparison by mask. It is useful when you need to compare groups of tables.
- Improved analysis of comparison results
- Full-text data search:
- Possibility to hide unchanged columns in the result data grid.
- The number of differences per column is now displayed on the status bar.
- Improved data synchronization:
- Ability to omit schema name in the generated script file is added. It is required for better script portability.
- Other improvements:
- Extended command line examples are added.
- User interface skins support is added.
- Start page is redesigned.
New in dbForge Data Compare for SQL Server 2.0.159 (Nov 11, 2011)
- 'Attempted to divide by zero' when updating values in identity columns (command-line mode only)
New in dbForge Data Compare for SQL Server 1.10.278 (Dec 9, 2009)
- NullReferenceExceptionBug on comparison start when "Best Fit" option is on was fixed
- OverflowException when fetching large identity seed or identity increment values was fixed
- Accidental InvalidOperationException becuase of not closed data reader was fixed
New in dbForge Data Compare for SQL Server 1.10.271 (Jul 29, 2009)
- InvalidOperationException when showing data comparison results was fixed
- Bug with table columns describe was fixed
- Bug with foreign key describing was fixed
- New data synchronization options were added that allow disabling triggers, dropping or recreating keys and indexes during data synchronization
- New data comparison option was added that allows ignoring TIMESTAMP columns during comparison
- The ability to copy action plan and list of warnings in synchronization wizard was added
- Faster comparison of tables