如何使用代码启动Microsoft Visual Studio 2013的数据比较窗口？ [英] How can I launch data compare window of Microsoft Visual Studio 2013 using code?

问题描述

I want to compare two databases, first schema and then data.
I can do this manually using Microsoft Visual Studio Data Compare and Schema Compare options, I want to write a code which will do this and provide me with the exact target database as source, given input two databases, connection string, etc, etc; the operation has to be perform on existing database.

推荐答案

如果您打算在生产中使用它，那么您不能作为该功能在Visual Studio中内置，你不能在你的代码中使用它。



有许多商业产品用于模式比较，如：http://www.red-gate.com/products/sql-development/sql-compare/ [ ^ ]

If you intend to use it in production then you can't as that functionality is built into Visual Studio and you can't "use it in your code".

There are a multitude of commercial products for schema comparison like : http://www.red-gate.com/products/sql-development/sql-compare/[^]

这个作品的组合



http://candordeveloper.com/2013/01/08/creating-a-sql-server-database-project-in-visual- studio-2012 / [ ^ ]



http://blogs.msdn.com/b/ssdt/archive/2012 /02/02/including-data-in-an-sql-server-database-project.aspx [ ^ ]

Combination of this works

http://candordeveloper.com/2013/01/08/creating-a-sql-server-database-project-in-visual-studio-2012/[^]

http://blogs.msdn.com/b/ssdt/archive/2012/02/02/including-data-in-an-sql-server-database-project.aspx[^]

这篇关于如何使用代码启动Microsoft Visual Studio 2013的数据比较窗口？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！