SAC Connection Transport from Test system to Prod

Hi Experts,

We are doing first time SAC transport to production system, and have a question.

Our story in test system is created on Hana live model based on calculation views. While doing the transport what is the best way to move the connection?

1) Using Content Network storage, move only the Story and the model to prod, then manually create a new live connection to production backend and edit the model to 'change datasource' to this connection?

2) OR transport the connection also from test system to Prod, and the edit this connection to point to the production backend system? - Not sure if this will work, as we didn't try it yet.

Please provide your inputs.