A list inside our Intranet SharePoint has reached the 5000 items limit threshold. We followed the Microsoft recommendation on how to overcome this limit adding indexed columns combined with filters as described here. Now, the issue is solved and I'm wondering if there's any way to download all the items from the list without filters. Datasheet view allows to download all the data without filters but I'm not sure if this datasheet view is going to collapse some day. Does anyone know how to connect directly to the entire's list data?
Instead of trying to do anything with the database, check out the daily time window, which is a setting that allows you to configure a time of day where list thresholds are ignored. No, don't set this for 24 hours a day, as the list threshold is an important aspect for keeping the farm healthy.