How to convert an MODX articles container to a MODX collections container...

article2collections.sql

# switch ArticlesContainer -> CollectionContainer
# the res. ID I want to migrate is 11
 
UPDATE `modx_site_content` SET `class_key` = replace(class_key, 'ArticlesContainer', 'CollectionContainer') WHERE id=11;
 
# switch class_key to go back to default document view for children
 
UPDATE `modx_site_content` SET `class_key` = replace(class_key, 'Article', 'modDocument') WHERE parent=11;
 
# Change template 49 -> 57
 
UPDATE `modx_site_content` SET `template` = replace(template, '49', '57') WHERE parent=11;

A little less is more (you only have to change the template id - if needed):

UPDATE `modx_site_content` SET `class_key` = 'CollectionContainer' WHERE `class_key` = 'ArticlesContainer';

UPDATE `modx_site_content` SET `template` = '57' WHERE `class_key` = 'Article';

UPDATE `modx_site_content` SET `class_key` = 'modDocument' WHERE `class_key` = 'Article';