Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
Announcing Mentions and Quick Responses!
Give Back to the Community this Month
Join us in the Community for an AMA: December 12th Register Today
News and Announcements icon
Power Platform Community / Forums / Power Apps - Power Apps Pro Dev & ISV / Migrate from SQL Onpre...
Power Apps - Power Apps Pro Dev & ISV
Answered

Migrate from SQL Onpremise (Datagateway) to Azure SQL

(1) ShareShare
ReportReport
Posted on by Warren-GenPoint 55
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:
Application Lifecycle Management (ALM)
Power Platform Build Tools
  • Warren-GenPoint Profile Picture
    Warren-GenPoint 55 on at
    Migrate from SQL Onpremise (Datagateway) to Azure SQL
    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.
  • Verified answer
    SaiRT14 Profile Picture
    SaiRT14 1,216 on at
    Migrate from SQL Onpremise (Datagateway) to Azure SQL
    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.
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities
Announcing Mentions and Quick Responses!
Give Back to the Community this Month
Join us in the Community for an AMA: December 12th Register Today

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

more Community News

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,246

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,884

Leaderboard

Featured topics

Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)

Product updates

Microsoft Power Platform Community release plans