public void CanAlterSchema()
        {
            var expression = new AlterSchemaExpression
            {
                DestinationSchemaName = "DEST",
                SourceSchemaName = "SOURCE",
                TableName = "TABLE"
            };

            generator.Generate(expression);
        }

        public void CanAlterSchema()
        {
            var expression = new AlterSchemaExpression
              {
            DestinationSchemaName = "DEST",
            SourceSchemaName = "SOURCE",
            TableName = "TABLE"
              };

              var sql = generator.Generate( expression );
              sql.ShouldBe(
            "ALTER SCHEMA [DEST] TRANSFER [SOURCE].[TABLE]" );
        }

 public override string Generate(AlterSchemaExpression expression)
 {
     return string.Format("ALTER TABLE {0}.{1} SET SCHEMA {2}", Quoter.QuoteSchemaName(expression.SourceSchemaName), Quoter.QuoteTableName(expression.TableName), Quoter.QuoteSchemaName(expression.DestinationSchemaName));
 }

 public override string Generate(AlterSchemaExpression expression)
 {
     throw new DatabaseOperationNotSupportedExecption();
 }

 public void Process(AlterSchemaExpression expression)
 {
     Process(Generator.Generate(expression));
 }

 public override string Generate( AlterSchemaExpression expression )
 {
     throw new NotImplementedException();
 }

 public void Truncate(AlterSchemaExpression expression) { }

        public void CanAlterSchema()
        {
            var expression = new AlterSchemaExpression
            {
                DestinationSchemaName = "DEST",
                SourceSchemaName = "SOURCE",
                TableName = "TABLE"
            };

            var sql = generator.Generate(expression);
            sql.ShouldBe("ALTER TABLE \"SOURCE\".\"TABLE\" SET SCHEMA \"DEST\"");
        }

 public override string Generate(AlterSchemaExpression expression)
 {
     return String.Format(AlterSchema, Quoter.QuoteSchemaName(expression.DestinationSchemaName), Quoter.QuoteSchemaName(expression.SourceSchemaName), Quoter.QuoteTableName(expression.TableName));
 }

 public void ToStringIsDescriptive()
 {
     var expression = new AlterSchemaExpression { TableName = "Test", DestinationSchemaName = "Bacon" };
     expression.ToString().ShouldBe("AlterSchema Bacon Table Test");
 }

 public void ErrorIsNotReturnedWhenDestinationSchemaNameIsNotNullEmptyString()
 {
     var expression = new AlterSchemaExpression { DestinationSchemaName = "Bacon" };
     var errors = ValidationHelper.CollectErrors(expression);
     errors.ShouldNotContain(ErrorMessages.DestinationSchemaCannotBeNull);
 }

 public void ErrorIsReturnedWhenDestinationSchemaNameIsNull()
 {
     var expression = new AlterSchemaExpression { DestinationSchemaName = null };
     var errors = ValidationHelper.CollectErrors(expression);
     errors.ShouldContain(ErrorMessages.DestinationSchemaCannotBeNull);
 }

 public void ErrorIsReturnedWhenTableNameIsEmptyString()
 {
     var expression = new AlterSchemaExpression { TableName = String.Empty };
     var errors = ValidationHelper.CollectErrors(expression);
     errors.ShouldContain(ErrorMessages.TableNameCannotBeNullOrEmpty);
 }

 public override string Generate( AlterSchemaExpression expression )
 {
     return String.Format("ALTER SCHEMA [{0}] TRANSFER {1}[{2}]", expression.DestinationSchemaName, FormatSchema(expression.SourceSchemaName), expression.TableName );
 }

 public override string Generate(AlterSchemaExpression expression)
 {
     return compatabilityMode.HandleCompatabilty("Schemas are not supported");
 }

 public override void CanAlterSchema()
 {
     var expression = new AlterSchemaExpression();
     var result = generator.Generate(expression);
     result.ShouldBe(string.Empty);
 }

 public abstract string Generate(AlterSchemaExpression expression);