Unanswered

How to switch SQL database when import managed solution to another environment

(0) Share

Report

Posted on by hongkong

277

I have a Power Automate flow connected to SQL server database with Azure AD integration. In the solution I have created a connection reference and it works well in the development environment.

Now I need to export the solution to a managed one and then import to our production environment. During import I can "switch user" (for example switch from my account to a service account) but I CANNOT change the SQL server name and database name.

After import, I cannot update the connection reference because it is managed (read only).

Beside importing an unmanaged solution, any work around suggestion? Thanks.

Categories:

Using connectors

I have the same question (0)

All responses (2)

Answers (0)

Kaif_Siddique 2,108 Super User 2024 Season 1 on at

Like (0)

Report

Are you hard coding server name? if yes, try to use variable to pass the server details and export the solution.

Was this reply helpful? Yes No
guillermoarraba 2 on at

Like (0)

Report

Hi @Kaif_Siddique
In my case I tried this approach but it breaks the flow, for some reason the flow is not able to identify the server and database name.
I am trying to execute a stored procedure but changing the server as it is different between DEV-UAT-PROD
Any additional recommendation?

Was this reply helpful? Yes No