Many thanks to MrG and Peter,

I shall experiment with option 1 and option 2 in our environment to see which one is the most suitable for our requirements.

Thanks again.