CleanUpSchemaTask

Class CleanUpSchemaTask

Tries to remove all database objects from the given schema(s). Currently only SqlServer and Oracle support this task.

Inheritance
CleanUpSchemaTask
Implements
Namespace: ETLBox.ControlFlow
Assembly: ETLBox.dll
Syntax
    public sealed class CleanUpSchemaTask : ControlFlowTask, ILoggableTask
Examples
CleanUpSchemaTask.CleanUp("demo");

Constructors

CleanUpSchemaTask()

Declaration
    public CleanUpSchemaTask()

CleanUpSchemaTask(string)

Declaration
    public CleanUpSchemaTask(string schemaName)
Parameters
TypeNameDescription
stringschemaName

Properties

SchemaName

The name of the schema

Declaration
    public string SchemaName { get; set; }
Property Value
TypeDescription
string

Sql

The sql code that is used to clean up the schema.

Declaration
    public string Sql { get; }
Property Value
TypeDescription
string

Methods

CleanUp()

Runs the sql to clean up the user schema. (Oracle only)

Declaration
    public static void CleanUp()

CleanUp(IConnectionManager)

Runs the sql to clean up the user schema.

Declaration
    public static void CleanUp(IConnectionManager connectionManager)
Parameters
TypeNameDescription
IConnectionManagerconnectionManager

The connection manager of the database you want to connect

CleanUp(IConnectionManager, string)

Runs the sql to clean up a schema.(Oracle and SqlServer only)

Declaration
    public static void CleanUp(IConnectionManager connectionManager, string schemaName)
Parameters
TypeNameDescription
IConnectionManagerconnectionManager

The connection manager of the database you want to connect

stringschemaName

The name of the schema

CleanUp(string)

Runs the sql to clean up a schema. (Oracle and SqlServer only)

Declaration
    public static void CleanUp(string schemaName)
Parameters
TypeNameDescription
stringschemaName

The name of the schema

Implements