Schema Compare

rduclos

I am trying to compare 2 databases and only script a portion of the executionblock at a time. Is there a wy to filter the execution block to only script based on if it is a Dropping|Altering|Adding script?

Brian Donahue

Hi Ryan,

The best thing I can think of is to loop through the collection of differences that you get after using the comparewith method and set any object difference's 'Selected' property to 'false' if you do not want to script them.

Then, when you use the work.ExecutionBlock, the differences that you feed to it in the first argument will not be scripted if the individual difference's 'selected' property is set to 'false'.

rduclos

I was looking into this and using the difference object does not give me the SQL Script, i need the script to determine what file i need to write it to.

I am trying to write 3 seperate files based on if they are dropping|alterining|adding.

Brian Donahue

Differences differences=db1.CompareWith(db2, Options.Default);
//script only different objects
foreach (Difference difference in differences)
{
if (difference.ObjectIn1!=null && difference.ObjectIn2!=null) difference.Selected=true;
else difference.Selected=false;
}
work.BuildFromDifferences(differences, Options.Default, true);
ExecutionBlock block=work.ExecutionBlock;
Console.WriteLine(block.GetString());

...etc...