自动更新软件的数据库 [英] automatically updates the database of a software

问题描述

大家好，
我正在开发Windows应用程序，因此我想添加软件的自动更新，即，我已经开发了软件的第一个版本及其许多客户使用的软件，但是在第二个版本中，我向数据库中添加了一些表，并添加一些其他功能，因此我需要在用户安装该软件的第二个版本时，它将旧版本的数据放入第二个版本中，这样做的专业方法是什么，所以请帮助我通过提供解决方案或某些站点.
谢谢.

Hi everybody,
I am developing a windows application and in that i want to add the automatic updates of my software, ie , i already developed the 1st version of my software and its used by many clients , but in the second version i added some table to the database, and add some more features, so i need that when the user install the second version of the software it will take the datas from the older version and put into the second version, what is the professional way to do this, so please help me by providing the solution or some sites .
Thanking you.

推荐答案

vpmanu写道:

我们如何添加加法表到较旧的数据库

how can we add the addition tables to the older database

取决于.
假设对于SQL Server，
查询就像:

Depends.
Suppose for SQL Server,
the Query is like:

CREATE TABLE table_name
("column 1" "data_type_for_column_1",
"column 2" "data_type_for_column_2",
... )

或者，您也可以使用企业管理器，它不需要您编写查询.
:rolleyes:

Or you can also use Enterprise Manager which would not need you to write queries.
:rolleyes:

您如何分发此更新?

首先，应将应用程序设计为不需要全新的数据库.添加新功能所需的其他表.如果存在架构更改，则应用程序应处理版本之间的差异.即读取较旧的格式，但写入新的格式.

使用Windows Installer之类的安装程序，并添加更新数据库所需的所有自定义模块.

How are you distributing this update?

First the application should have been designed to not require a completely new database. Add the additional tables required for the new functionality. If there are schema changes, then the app should handle the differences between versions. i.e read an older format but write the new format.

Use a setup program, like Windows Installer, and add any custom modules necessary to update the database.

感谢您的答复，以及如何将添加表添加到较旧的数据库中，请提供一些示例代码.
谢谢.

Thank you for your reply, and how can we add the addition tables to the older database, Please give some example codes.
Thanking you.

这篇关于自动更新软件的数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！