require 'rubygems'
require 'active_record'

class SourceTable < ActiveRecord::Base
  #set_table_name 'any_name'
  self.establish_connection(
    :adapter  => "mysql",
    :host     => "source_host",
    :username => "user",
    #:password => "mypass",
    :database => "source_database"
  )
end

class TargetTable < ActiveRecord::Base
  #set_table_name 'any_name'
  self.establish_connection(
    :adapter  => "mysql",
    :host     => "target_host",
    :username => "user",
    #:password => "mypass",
    :database => "target_database"
  )
end

records = SourceTable.find :all
records.each do |r|
  # transition logic goes here
  # t = TargetTable.new :field_one => 'xyz'
  # t.save
end