I am creating a website for a county assessor and I need to be able to synchronize data from a Topspeed database (Topspeed application may be able to export to different database formats?) to a searchable online database. Ideally it would:
1.) Automatically sync nightly with the topspeed database which is uploaded to the server.
2.) Have a quick search that would search all fields and an advanced search which could search individual fields.
3.) Integrate well with a Joomla website.
The database also includes images which may be BLOB data, or may be separate files which are referenced by the database.