This program adds the update and upgrade function of the SQL database to the upgrade program of netizen vagrant. The system uses ACCES to store data update instructions, so as to achieve the function of gradually executing the SQL code, because tables and stored procedures need to be created in SQL. , views and other objects, the original old objects need to be deleted, but SQL does not support storing these instructions together, resulting in errors. So ACCES is used to store data.
In this example, p_killspid will be created in MASTER. This program process is part of the process used to restore and back up data.
MENTOROUSER.INI is the data service address. A netizen once asked me how to create a service login system. This file is the key. Please refer to the code for the specific connection.
SQLTEXT.MDB is a file used for database update. Please modify the records by yourself, but the order of records must be added according to the order of instructions.
mentoro.htm is a file stored on the website, you can change the specific content yourself. (You can also use an INI file)
CHIS.INI is the updated configuration file (for other files and contents, please see the vagrant program in the box)
Thanks to vagrant for the program and code, thank you!
Expand
