• Correct, as Gail mentioned, no script generation, or at least, not in one stage.

    Here's what I'd do.

    Set up the restore in the GUI, moving paths/folders as needed. Don't click "OK", click "Script" and save that.

    Run that.

    Once that's done, now plan out your changes to files. I'd again, do this in the DB properties dialog, make the changes and script them out. Now save that script, run it, and add it to your "restore" script.

    Now you will need to move the objects from old filegroups/files to the new ones. As you rebuild indexes or drop/create procs, save those items as part of your scripts. Note this is a point of maintenance. As you add objects, you'll be modifying this part of the script.

    Note that if you can start to do this in your source system, rearranging objects into filegroups there that you can restore and move here, it will get easier over time.