Okay, the Title and Caption are buried in the AgMRUList table. Problem is I haven't been able to hack the foreign key relationships to uniquely identify the rows that go with a particular image. The table contains a row for the caption and another row for the title, problem is the id_local fields for the two rows are different so I can't determine what ties the rows in AgMRUList to the rest of the image information.
anyone have any information on how the lr catalog is organized as far as the SQL tables?
You can use an existing plug-in to do this. The excellent LR/Transporter plugin (http://www.photographers-toolbox.com/products/lrtransporter.php) will allow you to export the metadat you want in a comma separated file, which you can then import into the database of your choice.