How much torque is involved? Makes a huge difference.

Really quick & easy, and easy to undo (unlike silver solder): a tack of
weld on the end, bridging the shaft & sprocket. Quick & Dirty (tm).

Roll pin or taper pin. If high torque. Whilst drilling for a pin, I
assure the alignment by doing the tack weld above & drilling both at once.

Bob