Schema Compare DTE Commands

New VSDB Blog

Data Dude — Sat, 22 Nov 2008 22:00:44 GMT

Patrick Sirr , one of the key developers in our team started his own blog. If you want to learn about

Visual Studio Team System 2008 Database Edition GDR - RTM

Data Dude — Wed, 26 Nov 2008 05:15:02 GMT

Finally the moment is there, the final version of the Visual Studio Team System 2008 Database Edition

Visual Studio Team System 2008 Database Edition GDR - RTM

Ronan Geraghty's Blog — Wed, 26 Nov 2008 12:27:43 GMT

The VS Database edition team has just released the golden version of the Visual Studio Team System 2008

re: Schema Compare DTE Commands

psirr — Wed, 14 Jan 2009 00:46:06 GMT

I've uploaded a new .zip file with some fixes. Thanks Tracy!!

re: Schema Compare DTE Commands

tsells — Wed, 14 Jan 2009 04:57:06 GMT

Patrick -

Thank you very much for thus. This will be most helpful in our automated development / testing environment. It is working as expected now.

Tracy

re: Schema Compare DTE Commands

psirr — Wed, 11 Feb 2009 03:40:19 GMT

I've updated the zip file to include a block of code which verifies that any projects you may be comparing have their database schema models fully resolved. This code is unnecessary when comparing two databases as the reverse engineering process will resolve the models as they built.

// Just in case you're comparing two projects you'll need to build the solution

// to make sure the project's object models are fully built.

dteInstance.ExecuteCommand("Build.BuildSolution", commandArg);

bool done = false;

while (!done &&

vs.HasExited == false)

{

if (dteInstance.Solution.SolutionBuild.BuildState == EnvDTE.vsBuildState.vsBuildStateDone)

{

done = true;

}

Console.WriteLine("Waiting for solution build to finish...");

Thread.Sleep(5000);

}