SQL 模式比较 - 列级操作
我有一个生产数据库和一个开发数据库。我希望将一些开发数据库更改传播到生产数据库。由于错误修复，生产数据库还具有一些新列和更改。我需要一个 Scema 比较工具，允许在列级别接受/拒绝更改。
我已经尝试过 VS2010 架构比较，但似乎无法更改列级别的更新操作...尝试过 Red Gate SQL Compare 9，同样，也无法编辑列级别的更改。
我怀疑我必须手动修改这两个之一生成的更新脚本。
处理这个问题的推荐方法是什么？ VS2010 或 Red Gate 与其他工具对比？
谢谢。
I have a production DB and a dev DB. I'd like SOME of the Dev DB changes to be propagated to the Production DB. The production DB also has some new columns and changes due to bug fixing. I need a Scema Compare Tool that allows for acccepting/deniyng changes at the column level.
I have tried the VS2010 Schema Compare, but it seems one can't change the Update Action at the column level... Tried Red Gate SQL Compare 9, same, can't edit changes at the column level either.
I suspect I'll have to manually modify the update script generated by one of those two.
What is a recommended way to deal with this? VS2010 or Red Gate vs another tool?
Thanks.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
Red Gate 的工具是黄金标准。命令行选项可以让您将脚本自定义到您需要的级别。
编辑：Red Gate SQL 比较使您可以轻松选择更改：
如果右键单击底部窗格中显示的差异，您可以显示脚本，该脚本很容易复制、粘贴然后编辑。我知道这不是自动化的，但它通过用户界面非常灵活。
当然，同步向导也会很乐意生成一个注释良好的脚本。
不过，如果您想自动化到列级别，请使用命令行选项，然后使用其他方法来修改生成的脚本。
Red Gate's tools for this are the gold standard. Command line options might let you customize the scripts to the level you need.
Edit: Red Gate SQL compare makes it pretty easy to pick and choose your changes:
If you right click on the differences shown in the bottom pane you can show the script, which is easy to copy, paste, then edit. I understand this isn't automated, but it's very flexible through the UI.
Of course, the Synchronization Wizard will happily generate a well commented script too.
Still, if you want to automate to the column level, use the command line options, and then something else to modify your resulting scripts.
SQL Compare 9.5（当前为测试版）允许您编辑默认生成的脚本，并且在提交到源代码控制（通过 SQL Source Control 3）时，将在未来的部署中重新使用自定义设置。
http://www.red-gate.com/MessageBoard/viewtopic.php ?t=14113
SQL Compare 9.5 (current available as a beta) lets you edit the default generated script and when committed to source control (via SQL Source Control 3), will re-use the customizations in future deployments.
http://www.red-gate.com/MessageBoard/viewtopic.php?t=14113