public void Transform(TransformationContext context)
{
var gen = new SqlServerScriptGenerator();
gen.TargetSystem = context.TargetSystem;
gen.DataSchema = context.DataSchema;
var accessor = new SimpleXmlValueAccessor(context.TransformationElement, DataSchemaProject.TargetNamespace);
gen.DatabaseSchemaName = accessor.GetString("DatabaseSchemaName");
var docGenName = accessor.GetStringOrDefault("ScriptDocumentGenerator");
if (!string.IsNullOrEmpty(docGenName))
{
gen.ScriptDocumentGenerator = context.DocGenFactory.Create(docGenName);
}
var outputFilePath = accessor.GetStringOrDefault("OutputFile");
using (FileStream stream = new FileStream(outputFilePath, FileMode.Create))
{
gen.Generate(stream);
}
}
private void GenerateScript(DataSchema dataSchema)
{
TargetSystem targetSystem = dataSchema.TargetSystems[TargetSystemNameForScript];
SqlServerScriptGenerator gen = new SqlServerScriptGenerator();
gen.TargetSystem = targetSystem;
gen.DataSchema = dataSchema;
using (FileStream stream = new FileStream(SqlScriptFilePath, FileMode.Create))
{
gen.Generate(stream);
}
}