Difference between revisions of "Query Utils"
From OpenKM Documentation
| Line 6: | Line 6: | ||
select 'UPDATE OKM_CONFIG SET CFG_VALUE=''' || CFG_VALUE || ''' WHERE CFG_KEY=''' || CFG_KEY || '''' from OKM_CONFIG; | select 'UPDATE OKM_CONFIG SET CFG_VALUE=''' || CFG_VALUE || ''' WHERE CFG_KEY=''' || CFG_KEY || '''' from OKM_CONFIG; | ||
</source> | </source> | ||
| − | Tested: MySQL. | + | Tested: OpenKM (6.x) Database (MySQL). |
[[Category: Migration Guide]] | [[Category: Migration Guide]] | ||
Revision as of 08:28, 7 September 2012
Here are some queries that could be usefult for migration.
Save OKM_CONFIG table values
Creates update script with actual OKM_CONFIG table values to be restored in new OpenKM database;
select 'UPDATE OKM_CONFIG SET CFG_VALUE=''' || CFG_VALUE || ''' WHERE CFG_KEY=''' || CFG_KEY || '''' from OKM_CONFIG;
Tested: OpenKM (6.x) Database (MySQL).
