I'm just getting started looking at Powerapps. I'm trying to figure the pros/cons of using CDS vs. Azure SQL Server. My application is small, basically 3 tables (entities) with less than 200 records in each table. Less than 2Mb DB. From a cost perspective a low end Azure SQL Server instance is less than $10/month. For CDS I need a Powerapps Plan 2 and around 5 Powerapps Plan 1 licenses so around $75/month.
The process I want to automate is surprising complex with lots of steps, tasks, emails etc. It has a lot of date calculations with many of them being Business days from a certain date. I have yet to figure that out in CDS or Powerapps. I can do that with a trigger or stored procedure in SQL Server. If I find any other limitations I can always resort to T-Sql or T-Sql can call a C# program.
Can someone better help me understand pros/cons?
Solved! Go to Solution.
I am strongly for Azure SQL Database. Current CDS is still lacking many things to replace SQL Database.
Check out my post in this thread on why I think Azure SQL is better than CDS.
Hi @mogulman52
Azure SQL would also be my database of choice. Here's my take on this....
CDS
The main benefit of the CDS is that it's simple to use. For non-developers, these benefits include:
SQL Azure
In addition to the benefits that you and @Anonymous mention, I would add....
In your post, you mention triggers. Please note that if you add a trigger to table, you won't be able to update that table from PowerApps. This thread here contains more details.
I am strongly for Azure SQL Database. Current CDS is still lacking many things to replace SQL Database.
Check out my post in this thread on why I think Azure SQL is better than CDS.
I agree, we use Azure SQL.
I hope Powerapps team continue improving PowerApps functionality for MS SQL.
Most companies use SQL and it would be really hard for them to migrate their data to CDS
Appreciate your comment. Thanks. I see several benefits to Azure SQL Database:
1. Cost as you mention
2. Deployment
3. Ability to use T-SQL for flow or other automation
4. T-SQL can call C#
I'm trying to figure out the pros for CDS. I'm recommending we use Azure SQL database and I want to be sure I've considered everything.
Hi @mogulman52
Azure SQL would also be my database of choice. Here's my take on this....
CDS
The main benefit of the CDS is that it's simple to use. For non-developers, these benefits include:
SQL Azure
In addition to the benefits that you and @Anonymous mention, I would add....
In your post, you mention triggers. Please note that if you add a trigger to table, you won't be able to update that table from PowerApps. This thread here contains more details.
Thanks @timl for your feedback. I'm confused on the trigger issue. If you read this article that is referenced in the thread you sent me it appears to be related to on premises SQL Servers. I plan to use an Azure SQL Server. I wonder it works on that.
Hi @mogulman52,
The problem with triggers applies also to Azure SQL Server.
I'd also recommend reading this great post by @Meneghino, which covers all of the issues that you'll likely encounter with Azure SQL.
User | Count |
---|---|
221 | |
98 | |
95 | |
55 | |
34 |
User | Count |
---|---|
273 | |
107 | |
105 | |
60 | |
60 |