且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

更新没有effectiong数据库的软件。

更新时间:2023-02-08 17:27:06

解决方案:

1.准备应用程序的新固定版本

2.将更新的应用程序文件(无需任何设置 - 可以压缩)上传到外部服务器(HTTP或FTP或其他)

3.准备SQL脚本文件到更新客户端的数据库架构(如果已更改)

3.1将SQL脚本文件上载到外部服务器

4.准备SQL脚本以更新客户端数据 - 如果需要

4.1将SQL脚本文件上传到外部服务器

5.创建小应用程序以更新您的应用程序并让客户下载并运行



您的Updator应用程序应该:

1.连接到外部服务器

2.下载(并解压缩,如果已压缩)并替换您的应用程序文件(添加new / update existing / delete old)

3.下载并执行SQL脚本以更新客户端的数据库模式

4.下载并执行SQL脚本以更新客户端数据



您还可以进行某种应用程序版本控制,让您的Updator应用程序检查应用程序是否是最新的。



我希望我能帮助你一点点:))
Solution for you:
1. Prepare new, fixed version of your application
2. Upload your updated application files (without any setup - it may be zipped) to an external server (HTTP or FTP or whatever)
3. Prepare SQL script file to update client's database schema if it was changed
3.1 Upload SQL script file to an external server
4. Prepare SQL script to update client's data - if you need
4.1 Upload SQL script file to an external server
5. Create small application to update your application and let customer download it and RUN

Your Updator application should:
1. Connect to an external server
2. Download (and unpack if zipped) and replace your application files (add new/update existing/delete old)
3. Download and execute SQL script to update client's db schema
4. Download and execute SQL script to update client's data

You can also do some kind of application versioning to let your Updator application check that app is up-to-date.

I hope I helped you a little bit :)