如何更新我的 SQL Server 数据库架构?

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

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?