Indexing Multiple Datasources

[Kay]

Hello,

We have 2 MS SQL Server Databases which we wanted to index .But most of the
columns in the Databases have the same names. For e.g. Both the DB’s have
the columns First name ,Last name ,etc.

How can you index multiple Databases using single db-data-config file and
one schema? 

Here is my data-config file
<dataConfig>

<dataSource type="JdbcDataSource" name="ds-2"
driver="com.microsoft.sqlserver.jdbc.SQLServerDriver"
url="jdbc:sqlserver://localhost;DatabaseName= " user="" password="" />
    <document name="PersonTable">
                <entity dataSource="ds-2" name="People" query="SELECT
BusinessEntityID,FirstName,LastName FROM dbo.PersonTable">
                        <field column="BusinessEntityID" 
name="BusinessEntityID" />
                        <field column="FirstName" name="FirstName" />
                        <field column="LastName" name="LastName" />
                        <field column="Department" name="Department" />
                        <field column="Age" name="Age" />
                        
                </entity>
                </document>
            
    <document name="person">
                <entity dataSource="ds-1" name="People" query="SELECT   
BusinessEntityID,NameStyle,Title,FirstName,MiddleName,LastName,ModifiedDate
FROM AdventureWorks.Person.Person">
                        <field column="BusinessEntityID" 
name="BusinessEntityID" />
                        <field column="NameStyle" name="NameStyle" />
                        <field column="Title" name="Title" />
                        <field column="FirstName" name="FirstName" />
                        <field column="MiddleName" name="MiddleName" />
                        <field column="LastName" name="LastName" />
                        <field column="ModifiedDate" name="ModifiedDate" />
                </entity>
    </document> 
                        
</dataConfig>
And schema file:

<fields>
<field name="BusinessEntityID" type="string" indexed="true" stored="true"
required="true"/>
<field name="NameStyle" type="string" indexed="true" stored="true"/>
<field name="Title" type="string" indexed="true" stored="true"/>
<field name="FirstName" type="string" indexed="true" stored="true"/>
<field name="MiddleName" type="string" indexed="true" stored="true"/>
<field name="LastName" type="string" indexed="true" stored="true"/>
<field name="Department" type="string" indexed="true" stored="true"/>
<field name="Age" type="string" indexed="true" stored="true"/>
</fields>
 <uniqueKey>BusinessEntityID</uniqueKey>

 <defaultSearchField>LastName</defaultSearchField>


We would appreciate your help!

Thanks!


--
View this message in context: 
http://lucene.472066.n3.nabble.com/Indexing-Multiple-Datasources-tp3988957.html
Sent from the Solr - User mailing list archive at Nabble.com.