Add custom migration methods to rails

create_view_test.rb

class CreateViewTest < ActiveRecord::Migration
  def up
    create_view_or_table :view_test do
      view_column :select => "#{source_db}.dbo.Config.value", :as => :config_value, :type => :integer
      view_sql "FROM #{source_db}.dbo.Config"
  end
end

initialize_migration_extension.rb

ActiveRecord::ConnectionAdapters::AbstractAdapter.send(:include, MyRailsApp::SchemaStatements)

migration.rb

module MyRailsApp
  class Migration < ActiveRecord::Migration
    def source_db
      "source_database"
    end
  end

  module SchemaStatements
    def view_column(*args)
      column *args
    end

    def view_sql(sql)
      "additional_sql"
    end

    def create_view_or_table(*args)
      create_table *args
    end  
  end
end