Can someone provide me with the tables that apply for Knowledge Managment? Thanks!

[Rocio Carolina Grillo]

We are trying to migrate our knowledge module to prod, and we need to identify the fields associated with this module.

This will help us also to get the right way to create the documents in o rder to have a good response from the report tool.

 

Thanks!

[JEROME MAYER]

Hi,

Majority of KB tables are prefixed with kt, kd  with the main table be the skeletons table

 

That say the I will strongly recommend you to move your KB data using the export/import function vs. doing anything in the mdb directly with high risk of corrupted data at the end

 

My 2 cents

/J

[Chi Chen]

Rocio, SDM/KT use the following tables for knowledge documents:

ADMIN_TREE

BU_TRANS

CI_ACTIONS

CI_ACTIONS_ALTERNATE

CI_BOOKMARKS

CI_DOC_LINKS

CI_DOC_TEMPLATES

CI_DOC_TYPES

USP_PREFERENCES

CI_PRIORITIES

USP_PROPERTIES

CI_STATUSES

CI_WF_TEMPLATES

EBR_ACRONYMS

EBR_DICTIONARY

EBR_DICTIONARY_ADM

EBR_FULLTEXT

EBR_FULLTEXT_ADM

EBR_LOG

EBR_METRICS

EBR_NOISE_WORDS

EBR_PATTERNS

EBR_PREFIXES

EBR_PROPERTIES

EBR_SUBSTITS

EBR_SUFFIXES

EBR_SYNONYMS

EBR_SYNONYMS_ADM

ES_CONSTANTS

ES_NODES

ES_RESPONSES

ES_SESSIONS

INDEX_DOC_LINKS

KD_ATTMNT

kdlinks

LONG_TEXTS

O_INDEXES

P_GROUPS

SHOW_OBJ

SKELETONS

///////////////////////////////////////////////////////

Technical Reference Guide has some info on what fields

of tables are and how they are related. I post them here for

better understanding of the tables of the KT module not

intend for you to manually extract from one env and load to

another. You would need to use KT import/export utility for

same level env move or follow the standard procedure to migrate from one version to a later one. Thanks _Chi