主权项 |
1. A computer-readable storage medium storing executable instructions, which, when executed, cause a mobile computing device and a server to perform a method for synchronizing a client-side database on the mobile computing device and a server-side database on the server, the computer-readable storage medium comprising:
instructions on the server that provide a graphical user interface that receives selections from a user identifying tables, fields and indexes of the server-side database to be synchronized with the client-side database; instructions on the server for automatically generating tables and stored procedures for keeping track of the selections to be synchronized; instructions on the server for automatically generating source code configured for synchronizing the selections of the server-side database with the client-side database, and compiling the source code so as to produce executable code for execution on a web server; instructions on the server for deploying, over the communications network, the executable code to the web server; instructions on the web server for executing the executable code on the web server responsive to a request for synchronization with the mobile computing device; instructions on the mobile computing device for interacting with the executable code on the web server, so as to create the client-side database to match the server-side database based on a database schema received from the server and so as to synchronize the selections of the server-side database with the client-side database, over the communications network; instructions on the server for detecting changes to the database schema of the server-side database, and responsive to detecting said changes, executing the following instructions:
instructions on the server for automatically updating the tables and stored procedures for keeping track of the selections to be synchronized to reflect the new database schema;automatically generating source code for synchronizing the changes to the database schema of the server-side database with the client-side database, and compiling the source code so as to produce updated executable code for execution on the previously specified web server;deploying, over the communications network, the updated executable code to the previously specified web server;instructions on the web server for executing the updated executable code on the web server responsive to a request for synchronization with the mobile computing device; andinstructions on the mobile computing device for interacting with the updated executable code on the web server, so as to synchronize the changes to the database schema of the server-side database with the client-side database, over the communications network. |