[av_textblock size=” font_color=” color=”]
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:
[/av_textblock]

[av_image src=’https://www4.axioworks.com/wp-content/uploads/2016/09/Archive-SharePoint-Datat-to-SQL-Server-SQList.png’ attachment=’3552′ attachment_size=’full’ align=’center’ styling=” hover=” link=” target=” caption=” font_size=” appearance=” overlay_opacity=’0.4′ overlay_color=’#000000′ overlay_text_color=’#ffffff’ animation=’no-animation’][/av_image]

[av_textblock size=” font_color=” color=”]
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:
[/av_textblock]

[av_image src=’https://www4.axioworks.com/wp-content/uploads/2016/09/sharepoint-list-being-archived-to-SQL-Server.png’ attachment=’3555′ attachment_size=’full’ align=’center’ styling=” hover=” link=” target=” caption=” font_size=” appearance=” overlay_opacity=’0.4′ overlay_color=’#000000′ overlay_text_color=’#ffffff’ animation=’no-animation’][/av_image]

[av_image src=’https://www4.axioworks.com/wp-content/uploads/2016/09/SQL-Select-SharePoint-Data-Archived.png’ attachment=’3554′ attachment_size=’full’ align=’center’ styling=” hover=” link=” target=” caption=” font_size=” appearance=” overlay_opacity=’0.4′ overlay_color=’#000000′ overlay_text_color=’#ffffff’ animation=’no-animation’][/av_image]

[av_textblock size=” font_color=” color=”]
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
[/av_textblock]