保持 SQL Server 开发环境最新
我正在尝试找出保持开发服务器与生产服务器同步的最佳方法。最初，我只是打算每周左右将备份从生产环境恢复到开发环境，但是我意识到这会消除本周发生的任何实际开发工作。
我觉得这是一个非常常见的障碍，所以我希望有人能够阐明他们如何解决这个问题。我在网上简单浏览了一下，但没有真正看到任何东西，所以任何建议将不胜感激。
谢谢！
I'm trying to figure out the best way to keep my Development servers synced up to the Production servers. Initially, I was just going to restore the backups from the production environment to the dev environment every week or so, however I realized that this would wipe out any actual development work that had taken place during the week.
I feel like this is a pretty common obstacle, so I'm hoping someone out there can shed some light on how they tackle the issue. I looked online briefly, but didn't really see anything, so any suggestions would be greatly appreciated.
Thanks!
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
Red Gate 有一些您可能想要查看的产品：
它们允许您分别在两个数据库之间比较和同步架构和数据。
Red Gate have a couple of products that you might want to look at:
They allow you to compare and synchronize schemas and data respectively between two databases.
对开发环境所做的任何更改都应该在某个时候被推送到生产中。因此，对开发环境所做的每个更改都必须作为补丁（sql 脚本）存在。为了使开发与生产保持同步，您只需恢复生产备份并应用所有新开发的补丁即可。
Any change made to the development environment should, at some point, be pushed to production. Therefore, each change made on the dev environment must exist as a patch (sql script). To keep dev in sync with production you just restore the production backup and apply all the newly developed patches.