使用软件更新来更新SQL Server数据库架构

问题描述:

在安装产品更新时如何更新SQL服务器数据库?是否有任何可与Windows Installer集成的工具?我典型的架构更改是:

How do you update your SQL sever database when installing your product's update? Are there any tools that will integrate with windows installer? My typical schema changes are:

  • 添加/删除列
  • 添加/删除表.
  • 添加视图.
  • 添加/更改索引.

不确定是否与Windows Installer集成,但是您可以查看Red Gate的

Not sure about integration with the windows installer, but you might look into Red Gate's SQL Packager