cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
claz
Frequent Visitor

Power App SQL connection, moving from on-prem to Azure. How to update connection

Hi there.

 

I have a Power App (and Flows) that uses an SQL connection to an on-prem SQL database.

This database is going to be migrated to Azure.

I'm wondering how simple is the process of updating the connection to point to Azure.

Is it as simple as going into the connection, clicking Edit, entering in the server and DB details + login details?

 

Or will I need to go into all apps and Flows that use this connection and change them to a new connection?

 

Thanks!

2 REPLIES 2
v-xiaochen-msft
Community Support
Community Support

Hi @claz ,

 

At my knowledge , you need to create a new connection and this connection is explicit. It is not shareable connection.

vxiaochenmsft_0-1653359326377.png

 

Best Regards,

Wearsky

Shujaath_Khan
Solution Sage
Solution Sage

Hi @claz 

 

This is a similar step compared to what you do with on-prem where you've to configure the gateway as well in Azure it's no more needed and you can leave it blank.

If you're looking for implicit mode then you can surely use SQL username & password-based authentication.

 

Also, recommend have to look at Connection references if you are using a solution

ref: https://docs.microsoft.com/en-us/power-apps/maker/data-platform/create-connection-reference

you need to refresh once the connection references from the old to the latest ones so that points to new server

shujaathkhan_3-1654146993165.png

shujaathkhan_4-1654147067749.png

 

 

 

 

 

 

 

 

Thanks

 

 

Helpful resources

Announcements
Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

<
Users online (3,816)