Moving Solutions with On Premise Gateway connections between enviornments

[datahelpme]

Hello, I have built an app that has an on premise sql connection as well as about 10 flows that use that connection. When moving between environments I am required by my team to provide a managed solution. In order for the solution to be imported into an environment, I understand that the connections and flows would need to be removed from the solution and added back upon import. What would be the easiest way to go about this? My connection and flows live in environment dev where the owner of that environment is the one importing the solution into environment prod. I am not able to touch the solution in the prod environment and can not add the connections back. I have shared the flows and connection with the user who is in charge of the importing, will they be able to add the connection and flows from the dev environment into the prod environment ? Or would I have to create them again in this new environment? How should I go about getting the references back in there?

[Velegandla]

@datahelpme 

You don't have to remove the connections to the flows in development environment.

When someone who got privileges in Prod and access to the data sources they should be asked to connect again via connection references.

https://benediktbergmann.eu/2022/02/08/connections-and-connection-references-explained/ 

====================================================

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

https://www.linkedin.com/in/devendravelegandla/ 

[datahelpme]

It is an on premise sql connection. They were asked to re create the connection when the solution was being imported and based this link we had to remove the connection to import the solution Import solutions - Power Apps | Microsoft Learn. Then all of our flows use this connection, so they had to be removed as well or this error occurred