What's new in SQL Delta 6.6.8.2245
Apr 30, 2024
- Improved Dependency sorting for scripting
- Fixed Assembly positioning
- Bug fixes
New in SQL Delta 6.6.5.2241 (Mar 23, 2023)
- Support for SQL Server 2022
- Fixed issue with Full Text Index and column drop/creation
- Added DDL Triggers to filters
- Bug fixes
New in SQL Delta 6.6.4.2240 (Apr 21, 2022)
- Performance improvement for large volume table changes
- Fixed table recreate size detection for varchar - nvarchar columns
- Fixed print schema compare loading incorrect file
New in SQL Delta 6.6.3.2239 (Mar 24, 2022)
- Added improved scripting for recreating tables to include automatic truncation when new column is smaller
- UI fixes
New in SQL Delta 6.6.2.2237 (Mar 3, 2022)
- Fixed trigger order script error
- Fixed scripting issues
- Bug fixes
New in SQL Delta 6.6.2.2236 (Jan 31, 2022)
- Fixed data compare script issues
- Fixed issue with incorrect transaction statement for system versioned tables
- Bug fixes
New in SQL Delta 6.6.2.2235 (Jan 17, 2022)
New in SQL Delta 6.6.2.2234 (Jan 6, 2022)
- Data compare script failing to regenerate foreign key.
- Bug fixes.
New in SQL Delta 6.6.2.2233 (Dec 20, 2021)
- Improved scripting performance in some rare cases.
- Bug fixes.
New in SQL Delta 6.6.1.2232 (Nov 22, 2021)
- Fixed when option force Drop Create is active the drop script for some objects was not always generated.
New in SQL Delta 6.6.1.2231 (Nov 12, 2021)
- Fixed Mouse Wheel support for popup panels
- New Data Compare option to persist display settings and allow manual column sizing
- Improved Data Compare auto column sizing to preference name
- Fixed Scripting with the option sort by name now generates an alter statement in name order.
- Bug fixes
New in SQL Delta 6.6.0.2230 (Oct 8, 2021)
- New Decode With Encryption option supporting the decoding of encrypted definitions
- New Add WITH ENCRYPTION option to add WITH ENCRYPTION to definitions allowing automatic encryption of definitions
- New Ignore Encrypted option to stop loading and comparing encrypted objects
- New Ignore With Encryption to ignore the With Encryption statement in schema compare
- New persistent tabs in Schema View projects
- New data search and sorting of results in Schema View projects
- New keyboard shortcuts Schema View projects including Alt+Left and Alt+Right to change tabs
- Improved keyboard shortcuts across entire application
- Improved dependency analysis
- Improved command line /R /Q (execute sync silently) returns the errorlevel with number of errors
- Improved data compare details display and significant improvement displaying very large files
- Improved Azure multi-factor authentication support.
- Bug fixes.
New in SQL Delta 6.5.15.2224 (Jun 30, 2021)
- Fixed scripting of SET statement in modified triggers
- Fixed READONLY in compare/script to Azure and other cases
- Changed force drop and recreate functionality
- Bug fixes.
New in SQL Delta 6.5.14.2223 (May 11, 2021)
- Improved transaction scripting for Memory Optimized objects.
- Improved printing data compare details
- Tweaks to Schema View script editing with improved functionality:
- Ctrl + Shift + Up/Down to move line up/down
- Ctrl + Shift + D to duplicate line/selected content
- Ctrl + C without selection, copy row
- Ctrl + X without selection, cut the row
- Ctrl + / improved SQL comments
- Bug fixes.
New in SQL Delta 6.5.13.2222 (Mar 25, 2021)
- Add new ForceCurrentForDatabase option to force any ALTER DATABASE to use current instead of specific target database name
- Fixed filter values, now filter values are escaped for load filter with snapshots since these filters use RegEx.
New in SQL Delta 6.5.12.2221 (Mar 18, 2021)
- Added Snapshot load filters. A snapshot can have objects filtered in the same way as normal schema load.
- Added new load filter <object type>. This applies the filtering text to only the object type such Table, View, etc. The dropdown list shows the object type key words and then surround with <>. For example <table>%Apollo% will exclude all tables with the name containing Apollo. All other objects are loaded without filtering.
- Fixed incorrect database script for change tracking
- Fixed change tracking scripting
New in SQL Delta 6.5.11.2220 (Mar 16, 2021)
- Fixed crash during script generation
- Fixed including timestamps in recreate table process when timestamp columns are insert mapped
- Improved column mapping/matching in schema table recreate including improved automatic data copy selection
- Improved column mapping messages in schema table recreate
- Bug fixes
New in SQL Delta 6.5.10.2218 (Feb 26, 2021)
- Improved performance of data compare detailed report
- Bug fixes
New in SQL Delta 6.5.10.2217 (Feb 22, 2021)
- Improved data export to provide option to export only selected rows.
- Changed Data Compare Options with Match Null to String which matches Null value to empty string and now matches Null to Zero value for integers.
- Fixed data compare support for computed index values
New in SQL Delta 6.5.9.2216 (Feb 2, 2021)
- Improved Ignore Replication Settings to remove more replication objects automatically added by SQL Server
- Bug fixes
New in SQL Delta 6.5.9.2215 (Feb 1, 2021)
- Support for Active Directory Authentication
- For the new Active Directory Authentication requires the latest OLEDB driver which can be found at the link below (Valid Jan 2021).
- Fixed issues supporting SQL Server 2000
- Bug fixes
New in SQL Delta 6.5.8.2214 (Nov 26, 2020)
- Improved support for SQL Server 2019
- Added new option to ensure ALTER statement for columns changes.
- Fixed issue not checking dependency on queues
- Bug fixes
New in SQL Delta 6.5.8.2212 (Nov 2, 2020)
New in SQL Delta 6.5.8.2211 (Nov 2, 2020)
New in SQL Delta 6.5.8.2210 (Nov 2, 2020)
- Fixed always deleting report templates
- New filter in data compare results to hide same rows
- Bug fixes
New in SQL Delta 6.5.7.2209 (Nov 2, 2020)
- Bug fix for set first/last Trigger order
- New filter to hide equal records in data compare results
- Bug fixes
New in SQL Delta 5.1.1.84 (Oct 29, 2012)
- Improvements:
- SQL Delta for SQL Server (SDSS) Version 5.1 has been significantly re-engineered to perform faster compares and quicker script generation, to work with SQL Server 2008 and support Unicode throughout the application.
- The data compare now provides two result views, the original view with the source row and target row following on and now a side-by-side view displaying the source and target rows merged into one long row.
- Smarter schema scripting for column name changes. New filters and filter window so you can easly customize the display filters.
- More searching and filtering of results throughout the application, even an owners filter