convert data from SQLServer to MySQL

convert_data_from_sqlserver_to_mysql.rb

def convertLine(line)
	line = line.gsub("]","").gsub("[","")
	line = line.gsub(" +09:00","")
	# 変換候補文字列を抽出
	# ex. N'POINT (0 0)' -> GeomFromText('POINT (0 0)')
	points = line.scan(/N'POINT \(.+?\)'/)
	points.each do |point|
		line = line.gsub(point,point.gsub("N'","GeomFromText('").gsub(")'",")')"))
	end 
	line + ";"
end

def convertSQL(path)
	File.open(path, 'r:utf-8') do |f|
		f.each_line do |line|
			puts convertLine(line)
		end
	end
end

convertSQL(ARGV[0])