Configure Solr for SQL Server

Question

I am using tomcat 6.0 and running Solr in it. Can some one help me how to configure solr to index SQL Server DB?

Answer 1

Have you walked through the steps displayed in http://wiki.apache.org/solr/DataImportHandler? Just swap out the driver parts that specify MySQL and use the SQLServer driver.

I'd be happy to answer any more specific questions you have! I recommend you use Solr 1.4, the first release candidate is actually being published tonight.

Answer 2

Thomas -

Also make sure to check out the Data Import Handler FAQ sheet as there's a comment about setting the responseBuffering property to avoid out of memory errors with the Data Import Handler.

I agree with Eric's statement around using the Solr 1.4 RC as Shalin and others have contributed quite a few improvements (especially around delta imports) to the Data Import Handler.