Hello,
some times ago I migrate/move one of our APM Environments to a new location.
In the past we use a new/empty DB all the time (the Triage Map DB contain no settings or configuration data), but the DB used by the Teamcenter contain several user specific and public Perspectives, Universes and several Experience View Cards, Attribute Rules and Security Token.
Unfortunately there is no way to export all these settings, hence I spent some time to have a look to the DB initialization scripts and the DB.
In a sort summary, I use "pg_dump" to export the tables "public.appmap_settings" and "public.appmap_api_keys" in the "insert" format and insert these data into the new/clean DB used by the new environment.
It is important to start (and stop) the APM environment (EM, WV, PGSQL) before you import the old data, because some settings are stored/created in an empty database only at the first startup.
This was the most easy way to get all the data back in the new environment and the used "insert" format was easy to handle, I do some manual modifications thereby. I removed the defaults are created automatic all the time the EM find a new DB, these are two Experience View Cards, eight default Perspectives and a default Universe (and I removed all the data deleted in the past, see column "deleted_at" in table "public.appmap_settings").
We got no problems, the Security Token are useable, but I find error messages like this in the EM log.
6/10/17 08:36:34.217 PM MESZ [ERROR] [btpool0-7] [Manager.AppMap] Cannot create sample for tokenId 100
But, in general it is not necessary to import the "public.appmap_api_keys" tables, you can create new keys.
This was the most easy way to move an environment.
Have a look to the post from Lynn, he add some usefull links and some more detail information.
With regards,
Lutz