Migration script to copy Joomla #__content to the the new Unified Content Model in Joomla 3.1 ucm_content tables, a migration ive done from joomla 2.5 to Joomla 3.1 did not migrate any data for me, that's why i did create the script. This is a required steps if you want to move from cedtag to joomla internal tagging solution: ucm_tables have to …

gistfile1.txt

truncate #__ucm_content;
INSERT INTO sd7c5_ucm_content 
(core_type_alias,
 core_title, core_alias,
 core_body,
 core_state,
 core_checked_out_time, core_checked_out_user_id,
 core_access,
 core_params,
 core_featured,
 core_metadata,
  core_created_user_id, core_created_by_alias, core_created_time,
 core_modified_user_id, core_modified_time,
 core_language,
 core_publish_up, core_publish_down,
 core_content_item_id,
 asset_id,
 core_images,
 core_urls,
 core_hits,
 core_version,
 core_ordering,
 core_metakey,
 core_metadesc,
 core_catid,
 core_xreference,
 core_type_id)
SELECT  
 'com_content.article',
 `title`, `alias`,
 CONCAT(`introtext`, ' ', `fulltext`),
 `state`,
 `checked_out_time`, `checked_out`,
 `access`,
 `attribs`,
 `featured`,
 `metadata`,
 `created_by`, `created_by_alias`, `created`, 
 `modified_by`, `modified`,
 `language`,
 `publish_up`, `publish_down`,
 `id`,
 `asset_id`,
 `images`,
 `urls`, 
 `hits`,
 `version`,
 `ordering`,
 `metakey`,
 `metadesc`,
 `catid`,
 `xreference`,
 '1'
FROM #__content`;

Thank you very, very much!

I think there is an extraneous ` on the final line, i.e. this:

FROM #__content`;

should really be this:

FROM #__content;