protected void ScriptView(IView view, IScriptWriter writer)
{
Throw.If(view, "view").IsNull();
Throw.If(writer, "writer").IsNull();
string name = DbObjectName.CreateDbObjectName(view);
string msg = string.Format("Scripting view {0}", name);
messageManager.OnScriptMessage(msg);
SqlScript script = scriptBuilder.Create(view);
writer.WriteViewScript(name, script.ToScript());
}
protected virtual void ScriptViews()
{
foreach (string viewName in exportParams.ViewsToScript)
{
// export current sproc
SqlView view = database.Views[viewName];
if (view == null)
{
string msg = string.Format(
"Cannot find the view {0} in the database {1}",
viewName, database.Name);
throw new SqlExporterException(msg);
}
// get sproc script with drop statement and comments
string sql = view.Script(SqlScriptType.Create |
SqlScriptType.Drop |
SqlScriptType.Comments |
SqlScriptType.Permissions);
writer.WriteViewScript(view.Name, sql);
UpdateProgress(view.Name);
}
}