Version 18.104.22.168 of SQList is a minor update; you can therefore upgrade for free if you have a licensed version 7.x. To download the latest version of SQList visit https://www.axioworks.com/sqlist-download/
There are no breaking changes in this release.
See below a summary of the changes.
Added feature to handle long list names
SQL Server does not support table names longer than 128 characters; SharePoint does not have such limitation with list names.
Albeit rare, there are cases of SharePoint lists with very long names that, even after being stripped of spaces and special characters, result in table names that are longer than 128 characters. Unless manually renamed in SQList, these lists cannot be exported to SQL Server.
We have added a setting to handle this situation; if enabled, SQList will truncate table names to 100 characters and include the list GUID to ensure uniqueness.
Note: the reason the name is not truncated to 128 characters is to leave room for attachment and multi-lookup table names.
This setting is available at Global, Replication, and List level.
This is what the list shown above looks like in the SQL Server database:
Added Azure AD Authentication to SQL Azure
You can now use the following Azure AD authentication methods to SQL Azure databases:
- Active Directory password authentication;
- Active Directory integrated authentication.
For full details, please refer to this support article:
Improved synchronisation of documents and attachments
We have optimised the way SQList synchronises document libraries and attachments when the download of the actual document is enabled.
There are now two new settings that control the size the the batch of items processed at a time in this case; these are smaller than those for lists to allow a more frequent storage into SQL hence releasing resources.
There should not be the need to change the default settings unless in special circumstances.
Unified Service Monitor
We have unified the Service Monitor and the Event Log into a single more practical dashboard so that you no longer have to switch back and forth between tabs.
Minor changes and fixes
- We fixed a small bug tat was preventing some error messages from being logged;
- Minor cosmetic tweaks.