Knowledge Base

All Articles

Get your free 30 Day SQList Trial License
Download and install SQList
Run SQList for the first time, and install your license
Configure a SQList replication and export SharePoint lists to SQL Server
Automatically exporting SharePoint data from sub sites using SQList
Known limitations of SQList
SQList version history
The "Replications" tab
Try AxioWorks SQList Version 6 for free
Download a previous version of SQList
How do I install or upgrade AxioWorks SQList?
The "SharePoint Site Definitions" tab
The "SQL Database Connections" tab
The "Service Status" tab
Choose a SharePoint site to export
Select or create a SharePoint connection
Select the type of replication required
Select the lists and libraries you would like to replicate
Select the subwebs to get the commonly named lists from
Select the names of the lists and libraries you would like to replicate
Select or create a SQL Server database connection
Site configuration - enter the details to connect to a SharePoint site
Save and start your replication
Connect to an existing SQL database, or create a new connection
Enter the details to connect to a SQL database
Manage replications
Select whether to export lists from one single site or from a number of sub-sites
Manage SharePoint connections
Manage database connections
Lists and libraries export options (Global settings)
The SQList service monitor
Check your licence and profile status
Select which lists you want to export from a SharePoint site
Select which SharePoint sub-sites you want to export
Select the names of the lists you want to export from the SharePoint sub-sites
Save your configuration and start the service
What is new in SQList ver. 7.1.1.0
What is new in SQList ver. 7.1.0.0
What is new in SQList ver. 7.0.0.0
What is new in SQList ver. 6.2.1.0
What is new in SQList ver. 6.2.0.0
What is new in SQList ver. 6.1.2.0
What is new in SQList ver. 6.1.1.0
What is new in SQList ver. 6.1.0.0
What is new in SQList ver. 6.0.5.0
What is new in SQList ver. 6.0.4.0
What is new in SQList ver. 6.0.3.0
What is new in SQList ver. 6.0.2.0
What is new in SQList ver. 6.0 (important update)
What is new in SQList ver. 5.4
What is new in SQList ver. 5.3
What is new in SQList ver. 5.2
What is new in SQList ver. 5.1
What is new in SQList ver. 5.0.3 (important update)
What is new in SQList ver. 5.0
What is new in SQList ver. 4.2
"401: Unauthorized" error when exporting sub-sites
"Login failed for user '<username>'" when connecting to a SQL Server database
"Select an existing site definition" tab
"Workflow Status" column not always gets updated in the SQL table
Audit Who Logged into a Computer and When
Authenticating with Office 365 using SSO and ADFS
Avoid getting throttled or blocked in SharePoint Online
Beware of some warnings that you may receive when you download, install, or run SQList.
Can I add triggers and indexes to the tables created by SQList?
Can I change the format of the SQL table names?
Change the default 10 second cycle sleep time
Configure a SQList replication and export SharePoint lists and libraries to SQL Server with the Replication Wizard
Configure authentication methods to SharePoint
Configure SQList to send email alerts when errors are logged
Configure SQList to use AppId and AppSecret authentication with SharePoint Online
Configure SQList to use Azure AD Application Permissions authentication with SharePoint Online
Configure SQList to use Azure AD Delegated authentication with SharePoint Online
Configure SQList to use Username and password (Online and On-Prem) authentication with SharePoint Online and On-Prem
Configure SQList to use Web login (Office 365) authentication with SharePoint Online
Connect SQList securely to a SQL Azure database through an encrypted connection
Cycle completed
Cycle started
Database version update
Determine the version of .NET installed on a machine
Dropping tables
Enable SQL Server system versioning for SQL tables generated by SQList
Error: "'Microsoft.SharePoint.SoapServer.SoapServerException' was thrown"
Error: "Document data for <tableName> (ID: <id>) could not be downloaded from url <url>"
Error: "Duplicate column name detected"
Error: "Invalid column name 'Child<name>ID'."
Error: "Object reference not set to an instance of an object"
Error: "The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold enforced by the administrator."
Error: "The transaction failed and was rolled back. String or binary data would be truncated."
Error: "There is an error in XML document"
Error: "This implementation is not part of the Windows Platform FIPS validated cryptographic algorithms"
Error: Could not establish trust relationship for the SSL/TLS secure channel.
Error: The remote server returned an error: (429)
Error:"The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator."
Error; "For security reasons DTD is prohibited in this XML document"
Errors when using a case-sensitive collation for a SQList destination database
Excessive number of AD logins when using Windows authentication
Export lists with large number of lookup columns
Failed to retrieve lookup list name for field "<field_name>" of type "<lookup_column_type>"
Find the internal name for a SharePoint column
Force a full re-sync for a specific list
Force SQList to re-export a list from scratch
Force SQList to re-sync a SQL table at a scheduled time
How can I export the list of SharePoint users?
How do I re-sync all data from scratch?
How does SQList export numeric values?
How does SQList handle deleted items?
How does SQList name Tables and Columns in the SQL tables
How SQList deals with large SharePoint datasets and replicates them to SQL Server
How SQList exports lookup columns linked to external content types
How SQList exports lookup-columns
How to connect to a SharePoint Online site that uses multi-factor authentication
How to exclude list columns from being exported
How to run SQList from command line
How to upgrade from a previous version to SQList version 6
How to use the WSSDebug utility
Installing SQList on a virtual machine
Installing, upgrading, or replacing a SQList license
Log SQList messages to a file or SQL table
Migrate SQList replications from version 5.x to version 6.x
Migrate SQList to a new machine
Move the SQList replication configuration from one machine to another
No valid connection could be obtained using the user credentials provided (see inner exception more details).
Number of rows in SQL table does not match number of items reported by SharePoint
Overview of SQList architecture
Parsing profile
Polling site for changes
Processing site changes for destination database
Replication wizard part 2 - Export from this site and its sub-sites
Replication Wizard Part 2 - Export lists and libraries from this site only
Repoint SQList after a SharePoint migration
Save documents and images exported by SQList as files
Script: Create a hierarchy of empty sites and lists in SharePoint site using PowerShell
Script: create a view of all common fields from multiple tables using TSQL
Script: Create list items in a SharePoint list using PowerShell
Script: Create lists in SharePoint site using PowerShell
Set up a connection to a SQL database
Site changes import
SQL Server: Archive deleted rows into a separate SQL table
SQList Manager becomes very slow or unresponsive
SQList service stopped
Stnchronising list
The "Shared With" column displays users who no longer have access to a document in SharePoint Online
The application has failed to start because its side-by-side configuration is incorrect.
The changeToken refers to a time before the start of the current change log
The Sevice Failed to Start - "Run as Administrator"
The SQList licensing model
The SQList Service Tray Icon application could not be found in the following location.
The sub-sites could not be loaded
Try AxioWorks SPReporting Beta for free
Tuning SQList for optimal performance
Upgrade AxioWorks SQList from ver. 5.x to ver. 6.x
Upgrade SQList 5.4.1 to .NET 4.6.1
Use SharePoint Item Level Permissions with Azure AD Application Permissions
Using "trusted authentication" to connect to SharePoint and SQL Server
What are SQList system requirements?
What is new in SQList ver. 4.1
Why are column default values not exported to the SQL table
Why are my calculated columns not being updated?