protected void ScriptSprocs() { foreach (string sprocName in exportParams.SprocsToScript) { // export current sproc SqlStoredProcedure sproc = database.StoredProcedures[sprocName]; if (sproc == null) { string msg = string.Format( "Cannot find the stored procedure {0} in the database {1}", sprocName, database.Name); throw new SqlExporterException(msg); } // get sproc script string sql = sproc.Script( SqlScriptType.Create | SqlScriptType.Drop | SqlScriptType.Comments | SqlScriptType.Permissions); writer.WriteSprocScript(sproc.Name, sql); UpdateProgress(sproc.Name); } }
protected void ScriptSproc(IProcedure sproc, IScriptWriter writer) { Throw.If(sproc, "sproc").IsNull(); Throw.If(writer, "writer").IsNull(); string name = DbObjectName.CreateDbObjectName(sproc); string msg = string.Format("Scripting stored procedure {0}", name); messageManager.OnScriptMessage(msg); SqlScript script = scriptBuilder.Create(sproc); writer.WriteSprocScript(name, script.ToScript()); }