Migrate from SQL Onpremise (Datagateway) to Azure SQL

(1) Share

Report

Posted on by Warren-GenPoint

Hi,

We are in the process of considering moving an on-premises sql database to azure sql.

We have some PowerApp solutions that make use of a data gateway to connect to the on-premises SQL, but it does mean our PowerApps would need to be updated. Is there an automated or "easy" was to do this migration and keep our connections intact?

I did find this one article from 2018 which someone responded and said it currently wasn't possible; I am hoping, 6 years later things go better :-) Migration from SQL server to Azure SQl as well as Company1 O365 to Comapny2 O365

Thanks

Warren

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

SaiRT14 1,990 Super User 2025 Season 1 on at

Like (1)

Report
Copy link

Link copied!
here are the steps, try and let me know.

Migrate SQL database to Azure SQL using Azure Data Migration Service (DMS) or .bacpac.

Add a new Azure SQL connection in PowerApps.

Replace on-premises SQL connection with Azure SQL in PowerApps using "Replace Connection."

Test and validate app functionality with the new Azure SQL connection.

Sync data incrementally using Azure Data Factory to minimize downtime.

Remove reliance on the on-premises data gateway, if applicable.

Reconfigure Power Automate flows or related dependencies.

Monitor app performance and resolve post-migration issues.

Was this reply helpful? Yes No
Warren-GenPoint 55 on at

Like (0)

Report
Copy link

Link copied!

Thanks @SaiRT14, I will give those steps a try, we can do this in a test environment, we are currently in planning stages, so will consider these steps as part of teh workflow.

Was this reply helpful? Yes No