Been quite a while since I've flown either, but from what I remember they're very similar to fly besides the obvious (DA-40 is a bit larger, has higher V speeds (not by much), etc). Either way, if you have DA-40 time, the "transition" will be relatively seemless.
I'll have to be the dissenter and say that these flybys always give me goosebumps, and I'm not even a Septic. If the RAF did this, I wouldn't care what it was.