In this section, we will describe in detail how you can select the lists and libraries for replications across both the replication models.
SQList supports two types of replication models, Selective Replication, and Broad Replication.
Let's first cover the case of selective replication. The first step involves specifying the type of replication and we have selected the selective replication.
Selective replication is a type of replication where you can replicate a specific set of the lists or the libraries from the sites or subsites. Once you proceed with selective replication, SQList will list down all the lists and libraries present in the sites and subsites present within the main site.
You can either choose all the lists and libraries within a site or subsite by checking the checkbox specified against the URL of the site. But if you want to select a specific set of lists and libraries then you can check the checkboxes against specific lists or libraries.
For example, If you want to replicate all the lists and libraries within the main site to be exported to SQL Server, then you can select the first option ( as shown above) of "All lists and libraries for selected site".
While selecting the lists for export, you can also maneuver the default export settings or the global settings to suit your requirements. SQList provides a variety of options to cater to almost all types of requirements. The settings range from basic export options to advance export options.
It is worthwhile to note one of the facts of selective replication. If you check the checkbox at the root level which is named as “All Lists and Libraries”, it signifies that you are willing to export all lists and libraries from that site. So, if any list or library is added later then it will be part of replication as well and will be exported to SQL Server. Otherwise, if you had been selective in choosing the list, then only the intended lists will be exported.
Now moving on to the case of broad replication. It works specifically at site and subsite level. If you need to export commonly named lists and libraries across the site hierarchy, then the broad replication is the replication for you. If you decide to opt for broad replication, first you need to choose the level of the site from where you want to export the data. SQList will show all the hierarchy levels in the main site. Depending on your requirement, you can choose the appropriate level.
Once you have chosen the level, SQList will show you the all unique lists and libraries within that site and then you need to choose one or more to continue.
It is worthwhile to note one of the aspects of broad replication that it relies on the combination of unique name and level of the site that you have chosen for replication. So, if any list or library is added in the future with the same name in any of the sites having the same specified level, then the newly added list or library will be part of replication as well.