Your question is fairly broad, let me answer it step by step.
First of all $H(s)$ is indeed called the transfer function, and is the laplace transform of the impulse response. It's useful for finding the poles and zeroes, which is what the fourier transform can't do alone. $H(\omega)$ is the frequency response of the impulse response, not really the "transfer function".
If the frequency response is what you want to attain, then you can use the frequency response (fourier transform). It does not exist for unstable signals though.
The relation between Fourier Transform, discrete Fourier transform and Laplace transform/z-transform:
Fourier transform and DFT are in principle the same. One is for discrete signals, and the other for continuous signals. Because of that there are some different properties like frequency domain aliasing. What both of these transforms do is decompose the signal into complex exponentials (easily converted into sines and cosines (or sinusoids with magnitude and phase), which is the original idea).
Laplace and z-transform are again in principle the same, z-transform is the discrete equivalent to Laplace. It's simply the Fourier transform/DFT with the signal multiplied by a varying exponential $e^{\sigma t}$, or in discrete case just $r^t$. Then you have multiple fourier transforms/DFTs relating to each different value of the exponential ($r$ or $\sigma$). Point of interests are the poles and zeroes, IE. the points where the impulse response in question multiplied by an exponential has integral that is exactly infinite or exactly zero.
Note that when $r=1$, or $\sigma = 0$, the Laplace/Z-transform is equal to the Fourier transform. In other words, the Laplace/Z-transform contains the Fourier transform in it.
EDIT: I wrote this fairly quickly so please point out any errors.