Depending if historical correctness is important or not - I agree peening will work, or drill and tap the sight, put a small set screw in. Then at the range put some red locktite in the dovetail, install sight and screw, testfire, adjust ( you have approx 10 min) and then let harden..... I guess...