Crawling all the tables in a schema

When you create a database data source, you usually select one table or one view to crawl.

Alternatively, you can choose to crawl all the tables in a schema.

When you use this option, Exonar:

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

  • ignores tables that don’t have either of those

  • ignores views

You can use sampling in this mode too.

A suitable primary key or unique index must:

  • be on a single column (that is, not composite key)

  • not be nullable

  • have a supported data type

For MySQL you can use any data type except:

  • blob

  • tinyblob

  • mediumblob

  • longblob

  • varbinary

  • binary

  • geometry

  • geomcollection

  • linestring

  • multilinestring

  • multipolygon

  • point

  • multipoint

  • polygon

  • time

For Microsoft SQL Server, you can use any data type except:

  • binary

  • varbinary

  • image

  • cursor

  • sql_variant

  • table

  • hierarchyid

  • geography

  • geometry

  • timestamp

  • datetimeoffset

  • xml