Changing Connection to different SQL Servers

(0) Share

Report

Posted on by JoeJohnCards

We have different environments for our apps, DEV, QA, STAGE, PROD.

For each environment we have a separate SQL Database.

When creating an app in DEV we connect to the DEV SQL Database.

The issue comes up when "promoting" the app from DEV to QA (QA to STAGE and so on).

Once the app is in the QA environment we have to drop the connection to the DEV SQL Database and connect to the QA SQL Database.

Even though both servers have the same exact table names, we're having to "re-connect" every single field on each of the screens (Browse, Detail, Edit). This is done by deleting the table name within the formula bar, start typing it out again, then select it from the dynamic dropdown.

Surely there is a better way to switch databases. Does anyone know?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @JoeJohnCards ,

You can remove the connection on Data Source panel and create the new one, all related table and column names will adjust to the new connection automatically.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
JoeJohnCards 15 on at

Like (0)

Report
Copy link

Link copied!

It works now. Looks like it was because we had a different database name on the different servers. Once we had the same database name it worked just like you said @v-jefferni

Was this reply helpful? Yes No
Flischewski1 9 on at

Like (0)

Report
Copy link

Link copied!

Can you please show how this is done? We have 2 environments (DEV & PROD) and secure the connection via "Azure AD Integrated". For me the only option is to remove all tables and create new connections to all tables one by one. Is there a better option?

Was this reply helpful? Yes No