I tend to forget how to insert into another table from selecting the data form another table so here is an upgrade snippet for next time.
INSERT INTO [FieldExplorer].[dbo].[Field_Guide_Annotations]
([Record_ID],[Value],[Type],[Table_ID])
Select [Id], [Definition], 0,6
From [FieldExplorer].[dbo].[Field_Details]
Where [Definition] is not NULL