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.

Archiving SharePoint list and library data to SQL Server Tables

As of SQList v5 Professional, we have added a feature that will allow SharePoint list and library items to be archived to a SQL Server table. What do I mean by this?
We now have a setting that enables you to maintain deleted list items in the replicated SQL table. Once you have set up replication from a SharePoint lists or library to SQL server, using the SQList manager, items deleted in SharePoint will not be deleted in the corresponding SQL table. They will simply be marked as deleted.

To disable the removal of deleted list items from the corresponding SQL table, simply select the “Keep Deleted items” column in the list selection when configuring a replication:

If a list has the “Keep deleted items” option selected, when an item is deleted it will not be removed by the SQL table, but only marked as deleted in the new column named SQList.IsDeleted:

Note:

  • this feature is available to SQList Professional edition only;
  • only items that are deleted from the time the feature is enabled are kept in the SQL table, items deleted previously are not exported;
  • if you drop the SQL table, items marked as deleted will not be recovered;
  • if an item actually does need to be deleted from the SharePoint list and SQL table, it has to be done manually for the SQL table;
  • if an item previously exported to the SQL table is updated and then deleted while SQList is not running (or the replication is failing), the item in teh SQL table will be marked as deleted, but will contain the data as they were before the last update;
  • this feature must not be confused with versioning.

Download a fully working version of SQList by AxioWorks now

Latest articles

Build your Apps in MS Teams with MS Dataverse for Teams

27 Jun 2022

MS Teams has become one of the most widely used tools for team collaboration and communication in organizations using Microsoft echo-system for […]
[read article]

Dataverse: A one-stop-shop for your App data storage and management

24 May 2022

Data is at the centre of any business application development and is often the deciding factor for which tech. stack to be used for the development. […]
[read article]

AxioWorks Newsletter April 2022: Still working on the next release of SQList…

30 Apr 2022

Hello Reader, Welcome to another exciting issue of our monthly Newsletter! Each month, we try our best to bring to you content that is relevant and […]
[read article]

What’s coming in Power Platform Release wave one of 2022

21 Apr 2022

Due to the ever-rising popularity of the Power platform, Microsoft continues to focus on improving the usability and versatility of the Power […]
[read article]

AxioWorks Newsletter March 2022: Working on the next release of SQList

30 Mar 2022

Hello Reader, Welcome to another exciting issue of our monthly Newsletter! Each month, we try our best to bring to you content that is relevant and […]
[read article]

How to Efficiently Develop and Deploy Solutions in Power Platform

20 Mar 2022

With the Emergence of Low Code to No-Code development platforms, developers have been ever so busy developing solutions utilizing those platforms […]
[read article]

AxioWorks Newsletter February 2022: A good month

28 Feb 2022

Hello Reader, Welcome to another exciting issue of our monthly Newsletter! Each month, we try our best to bring to you content that is relevant and […]
[read article]

Five most awesome features in MS Lists

20 Feb 2022

Microsoft Lists previously known as SharePoint Lists have been widely used for maintaining and storing data in SharePoint and its usage has grown […]
[read article]

AxioWorks Newsletter January 2022: Hello 2022, good bye Covid (we hope)

31 Jan 2022

Hello Reader, Welcome to another exciting issue of our monthly Newsletter! Each month, we try our best to bring to you content that is relevant and […]
[read article]

What went down at MS Ignite 2021: Power Automate and Power Virtual Agent Edition

14 Jan 2022

When we talk about the biggest annual tech conferences of the year, Microsoft Ignite comes to mind where not only do we get a view of all their […]
[read article]

Get SharePoint and SQL news to your inbox

Stay up-to-date with industry news and trends, SQL and SharePoint innovations and all the latest from AxioWorks by subscribing to our monthly newsletter.

Subscribe to the AxioWorks newsletter

*