如何更新我的 SQL Server 数据库架构? [英] How can I update my SQL Server database schema?

问题描述

通常在一个项目的整个开发过程中，我会经常部署，只是为了确保我在生产中不会出现任何问题.

Usually throughout development of a project I will deploy frequently, just to make sure I wont have any problems in production.

此外，在整个开发过程中，我发现自己更改了数据库的架构.

Also, throughout development, I find myself changing the database's schema.

如何轻松更新生产中的数据库?

How can I easily update the database in production?

我一直在删除旧数据库并重新连接新数据库.有没有更快的方法来更新部署数据库?

I have been dropping the old database and reattaching the new one. Is there a faster way to update the deployment database?

谢谢

有哪些免费的工具可以做到这一点?

What are some free tools for this?

推荐答案

生成脚本"向导正是我所需要的.

The Generate Scripts wizard did exactly what I needed.

这篇关于如何更新我的 SQL Server 数据库架构?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！