One requirement is that MSSQL data is regularly sent to my ECs instance on the client's pos server (XP system. We originally planned to use our server to regularly access the customer's machine, but the Internet was not accessible. Therefore, the current practice is to build a PHP environment on the client and use the xp scheduled task... one requirement is that MSSQL data is regularly sent to my ECs instance on the client's pos server (XP system.
We originally planned to use our server to regularly access the customer's machine, but the Internet was not accessible.
Therefore, the current practice is to build a PHP environment on the client, and use the xp scheduled task to execute the PHP program to send data to our server. This practice has many problems.
Now I plan to optimize this method. I plan to use Python for a Windows service. Upload client data to the server in the background. Can this be done? What is the key word of the Python knowledge point to learn?
Or is there any better way to execute this. Currently, only Python can be used in addition to PHP.
Reply content:
One requirement is that MSSQL data is regularly sent to my ECs instance on the client's pos server (XP system.
We originally planned to use our server to regularly access the customer's machine, but the Internet was not accessible.
Therefore, the current practice is to build a PHP environment on the client, and use the xp scheduled task to execute the PHP program to send data to our server. This practice has many problems.
Now I plan to optimize this method. I plan to use Python for a Windows service. Upload client data to the server in the background. Can this be done? What is the key word of the Python knowledge point to learn?
Or is there any better way to execute this. Currently, only Python can be used in addition to PHP.
This shell should be OK, export data, upload
Do not write services by yourself. In linux, cron is generally used for execution, and windows is no exception, including cron for windows. Cron registers a service. You just need to write your business logic as a shell and register it with cron.
Or there is another idea to write your shell as a long-running program.