Version 8.3.0.0 of SQList is a minor update; you can therefore upgrade for free if you have a licensed version 8.x. To download the latest version of SQList, visit the Download SQList page.
IMPORTANT, PLEASE READ: although we always strive to make upgrades as hassle-free as possible, we strongly recommend that you follow the installation and upgrade steps described in our support article:
How do I install or upgrade AxioWorks SQList?
Added Azure Entra ID Authentication to SQL Azure
We have added support for Azure Entra ID authentication, enabling connections to SQL Azure using App Registrations with Client ID and Client Secret. This provides a more secure and modern authentication method, aligning with best practices for managing access to cloud-based databases.
For a step-by-step guide to configure an Azure Entra ID connection to a SQL Azure database, please see this support article:
Configure an Azure Entra ID Connection to a SQL Azure Database
Enhanced error handling
In this enhancement to SQList, we have significantly improved error management to ensure greater resilience and reliability. Replications are no longer interrupted by failures in individual lists, allowing the overall process to continue while logging specific issues for review. Additionally, the initial synchronisation phase has been made fault tolerant by implementing a more detailed and persistent tracking of progress states. This means that if the sync is interrupted or an error occurs, SQList can resume from the exact point of failure without restarting the entire process, leading to more robust and efficient data replication.
Significant performance improvements
We have introduced further parallelisation, optimised SQL Server interactions, and refined the parsing of replication profiles, all contributing to significant performance improvements. These enhancements allow SQList to make more efficient use of system resources and reduce processing time, particularly during initial sync of very large lists to SQL Azure. In certain scenarios, these improvements have resulted in performance gains of up to three times compared to previous versions.
Added performance telemerty
We have added performance telemetry to SQList, enabling more effective analysis and investigation of potential performance bottlenecks. This additional data provides valuable insight into the replication process, helping to identify areas for optimisation and ensuring continued improvements in efficiency and reliability.
Enhanced Lookup Column handling
We have enhanced the handling of SharePoint Lookup Columns by introducing a new configuration setting that addresses the platform’s lookup column limits. This allows SQList to work more reliably with custom lookup columns, providing greater flexibility and stability when replicating custom SharePoint list structures.
Fixed minor bugs
We have fixed minor bugs, including issues with email alerts and misleading error messages in the logs, improving notification accuracy and log clarity.
