Just in the midst of a K2 4.7 DB Restore to a new server and i noticed that the hostserver.updatehistory table still shows the original source server patches, are these saved anywhere in the K2 DB or do they manually have to still be installed on top of K2 4.7?
I do not think restoring K2 database takes across any Patches, CU, Codefixes to another server.
It takes K2 artifacts(workflows, smartobject and forms), the reason you seen the hostserver.updatehistory is becasue it get created as any other table, so all the data on the databse will be restored on the new server including the table hostserver.updatehistory.
Please see belong documentation on more information with regards to restoring K2 database.
see extract below from the article above:
Just to add to Themba's point, yes he is correct as with fixpacks dlls on the actual environment are placed in specific directories. So yes it will be best reapply the fixpacks & CU's to the environment where the DB will placed after. This should only do after the reconfiguration of via the set up manager.
Please see below screen shot from the CU update documentation.
Link to the documentation:https://help.k2.com/kb002261
It doesnt seem like that table contains any dependancies, i believe (especially for 4.7) you should be able to delete all the records from the table and new entries will be added once you run the Cumilitive Update and/or Fix Packs.
I did a check and saw no issues when removing those records and then installing the latest CU / FP.