My rough draft of the ExpressionEngine 1 » 2 upgrade process.

ExpressionEngine 1 » 2 Upgrade

- Update all Modules, Extensions & Fieldtypes to latest versions.
- Uninstall Structure, Publish Tweaks & Safe Segments, Low NoSpam.
- LG Better Meta - http://ee-garage.com/nsm-better-meta/user-guide#toc-updating_lg_better_meta
- Plan the nGen File Field SQL Queries. Example below.
- Change all nGen fields to 'text' to ensure data isn't loss..
- Templates to DB manually turn off save as file and update.
- Remove all Cache.
- Back Up everything.
- Update to EE2.
- Updated all Modules & Extensions to EE2 versions.



nGen File Field Information
===============================

Upload Directories
===================
1		Main Upload Directory
2		Student Work Images
3		Blog Images


Matrix Cols
(col/field/upload)
===================
4		12		2		Course Content Image 1
5		12		2		Course Content Image 1
8		43		2		Work Example
11		39		2		Work Example
16		41		2		Work Example
21		37		2		Work Example
28		33		2		Work Image
31		35		2		Work Image
38		45		2		Work Example
43		47		2		Work Example
50		49		1		People Photo
66		56		2		Courses Left Image
68		61		1		Success Example
69		61		1		Success Photo
70		62		2		Success Work
72		65		2		Featured Work
76		/		3		Blog Intro Image
80		/		3		Blog Image Upload
87		/		1		Industry Logo
88		/		1		Grad Photo
90		/		2		Student Work
91		/		2		Student Work
93		/		1		Studio Image
65		/		1 		Contact Image


Regular Fields
(field/upload)
===================
74		1		Header Background Image


SQL Queries
===================
UPDATE exp_channel_data
SET field_id_74 = CONCAT('{filedir_1}', field_id_74)
WHERE field_id_74 != ''
AND field_id_74 NOT LIKE '{filedir_%'

UPDATE exp_matrix_data
SET col_id_4 = CONCAT('{filedir_2}', col_id_4)
WHERE col_id_4 != ''
AND col_id_4 NOT LIKE '{filedir_%'

UPDATE exp_matrix_data
SET col_id_5 = CONCAT('{filedir_2}', col_id_5)
WHERE col_id_5 != ''
AND col_id_5 NOT LIKE '{filedir_%'

UPDATE exp_matrix_data
SET col_id_8 = CONCAT('{filedir_2}', col_id_8)
WHERE col_id_8 != ''
AND col_id_8 NOT LIKE '{filedir_%'

UPDATE exp_matrix_data
SET col_id_11 = CONCAT('{filedir_2}', col_id_11)
WHERE col_id_11 != ''
AND col_id_11 NOT LIKE '{filedir_%'

UPDATE exp_matrix_data
SET col_id_16 = CONCAT('{filedir_2}', col_id_16)
WHERE col_id_16 != ''
AND col_id_16 NOT LIKE '{filedir_%'

UPDATE exp_matrix_data
SET col_id_21 = CONCAT('{filedir_2}', col_id_21)
WHERE col_id_21 != ''
AND col_id_21 NOT LIKE '{filedir_%'

UPDATE exp_matrix_data
SET col_id_28 = CONCAT('{filedir_2}', col_id_28)
WHERE col_id_28 != ''
AND col_id_28 NOT LIKE '{filedir_%'

UPDATE exp_matrix_data
SET col_id_31 = CONCAT('{filedir_2}', col_id_31)
WHERE col_id_31 != ''
AND col_id_31 NOT LIKE '{filedir_%'

UPDATE exp_matrix_data
SET col_id_38 = CONCAT('{filedir_2}', col_id_38)
WHERE col_id_38 != ''
AND col_id_38 NOT LIKE '{filedir_%'

UPDATE exp_matrix_data
SET col_id_43 = CONCAT('{filedir_2}', col_id_43)
WHERE col_id_43 != ''
AND col_id_43 NOT LIKE '{filedir_%'

UPDATE exp_matrix_data
SET col_id_50 = CONCAT('{filedir_1}', col_id_50)
WHERE col_id_50 != ''
AND col_id_50 NOT LIKE '{filedir_%'

UPDATE exp_matrix_data
SET col_id_66 = CONCAT('{filedir_2}', col_id_66)
WHERE col_id_66 != ''
AND col_id_66 NOT LIKE '{filedir_%'

UPDATE exp_matrix_data
SET col_id_68 = CONCAT('{filedir_1}', col_id_68)
WHERE col_id_68 != ''
AND col_id_68 NOT LIKE '{filedir_%'

UPDATE exp_matrix_data
SET col_id_69 = CONCAT('{filedir_1}', col_id_69)
WHERE col_id_69 != ''
AND col_id_69 NOT LIKE '{filedir_%'

UPDATE exp_matrix_data
SET col_id_70 = CONCAT('{filedir_2}', col_id_70)
WHERE col_id_70 != ''
AND col_id_70 NOT LIKE '{filedir_%'

UPDATE exp_matrix_data
SET col_id_72 = CONCAT('{filedir_2}', col_id_72)
WHERE col_id_72 != ''
AND col_id_72 NOT LIKE '{filedir_%'

UPDATE exp_matrix_data
SET col_id_76 = CONCAT('{filedir_3}', col_id_76)
WHERE col_id_76 != ''
AND col_id_76 NOT LIKE '{filedir_%'

UPDATE exp_matrix_data
SET col_id_80 = CONCAT('{filedir_3}', col_id_80)
WHERE col_id_80 != ''
AND col_id_80 NOT LIKE '{filedir_%'

UPDATE exp_matrix_data
SET col_id_87 = CONCAT('{filedir_1}', col_id_87)
WHERE col_id_87 != ''
AND col_id_87 NOT LIKE '{filedir_%'

UPDATE exp_matrix_data
SET col_id_88 = CONCAT('{filedir_1}', col_id_88)
WHERE col_id_88 != ''
AND col_id_88 NOT LIKE '{filedir_%'

UPDATE exp_matrix_data
SET col_id_90 = CONCAT('{filedir_2}', col_id_90)
WHERE col_id_90 != ''
AND col_id_90 NOT LIKE '{filedir_%'

UPDATE exp_matrix_data
SET col_id_91 = CONCAT('{filedir_2}', col_id_91)
WHERE col_id_91 != ''
AND col_id_91 NOT LIKE '{filedir_%'

UPDATE exp_matrix_data
SET col_id_93 = CONCAT('{filedir_1}', col_id_93)
WHERE col_id_93 != ''
AND col_id_93 NOT LIKE '{filedir_%'

UPDATE exp_matrix_data
SET col_id_95 = CONCAT('{filedir_1}', col_id_95)
WHERE col_id_95 != ''
AND col_id_95 NOT LIKE '{filedir_%'