Home
Main Introduction Features Constants Statements Database Objects Parser Serial-Communication Samples Misc
Database>Replicate records at real time
Caravan Business Server>Help>Database>Replicate records at real time
Syntax <CARAVAN>connection object(_location)=" server1,server2…."</CARAVAN>
<CARAVAN>connection object(_priority)=" priority"</CARAVAN>

Where server is a location defined in the hosts file and priority is any numeric value. Higher the number, higher will be the priority. Records replicated with higher priority will get replicated first.
Text Caravan Database server provides record based replication as well. You can also set a priority for database replication. Records with higher priority will get replicated first the records will a lower priority. You can use this feature to replicate a record as and when a record is inserted follow this method.
This method also can be used to take backup of the database on the standby server at real time.
Sample Replication to a single destination
<CARAVAN>
company(CompanyName)="Niti Telecom"
company(Address)="D-83/MIG Colony"
company(City)="Mumbai"
company(StateorProvince)="Maharashtra"
company(Country)="India"
company(Website)="http://www.nititelecom.com"
//replicate the new company added in another location
company(_location)="Florida"
//set a priority for replication
company(_lpriorityocation)="1"
// insert the record
company(insert)
</CARAVAN>

Replication to multiple destination
<CARAVAN>
//replicate the new company added to multiple locations
//set delimiter to insert multiple values
company(delim)=","
company(_location)="Florida,Georgia"
//set a priority for replication
company(_priority)="1"
//insert the record
company(insert)
</CARAVAN>
Back