Our use of cookies

We use cookies to tailor your experience, gather analytics, and provide you with live assitance. By clicking "Accept" or continuing to browse our site you agree to the use of cookies. For more details please read our Cookie Policy.

What is new in SQList ver.

Version 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.

Image Placeholder
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.

Image Placeholder

This setting is available at Global, Replication, and List level.

This is what the list shown above looks like in the SQL Server database:

Image Placeholder

Added Azure AD Authentication to SQL Azure

You can now use the following Azure AD authentication methods to SQL Azure databases:

  1. Active Directory password authentication;
  2. Active Directory integrated authentication.
For full details, please refer to this support article:

Image Placeholder

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.

Image Placeholder

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.

Image Placeholder

Minor changes and fixes

  • We fixed a small bug tat was preventing some error messages from being logged;
  • Minor cosmetic tweaks.