ora2mysql.cpp

把oracle库中的数据插入到mysql表中 oracle2mysql

// FileZip.cpp : 定义控制台应用程序的入口点。
//

#include "TIniFile.h"
#include "ora2my.h"

static ACE_TString conf_file;

static int parse_args (int argc, ACE_TCHAR *argv[])
{
	ACE_Get_Opt get_opt (argc, argv, ACE_TEXT("f:"));
	int c;

	while ((c = get_opt ()) != EOF)
		switch (c)
	{
		case 'f':
			conf_file = get_opt.opt_arg ();
			break;
		default:
			ACE_ERROR ((LM_ERROR, "%s \n",
				"usage :\n"
				"\t-f <configure file> \n"));
			return -1;
	}
	return 0;
}

int ACE_TMAIN (int argc, ACE_TCHAR *argv[])
{
	if (parse_args (argc, argv) == -1) return -1;
	if(INIFILE::instance ()->Open(conf_file) == -1) return -1; //读配置信息
	INIFILE::instance()->Print();

	ORA2MYSQL::instance()->init_ora(INIFILE::instance ()->dblogin);
	ORA2MYSQL::instance()->init_my(INIFILE::instance ()->host, 
		INIFILE::instance ()->user, 
		INIFILE::instance ()->pwd, 
		INIFILE::instance ()->port, 
		INIFILE::instance ()->tablename);

	ORA2MYSQL::instance()->connect_ora();
	ORA2MYSQL::instance()->connect_my();

	ORA2MYSQL::instance()->dumpfromoracle(INIFILE::instance ()->sql);

	return 0;
}