SQL Server 2005 - 同步开发/生产数据库 [英] SQL Server 2005 - Syncing development/production databases

问题描述

我有一个相当大的 SQL Server 2005 数据库，正在不断开发中.每隔一段时间，我要么需要一个新的开发人员，要么需要将大规模的架构更改部署到生产服务器.

I've got a rather large SQL Server 2005 database that is under constant development. Every so often, I either get a new developer or need to deploy wide-scale schema changes to the production server.

我主要关心的是从主"开发副本向开发人员机器部署架构 + 数据更新.

My main concern is deploying schema + data updates to developer machines from the "master" development copy.

是否有一些内置功能或工具可以以这种方式发布架构 + 数据?我希望它花费尽可能少的时间.可以在 SSMS 内完成吗?

Is there some built-in functionality or tools for publishing schema + data in such a fashion? I'd like it to take as little time as possible. Can it be done from within SSMS?

提前感谢您的时间

推荐答案

我建议使用可以部署架构更改和/或数据的 RedGate 工具(这不是广告，而是使用它们的真实生活体验):

I suggest using RedGate's tools (this is not advertisment, but real life experience with them) that can deploy schema changes and/or data:

• SQL 比较架构更改
• 用于数据更改的 SQL 数据比较

我过去曾使用过这些工具(也使用过其他工具)，它们确实对开发分期过程有所帮助.这些工具不是免费的，但它们的价格对于任何开发团队来说都是可以接受的.

I used these tools in the past (others as well) and they really helped with development staging process. These tools aren't free but their price is more than acceptable for any development team.

检查 RedGate 网站

这篇关于SQL Server 2005 - 同步开发/生产数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！