# Migrate users watched status from one server to another **URL:** \ **Category:** Plex Media Server\ **Tags:** server-docker\ **Created:** [April 29, 2021, 8:40am UTC](https://forums.plex.tv/t/migrate-users-watched-status-from-one-server-to-another/712724 "2021-04-29T08:40:10Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![KaMoS](https://avatars.discourse-cdn.com/v4/letter/k/ea666f/32.png) [@KaMoS](https://forums.plex.tv/u/KaMoS)\ **Post date:** [April 29, 2021, 8:40am UTC](https://forums.plex.tv/t/migrate-users-watched-status-from-one-server-to-another/712724/1 "2021-04-29T08:40:10Z")
Server Version#: 1.22.3.4392 Player Version#: 1.31.0.2254-43df1e6e OS: Ubuntu 18.04 (Docker) I have a separate server and PMS for my friends and family. I don’t want to maintain two servers, so I would like to ‘merge’ the two. Both servers using the same network attached storage. I want to have the merged server to retain the user “watched” status for each user. What I’d like to do is add all the users to one of the existing servers. Somehow move all the watched statuses for all the migrated users. Is there a way to do this? ---
**Author:** ![anon5074910](https://avatars.discourse-cdn.com/v4/letter/a/db5fbb/32.png) [@anon5074910](https://forums.plex.tv/u/anon5074910)\ **Post date:** [April 29, 2021, 8:41am UTC](https://forums.plex.tv/t/migrate-users-watched-status-from-one-server-to-another/712724/2 "2021-04-29T08:41:57Z")
I think this will work but haven’t tried it myself so cannot speak for how accurate or successful the process is… > **[Move Viewstate/Ratings from One Install to Another | Plex Support](https://support.plex.tv/articles/201154527-move-viewstate-ratings-from-one-install-to-another/)** > > The watched/unwatched, view progress, and ratings are stored in an install-independent fashion that makes them easy to move between installations... ---
**Author:** ![KaMoS](https://avatars.discourse-cdn.com/v4/letter/k/ea666f/32.png) [@KaMoS](https://forums.plex.tv/u/KaMoS)\ **Post date:** [April 29, 2021, 8:44am UTC](https://forums.plex.tv/t/migrate-users-watched-status-from-one-server-to-another/712724/3 "2021-04-29T08:44:52Z")
I don’t think this will work. This method is moving the DB from one server to another. I need a way to ‘merge’ the databases. ---
**Author:** ![OttoKerner](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/ottokerner/32/10079_2.png) [@OttoKerner](https://forums.plex.tv/u/OttoKerner)\ **Post date:** [April 29, 2021, 10:18am UTC](https://forums.plex.tv/t/migrate-users-watched-status-from-one-server-to-another/712724/4 "2021-04-29T10:18:05Z")
> [@KaMoS](#): > > This method is moving the DB from one server to another. No, it’s not. It is just copying the contents of _one_ table. But yes, you will have to filter out the lines for your own user account (if you have played anything from this server) so only the “play” events of your friends/family will be imported. Note that this will only work for media which are “matched”. Unmatched media like photos, or personal videos do have different IDs on different servers, so the “play”-events you are importing don’t fit. ---
**Author:** ![hthighway](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/hthighway/32/82003_2.png) [@hthighway](https://forums.plex.tv/u/hthighway)\ **Post date:** [April 29, 2021, 2:46pm UTC](https://forums.plex.tv/t/migrate-users-watched-status-from-one-server-to-another/712724/5 "2021-04-29T14:46:22Z")
See this thread, if you want to merge the watched status from two servers > [@How to combine watch history from two servers using sqlite?](https://forums.plex.tv/t/how-to-combine-watch-history-from-two-servers-using-sqlite/686259/8): > > The following should work- $ sqlite3 com.plexapp.plugins.library.db then sqlite\> .mode insert sqlite\> .output watch.sql sqlite\> SELECT account\_id, guid, rating, view\_offset, view\_count, last\_viewed\_at, created\_at, updated\_at, skip\_count, last\_skipped\_at, changed\_at, extra\_data, last\_rated\_at FROM metadata\_item\_settings; will give you a file watch.sql with the auto incrementing index value removed INSERT IN… But make sure you read to the end as I updated one of the steps ---
**Author:** ![KaMoS](https://avatars.discourse-cdn.com/v4/letter/k/ea666f/32.png) [@KaMoS](https://forums.plex.tv/u/KaMoS)\ **Post date:** [April 29, 2021, 9:32pm UTC](https://forums.plex.tv/t/migrate-users-watched-status-from-one-server-to-another/712724/6 "2021-04-29T21:32:13Z")
Thanks. I’ll give this a shot. ---
**Author:** ![system](https://global.discourse-cdn.com/plex/original/3X/2/a/2acb9765406f63293d357b4ec509ec39aa28f2ad.png) [@system](https://forums.plex.tv/u/system)\ **Post date:** [July 28, 2021, 9:33pm UTC](https://forums.plex.tv/t/migrate-users-watched-status-from-one-server-to-another/712724/7 "2021-07-28T21:33:05Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.