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
Super User
Super User

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
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Ideas

Check out the New Ideas Site

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (5,321)