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:
Download a fully working version of SQList by AxioWorks now
18 Jun 2021
We are looking for someone with experience in the SharePoint and BI arenas to take on the role of Sales and Marketing Manager. You will be able to […]
11 Jun 2021
One of the biggest conundrum of any organization planning to move to SharePoint is how to move all their documents stored in various different […]
04 Jun 2021
A new version of AxioWorks SQList is out today!
We have been really busy for the past few months, but here we are with a brand new release of […]
01 Jun 2021
Welcome to another exciting issue of our monthly Newsletter!
Each month, we try our best to bring to you content that is relevant and […]
16 May 2021
SharePoint Lists provides an easy and robust way of storing and manipulating data in SharePoint. When you set up a new custom list, you also get OOTB […]
01 May 2021
Welcome to another issue of our monthly Newsletter!
Thank you for the great feedback on the past newsletters, our team has been working […]
26 Apr 2021
There has been an exponential growth in SharePoint usage over the past few decades due to its vast set of capabilities to fulfill the […]
01 Apr 2021
Welcome to our second Newsletter!
Did you enjoy the first one? Or maybe you didn’t? Either way, do give us some feedback using the links at the […]
29 Mar 2021
During this Pandemic era, working remotely has significantly increased throughout the world and so is the usage of tools to facilitate collaboration […]
01 Mar 2021
We have just sent out our first newsletter and, being it our first one, we thought we dedicate a post to it. All future ones will go out just by […]
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.