I'm updating an old EE1 site that used to use matrix with a file field for downloadable files and a text field for the optional download text. I've successfully migrated the content into a new EE2.10 build and now have a grid field with an assets file field and the text box.
However, thinking about it, the grid is overkill because assets allows you to select multiple files, and the site admins were rarely completing the download text field in the grid.
My question is, how complex is it for me to move away from an assets field inside a grid, to a standalone assets field with multiple selections? I realise that a lot of this probably hinges on the exp_assets_selection table; could it be a case of updating the fieldtype to be assets (only) and some handy sql to iterate through exp_grid_field_x and somehow populate the exp_assets_selection table with the data it needs?
Anyone got any experience of doing this? Or is it a case of 'if it ain't broke...'? :)