LS tranny swap?

My brother has really been looking into boosting his 95 integra, but before he does, he wants to either convert the tranny from auto to stick, or should he swap the whole engine with tranny and all? is converting to stick hard..how much $ are we looking at? any input would be greatly appreciated.