Support SQL Azure as a PI AF SQL backend
As an administrator, I want to use SQL Azure as the database backend for my PI AF databases, so that I can offload the SQL adminstrative tasks to Azure.
I agree with Amit and BartM here. For our case it is very important that we are not bogged down with maintaining database in Azure as IaaS solution. The press to move into cloud really shows the need for an official support from OSIsoft on Azure SQL Managed Instance.
Agree with BartM, supporting Azure SQL can reduce our total cost of ownership.
BORIS GLAZMAN commented
A global Flexible Foams, Bedding, Insulation and Automotive manufacturer based in Belgium is looking for support of Managed Instance of MS SQL server for their Azure deployment of AF. All of their SQL servers are being moved to MI on Azure.
I would like to understand what is OSIsoft direction on making PI AF compatible with SQL hosted on Azure as PaaS or SQL Managed Instance.
I belive this is the direction many companies are also heading towards where they want to invest time/money on getting value out of the data than spending part of it in managing/storing the data.
Having SQL server in a SaaS model offers many advantages over a hosted database on Premise or in Azure VM (IAAS model) : Upgrades, patching, back-up, Disaster / recovery (using High Availability for PI). It is clear for me MicroSoft is taking the direction of Managed Instance. On premise databases will of course not disappear any time soon. Business wants to invest in skills to exploit the data , not to store them
would more than welcome this feature! We would like to focus on our core task (data analysis and turning data into value) keeping servers into the air, taking backups etc is not our core business, so would be a big plus if we could use (as for all our other sql databases, SQL Azure - Azure SQL managed Instance if needed. Making PI AF compatible with SQL Azure manged instance should not be a big deal for OSISoft. Thanks for giving this the right prioirty.
Can you tell me what you hope to achieve with SQL Azure? Is it a management consideration or IT requirement or ???
Is this improvement still discussed?
We are using PI System on Azure VMs.
We had experienced many works and troubles on SQL Server instances and really want to use Azure SQL Database(Managed service) instead of SQL Server on VM.
Microsoft have a new option now with Managed SQL Servers that would probably be easier implemented (as it's just a SQL Server that MS manages the SO).