Assembly Difference Not Appearing in Update Script
medi_pv
Posts: 8
I am using Database.CompareWith to get schema differences between two databases.
In the result differences, I see there is an 'assembly' that is different. I also confirm this in the SQL Compare UI.
However when I use Work.BuildFromDifferences and ExecutionBlock, I don't see the assembly update in the output SQL script.
Is there an option I need to enable? Suggestions? Sorry if I have missed something obvious, I'm new to the SDK...
In the result differences, I see there is an 'assembly' that is different. I also confirm this in the SQL Compare UI.
However when I use Work.BuildFromDifferences and ExecutionBlock, I don't see the assembly update in the output SQL script.
Is there an option I need to enable? Suggestions? Sorry if I have missed something obvious, I'm new to the SDK...
static void CompareSchema(Database source, Database target)
{
Differences stagingVsProduction = source.CompareWith(target, Options.Default.Plus(Options.IgnoreConstraintNames));
foreach (Difference difference in stagingVsProduction)
{
Debug.Assert(difference.DatabaseObjectType != RedGate.SQLCompare.Engine.ObjectType.Assembly); I HIT THIS ASSERT
}
Work work = new Work();
work.BuildFromDifferences(stagingVsProduction, Options.Default/*.Plus(Options.IncludeDependencies)*/, true);
using (var block = work.ExecutionBlock)
{
File.WriteAllText("c:\temp\ct_schema.sql", block.GetString());
}
}
Comments