Red Gate SQL 与 VS2010 Ultimate 比较
我曾经使用 SQL2000 和 Red Gate SQL Compare 3.2，并且我是一个快乐的露营者。在所有编码完成并且我需要编译脚本列表以使产品数据库与产品同步之前，我不会担心跟踪对开发数据库所做的更改。
这就是 SQL Compare 以及某种程度上的 SQL Data Compare 在
- 指出差异方面非常有价值的地方，更重要的是，
- 它帮助我生成 SQL 以使产品数据库与开发数据库同步。
我看到 VS2010 Ultimate 允许我比较两个模式，但是#2 确实可以吗？我相信这是应该的，但对我来说如何做到这一点并不明显。
任何朝正确方向的推动都会立即获得投票支持或更好。 ty。
I used to use SQL2000 and Red Gate SQL Compare 3.2 and I was a happy camper. I wouldn't worry about tracking the changes that I make to the dev database until all the coding was done and I needed to compile a list of scripts to bring the prod db in sync with the prod.
This is where SQL Compare and to some degree, SQL Data Compare, were invaluable in
- pointing out the differences and even more importantly,
- helping me generate the SQLs to bring the prod db in sync with the dev db.
I see that VS2010 Ultimate allows me to compare two schemas, but does do #2? I believe it is suppose to but it ain't obvious to me how to do that.
Any kick in the right direction would be an immediate vote up or better. ty.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（4）
注意，我写了一篇博客文章来比较 VS2010 Ultimate 和 Premium 中的 SQL 数据，您可能想查看http://zubairdotnet.blogspot.com/2010/07/fun-with-vs2010-ultimate-comparing-sql.html
Caution plug,I wrote a blog entry to compare SQL Data in VS2010 Ultimate and Premium that you might wanna check out http://zubairdotnet.blogspot.com/2010/07/fun-with-vs2010-ultimate-comparing-sql.html
据我所知，VS2010 Ultimate 中的这个工具只能与 SQL Server 2005 和 2008 一起使用。昨天我尝试在生产 SQL 2000 实例和开发 2008 实例之间进行比较，它直截了当地说它不会可以处理 2005 年之前的任何东西。当然，RedGate Compare 完全没有问题。
As far as I can tell, this tool in VS2010 Ultimate will only work with SQL Server 2005 and 2008. I tried yesterday to do a compare between my production SQL 2000 instance and a dev 2008 instance, and it flat-out said it will not work with anything prior to 2005. RedGate Compare, of course, had no issues at all.
抛开一切，尝试 2013 年 10 月发布的 SQL Server Data Tools Visual Studio 2012：http://msdn.microsoft.com/en-US/data/tools.aspx，选择“获取”，然后选择“下载适用于 Visual Studio 的 SSDT” 2012'，或者您可以直接访问：
http://msdn.microsoft.com/en- us/jj650015
它具有架构比较和数据比较，甚至允许 SQL Server 2014 CTP2 连接。
Drop every thing, and try SQL Server Data Tools October 2013 release for Visual Studio 2012: http://msdn.microsoft.com/en-US/data/tools.aspx, choose 'Get It' and then 'Download SSDT for Visual Studio 2012', or you can go straight there on:
http://msdn.microsoft.com/en-us/jj650015
It has Schema Compare and Data Compare, and even allows SQL Server 2014 CTP2 connections.
是的，确实如此（2）。为此，请运行比较（数据/架构比较/新架构比较），选择要更新的对象，然后右键单击网格或转到数据/架构比较菜单并选择刷新更新脚本。如果您现在看不到升级脚本，请选择同一菜单中的“显示架构更新脚本”。
如果您想要一个更加用户友好和多功能的工具，请考虑尝试 SQL Compare 8！ （我是产品经理）
Yes, it does (2). To achieve this, run the comparison (Data/Schema Compare/New Schema Comparison), choose the objects you want to update, and then right click on the grid or go to the Data/Schema Compare menu and select Refresh Update script. If you can't see an upgrade script now, select Show Schema Update Script which is in the same menu.
If you want a more user-friendly and versatile tool, please consider trying SQL Compare 8! (I'm the product manager)