I just started a trial instance of SQL Server on Azure.
My question is whether it is possible to upload a VFP exe into a Storage account on Azure and have it run from a local browser.
I have this app that produces payroll receipts. I can generate the payroll receipts for each employee in a pdf format and would like to lodge them somewhere on Azure. The SQL Server on Azure contains all the data to generate the receipts on demand. So any employee, with hi/her applicable password could access the VFP exe and visualize their monthly payment receipt from his/her home just using a browser.
I know it should be possible to do it with a VM, lodging a SQL Server instance on it and my app's exe, but my client does not want to pay for the VM, just use the above option.
Is it at all possible? if so,how? Any leads?
TIA
Rafael Copquin
Apparently it is possible to use the 'Azure Files' type of storage to provide a cloud-based shared folder that on-premise Windows can access, map a drive letter to and so forth.
It is also apparently possible to then run an EXE off that share as long as you are using SMB3, so Windows 8 and up. However I would envision a potential world of hurt with permissions and so on.
If the data is in Azure SQL this is really a job for a browser-based front end. Maybe you could knock something up in a low-code tool like PowerApps to do it.
Azure is fairly feature rich with respect to what kind of VM you want to deploy. Windows of Linux many flavors of each and you can add on disk space as you see fit. Want to reduce your costs, place that VM in a cheaper area of the world compared to USA East coast.
I am working on certifications with Azure now as wanting to learn something new in the COVID time frame. They are much better today at stating costs for your decisions then you get the bill with that shopper of a line item. Just like AWS allowing you to do everything Windows, Azure allows you to do everything Linux.
.NET Core 3 is now out. That is writing code to run in a non windows or a windows environment.
On Sat, Jun 27, 2020 at 10:04 AM Alan Bourke alanpbourke@fastmail.fm wrote:
Apparently it is possible to use the 'Azure Files' type of storage to provide a cloud-based shared folder that on-premise Windows can access, map a drive letter to and so forth.
It is also apparently possible to then run an EXE off that share as long as you are using SMB3, so Windows 8 and up. However I would envision a potential world of hurt with permissions and so on.
If the data is in Azure SQL this is really a job for a browser-based front end. Maybe you could knock something up in a low-code tool like PowerApps to do it.
-- Alan Bourke alanpbourke (at) fastmail (dot) fm
[excessive quoting removed by server]
-This sounds roughly similar to SQL Server on a lan - when I was working on that sort of setup I found it best to have the exe's on the users' machines - there's plenty of stuff in the archives on how to check for updates and download new versions.
On 26-Jun-20 6:59 PM, Rafael Copquin wrote:
I just started a trial instance of SQL Server on Azure.
My question is whether it is possible to upload a VFP exe into a Storage account on Azure and have it run from a local browser.
I have this app that produces payroll receipts. I can generate the payroll receipts for each employee in a pdf format and would like to lodge them somewhere on Azure. The SQL Server on Azure contains all the data to generate the receipts on demand. So any employee, with hi/her applicable password could access the VFP exe and visualize their monthly payment receipt from his/her home just using a browser.
I know it should be possible to do it with a VM, lodging a SQL Server instance on it and my app's exe, but my client does not want to pay for the VM, just use the above option.
Is it at all possible? if so,how? Any leads?
TIA
Rafael Copquin
-
Alan Bourke -
AndyHC -
Rafael Copquin -
Stephen Russell