In this section, we will describe in detail the types of replication offered by SQList and how you can specify the type of replication you ought for the configured source.
SQList supports two types of Replication:·
Selective replication as the name suggests is a type of replication where you can replicate a specific set of the lists or the libraries from the sites or subsites. If you decide to opt this type of replication, SQList will show you all the lists and libraries present in the sites and subsites within the main site. You can either choose the entire collection by checking the checkbox at the root level or check the checkboxes against specific lists or libraries.
While selecting the lists for export, you can also maneuver the default export 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 just be selective in choosing the list, then only the intended lists will be exported not the lists which will be added in future.
Whereas in 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.