SQL数据库修补程序 [英] Patch For SQL Database

问题描述

亲爱的朋友，

我必须为SQL Server数据库制作一个补丁文件，我需要将其发送给客户端以更新旧dB.在新数据库中，我对数据库架构进行了许多更改，即，新表，更新表，存储过程，视图(新视图和旧视图).

现在，为了对此做一个补丁，我需要为New存储过程和更新的存储过程以及新表编写完整的代码.这会使补丁代码有点复杂.我一直在寻找一些简单的步骤来执行相同的操作，但最终无法从Web获得任何东西.因此，最后我切换到 http://www.codeproject.com 作为答案.

如果有人对此有任何想法，请提供建议.

谢谢，

Varun Sareen

Dear Friends,

I have to make a Patch file for the SQL Server Database that i need to send it to client in order to update the Old dB. In the new database I have many changes in the database schema i.e., new tables, updated tables, stored procedures, views (new ones and old ones).

Now in order to make a patch for the same, I need to write the full code for the New stored procedures and updated stored procedures, and for new tables as well. This will make the patch code a bit complex. I was looking for some easy procedure to perform the same operation but ended in getting nothing from web. So at last I switched to http://www.codeproject.com for the answer.

If anyone out there is having any idea regarding this, Kindly advice.

Thanks,

Varun Sareen

推荐答案

我将使用SQL Management Studio生成一个SQL脚本，该脚本创建表，视图，存储过程等，并相应地修改该SQL脚本，例如您正在向表中添加一列，然后将relivent部分从CREATE TABLE 修改为ALTER TABLE .

I would use SQL Management Studio to generate a SQL script that creates table, views, stored procedures etc, that amend the SQL script accordingly, for example if you are adding a column to a table then you would modify the relivent section from CREATE TABLE to ALTER TABLE .

这篇关于SQL数据库修补程序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！