修改数据库架构

本文介绍了修改数据库架构的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

嗨 我正在使用数据库(sql server 2008)存储一些数据的项目.在开发过程中，数据库的架构将更改几次.当将软件更新安装在计算机上时，我需要检查更新之前使用的数据库架构和更新之后使用的数据库架构.是否有可用的工具来检查架构的差异并创建更新脚本，该脚本可用于将现有架构修改为新架构.我需要一个可以以编程方式运行的工具(使用命令行或类似的东西).是否有人知道可以用来实现这一目标的好工具，还是有人知道实现这一目标的另一种方式?任何建议将被认真考虑. Uros

Hi I am working on a project that uses database(sql server 2008) to store some data. During the development the schema of the database will change a few times. When the update for the software will be installed on a machine I need to examine the schema of the database that was used before the update and the schema of the database that will be used after the update. Is there any tool available that will inspect the differences of the schemas and created the update script which can than be used to modify the existing schema to the new schema. I would need a tool that can be run programmaticaly(using a commmand line or something similar). Does anybody knows of a good tool that can be used to achive this, or does anybody know a different way of achiving this? Any advice will be appreciated. Uros

推荐答案

您应该为此使用Visual Studio数据库(VSDB)项目.请检查链接 msdn.microsoft/en-us/library/xee70aty.aspx [ ^ ]了解更多信息. VSDB允许使用VSDBCMD实用程序进行命令行部署.迁移到基于VSDB的开发和部署非常容易. You should be using visual studio database (VSDB) projects for this. Please check the link msdn.microsoft/en-us/library/xee70aty.aspx[^] for more info. VSDB allows command line deployment using VSDBCMD utility. It is fairly easy to migrate to VSDB based development and deployments.