CODEWITHSUNDEEP
databasevisual-studio-2010compare
MicMit
MicMit

Reputation: 2462

Visual Studio 2010 Data Compare Automation

I noticed in premium edition Data menu with Data Compare option which does everything I need. Just wondering whether there is a way to automate what's done in GUI from my application. Ideally I'd like to get collections of different/left/right rows

Upvotes: 4

Views: 2606

Answers (2)

Darragh
Darragh

Reputation: 2656

In this blog I’ll lead you through the various parameters for the “Data.NewDataComparison” ...

Link

Upvotes: 1

Preet Sangha
Preet Sangha

Reputation: 65555

Start here with VSDBCMD.EXE. Then see Schema Compare DTE Commands.

I suspect something like 

devenv /Command Data.NewSchemaComparison [/ProviderType ConnectionBased | ProjectBased | FileBased] [/ConnectionString connection] | [/DatabaseName databaseName] | [/ConnectionName name] | [ProjectName proj] | [/FileName fileName] [/DspFamily family][ProviderType ConnectionBased | ProjectBased | FileBased] [/ConnectionString connection] | [/DatabaseName databaseName] | [/ConnectionName name] | [ProjectName proj] | [/FileName fileName] [/DspFamily family]

I'm hoping that there is a similar command for Data Compare.

Upvotes: 1

Related Questions