Hi
I am in the process of migrating to a new PMS server -- but it it going to take a long time (week+) to transfer the data from the older server to the new. In the mean time, old content will be on the old server and new content (+ whatever old content has been copied) will be on the new server. Until everything is transferred, both servers will be in use.
What I want to do is sync the viewed/viewing information between the servers each night. I can't just copy the sqlite database files between the servers -- the new one has content in it that the old one doesn't ... but the new one has everything the old one does (and, more importantly, with the same metadata ids and accounts). I've disabled the whole "empty trash on rescan" bit just like if I had moved the library to a new location ... and as the files are copied over, they will start to be available.
Looking through the tables, it looks like the table I need is: metadata_item_views. Is this correct?
My current operating theory is that I should be able to select all the entries after the last sync id (currently 54115) in the old database and then insert them into the new database with a new id # (since the id number it has in the old might already be in use in the new -- new content + people watching on the new will make that more and more likely).
Do I have all the tables I need? Have I missed anything critical that will cause me pain and suffering?
Thanks.
