Crawling all the tables in a database

When you create a database data source, you usually select one table or one view to crawl. The SQL Server data source has an option that allows you to crawl all the tables.

When you use this option, Exonar:

• crawls every table that has a primary key or unique index

• ignores tables that don’t have either of those

• ignores views

Sampling

You can use sampling in this mode too.

If you set a sample size to 1000, for example, Exonar crawls the first 1000 rows of every table that has a primary key or unique index.