如何使用开发中的新更改来更新数据库 [英] How to update the database with new changes in develop

问题描述

您好

我在我们的数据库中制作了

该程序已实施且用户输入了他们的信息

最后一次我之后必须更改数据库并计划部署我的新更改

安装程序和程序更改已应用

但是不更新数据库和新的错误代码目标表中显示的内容不存在

请帮帮我

谢谢

Hello
I've produced in our database
The program was implemented and the users enter their information
After the last time I have to change the database and plan to deploy the new changes in my
Install the program and program changes were applied
But does not update the database and when the new error code that appears in the target table does not exist
Please help me
Thank you

推荐答案

1.You必须构建两个SQL脚本，这些脚本将使用新更改来更新现有数据库。第一个脚本应包含数据库结构中的更改 - 如新表，新字段，字段更改等;并且第二个脚本应该包含数据的更改 - 如新插入，更新或删除数据行。



2.然后你应该运行这个SQL脚本旧数据库。

1.You have to build at two SQL scripts that will update the existing database with the new changes. First script should contains the changes in the database structure -like new tables, new fields, fields changes, etc; and the 2nd script should contains the changes in the data -like new inserts, updates or delete of the data rows.

2.Then you should run this SQL scripts on the old database.

亲爱的朋友，谢谢你的回答

我不知道你怎么说命令

如果你能详细说明更多

我正在开发一个基于Web的ASP事件和很多窗口

Dear Friend, Thanks for your answer
I do not know how you say commands
If you can elaborate more
I'm working on a web based ASP event and many windows do

这篇关于如何使用开发中的新更改来更新数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！