Yes we sang the Schubert tune and a translation similar to keberoxu's at Secondary school. New National Song book possibly. Though I remember the refrain as
Rosebud, pretty rosebud red.
I know the Heinrich Werner tune as a solemn Communion hymn (Baptist Hymnal) so it feels a bit incongruous that there is also a Pat Shaw dance set to it. Some 'English Dancers' in the US don't feel comfortable with the dance because of the words of the song.

Which could drift the thread who knows where.