I need to crawl data from SQL Server Database. For this, I created an external list using Business Connectivity Services. However, I encountered a limit on the number of requested rows: my table contains more than 2000 rows.
- How can I get around this problem?
- Is it possible to make the data requested by parts?
- Is there another better way to index data from the database?
I found that the limit on the number of returned rows does not affect the search crawler, it is able to successfully index all records from external content regardless of limits.