Sybase到oracle OGG实施文档.docx

Sybase到oracle OGG实施文档1 结构图1.1 源机器IP:48 数据库产品：Sybase端口号：7220用户名：sa 密码：123456数据库：aicbas/aicbiz1.2 目的机器IP:52 数据库产品：oracle端口号：1521用户名：dbo_aicbiz 密码：dbo_aicbiz数据库：orcl2 环境说明源端一服务器地址：44，用户名：root，口令：1234567，操作系统为Linux，数据库为Sybase 12.5，在操作系统上设置了sybase用户，数据库安装在/home/sybase目录下，OGG安装在/home/sybase/ogg目录下，访问OGG时需要先切换到sybase用户下，否则环境变量不生效。Sybase生产库需要同步95张表，分布在Sybase的aicbiz和aicbas两个库中。源端二服务器地址：99，用户名：root，口令：12345678，操作系统为Linux，且为虚拟机，数据库为Oracle 10g，在操作系统上设置了oracle用户，数据库安装在/u01/oracle目录下，OGG安装在/u01/ogg目录下，访问OGG时需要先切换到oracle用户下，否则环境变量不生效。12315数据库需要同步4张表。运行ogg的ggsci命令必须在/home/sybase/ogg或/u01/ogg目录下，也就是说，必须在ogg的安装目录下，否则ggsci不能正确读取配置信息。由于Sybase数据库里会在数据表里自动生成TIMESTAMP列，Oracle数据库中不支持此数据类型，而且此列也没有用处，所以在数据抽取过程中要忽略此列，因此，在extract配置文件中需要增加colsexcept （TIMESTAMP）参数。3 Sybase生产库安装配置过程及脚本3.1 Sybase生产库环境准备（1）在Sybase数据库上创建用户oggaic，并赋予sa_role和replication_role权限。sp_role grant, sa_role, oggaicsp_role grant,replication_role, oggaic（2）打开本地日志dbcc settrunc （ltm， valid）（2）为sybase数据库需复制的表打开log复制ggsci dblogin sourcedb aicbiz, userid oggaic, password oggaic3.2 生产库配置过程3.2.1 配置mgrggsci edit params mgrport 7809dynamicportlist 7810-7820autorestart er *, retries 5, waitminutes 3 purgeoldextracts /home/sybase/ogg/dirdat/hn*, usecheckpoints, minkeepfiles 103.2.2 配置extractggsci add extract hnesyb, tranlog, begin nowggsci add exttrail /home/sybase/ogg/dirdat/hn, extract hnesybggsci edit params hnesybextract hnesybsourcedb aicbiz, userid oggaic, password oggaicexttrail /home/sybase/ogg/dirdat/hnextract hnesybsourcedb aicbiz, userid oggaic, password oggaicexttrail /home/sybase/ogg/dirdat/hntable dbo.TSupervisionHistory, colsexcept (TIMESTAMP);table dbo.BusinessInfo, colsexcept (TIMESTAMP);table dbo.PawnItem, colsexcept (TIMESTAMP);table dbo.TIllegalRecord, colsexcept (TIMESTAMP);table dbo.TInspectionLog, colsexcept (TIMESTAMP);table dbo.TPartyInfo, colsexcept (TIMESTAMP);table dbo.Broker, colsexcept (TIMESTAMP);table dbo.Buyer, colsexcept (TIMESTAMP);table dbo.ENTERPRISEFORMONEY_GB, colsexcept (TIMESTAMP);table dbo.TSampleCaseInfo, colsexcept (TIMESTAMP);table dbo.EntityCurrentBizRange, colsexcept (TIMESTAMP);table dbo.FCLM_SupMagIndicators;table dbo.TAffInfo, colsexcept (TIMESTAMP);table dbo.TAmendsInfo, colsexcept (TIMESTAMP);table dbo.TAmendsOpinion, colsexcept (TIMESTAMP);table dbo.TAmendsAuditing, colsexcept (TIMESTAMP);table dbo.TComposeInfo, colsexcept (TIMESTAMP);table dbo.TDeclaration, colsexcept (TIMESTAMP);table dbo.BrokerHistory, colsexcept (TIMESTAMP);table dbo.TSupervisionTask, colsexcept (TIMESTAMP);table dbo.CASE_FY_ADMREVDECINFO_GB, colsexcept (TIMESTAMP);table dbo.CASE_FY_APPPARTY_GB, colsexcept (TIMESTAMP);table dbo.CASE_SS_LITIGATION_GB, colsexcept (TIMESTAMP);table dbo.Wzgsjbqk, colsexcept (TIMESTAMP);table dbo.TMESprvsnObj, colsexcept (TIMESTAMP);table dbo.TCaseJudgment, colsexcept (TIMESTAMP);table dbo.CancelDebt, colsexcept (TIMESTAMP);table dbo.ResoundBrand, colsexcept (TIMESTAMP);table dbo.BrandApply, colsexcept (TIMESTAMP);table dbo.NonPubParAnlys, colsexcept (TIMESTAMP);table dbo.EntityCurrentLicence, colsexcept (TIMESTAMP);table dbo.TCaseInfo_GB, colsexcept (TIMESTAMP);table dbo.BizindividualInvestor, colsexcept (TIMESTAMP);table dbo.Activity, colsexcept (TIMESTAMP);table dbo.TCaseInfoAppend, colsexcept (TIMESTAMP);table dbo.Wzgsjyqk, colsexcept (TIMESTAMP);table dbo.ADOutDoor, colsexcept (TIMESTAMP);table dbo.modifyLog, colsexcept (TIMESTAMP);table dbo.Ad, colsexcept (TIMESTAMP);table dbo.AdPerson, colsexcept (TIMESTAMP);table dbo.AdExaminant, colsexcept (TIMESTAMP);table dbo.Pledge, colsexcept (TIMESTAMP);table dbo.Debtor, colsexcept (TIMESTAMP);table dbo.ApplicantInfo, colsexcept (TIMESTAMP);table dbo.TKeyInfo, colsexcept (TIMESTAMP);table dbo.ExamineField, colsexcept (TIMESTAMP);table dbo.Wzgswhqk, colsexcept (TIMESTAMP);table dbo.AfterAuction, colsexcept (TIMESTAMP);table dbo.ADQualificationInfo, colsexcept (TIMESTAMP);table dbo.AnnualBaseInfo, colsexcept (TIMESTAMP);table dbo.Auction, colsexcept (TIMESTAMP);table dbo.CurrentIndividualInvestor, colsexcept (TIMESTAMP);table dbo.CurStockFreeze, colsexcept (TIMESTAMP);table dbo.CurStockImpawn, colsexcept (TIMESTAMP);table dbo.BizEntityInfo, colsexcept (TIMESTAMP);table dbo.InvestedCapital, colsexcept (TIMESTAMP);table dbo.LiquidateGroup, colsexcept (TIMESTAMP);table dbo.LiquidatePerson, colsexcept (TIMESTAMP);table dbo.BrandProposer, colsexcept (TIMESTAMP);table dbo.Brand, colsexcept (TIMESTAMP);table dbo.EntityBelong, colsexcept (TIMESTAMP);table dbo.EntityVIPList, colsexcept (TIMESTAMP);table dbo.MarketEntity, colsexcept (TIMESTAMP);table dbo.CancelOpinion, colsexcept (TIMESTAMP);table dbo.TSupervisionObjectIndex, colsexcept (TIMESTAMP);table dbo.FoodBusinessLoc, colsexcept (TIMESTAMP);table dbo.TQuashCaseAuditing, colsexcept (TIMESTAMP);table dbo.TCaseInfo, colsexcept (TIMESTAMP);table dbo.entityLegalRepresentative, colsexcept (TIMESTAMP);table dbo.FoodPermit, colsexcept (TIMESTAMP);table dbo.FoodPermitHea, colsexcept (TIMESTAMP);table dbo.EntityName, colsexcept (TIMESTAMP);table dbo.BizInvest, colsexcept (TIMESTAMP);table dbo.CorpInvestor, colsexcept (TIMESTAMP);table dbo.CurFreezeInvest, colsexcept (TIMESTAMP);table dbo.curStockPledge, colsexcept (TIMESTAMP);table dbo.StockTransferInfo, colsexcept (TIMESTAMP);table dbo.Person, colsexcept (TIMESTAMP);table dbo.MoveInfo, colsexcept (TIMESTAMP);table dbo.TLawbreaking, colsexcept (TIMESTAMP);table dbo.HandinDesc, colsexcept (TIMESTAMP);table dbo.TAffAuditing, colsexcept (TIMESTAMP);table dbo.Wzgsfqcz, colsexcept (TIMESTAMP);table dbo.Wzgsdwtz, colsexcept (TIMESTAMP);table dbo.Wzgsjckqk, colsexcept (TIMESTAMP);table dbo.Wzgsczqk, colsexcept (TIMESTAMP);table dbo.Wzgsqtqk, colsexcept (TIMESTAMP);table dbo.ControlledName, colsexcept (TIMESTAMP);table dbo.ControlledEntity, colsexcept (TIMESTAMP);table dbo.t_orgUnits, colsexcept (TIMESTAMP);table dbo.Coin, colsexcept (TIMESTAMP);table dbo.RefDetail, colsexcept (TIMESTAMP);table dbo.EnterpriseType, colsexcept (TIMESTAMP);table dbo.GDAICcode, colsexcept (TIMESTAMP);table dbo.ChangeFieldCnfg, colsexcept (TIMESTAMP);3.2.3 配置dpggsci add extract hndp, exttrailsource /home/sybase/ogg/dirdat/hn, begin nowggsci add rmttrail d:ogg_oradirdathn, extract hndp, megabytes 10ggsci edit params hndpextract hndpsourcedb aicbiz, userid oggaic, password oggaicrmthost 34, mgrport 7809rmttrail d:ogg_oradirdathntable dbo.TSupervisionHistory, colsexcept (TIMESTAMP);table dbo.BusinessInfo, colsexcept (TIMESTAMP);table dbo.PawnItem, colsexcept (TIMESTAMP);table dbo.TIllegalRecord, colsexcept (TIMESTAMP);table dbo.TInspectionLog, colsexcept (TIMESTAMP);table dbo.TPartyInfo, colsexcept (TIMESTAMP);table dbo.Broker, colsexcept (TIMESTAMP);table dbo.Buyer, colsexcept (TIMESTAMP);table dbo.ENTERPRISEFORMONEY_GB, colsexcept (TIMESTAMP);table dbo.TSampleCaseInfo, colsexcept (TIMESTAMP);table dbo.EntityCurrentBizRange, colsexcept (TIMESTAMP);table dbo.FCLM_SupMagIndicators;table dbo.TAffInfo, colsexcept (TIMESTAMP);table dbo.TAmendsInfo, colsexcept (TIMESTAMP);table dbo.TAmendsOpinion, colsexcept (TIMESTAMP);table dbo.TAmendsAuditing, colsexcept (TIMESTAMP);table dbo.TComposeInfo, colsexcept (TIMESTAMP);table dbo.TDeclaration, colsexcept (TIMESTAMP);table dbo.BrokerHistory, colsexcept (TIMESTAMP);table dbo.TSupervisionTask, colsexcept (TIMESTAMP);table dbo.CASE_FY_ADMREVDECINFO_GB, colsexcept (TIMESTAMP);table dbo.CASE_FY_APPPARTY_GB, colsexcept (TIMESTAMP);table dbo.CASE_SS_LITIGATION_GB, colsexcept (TIMESTAMP);table dbo.Wzgsjbqk, colsexcept (TIMESTAMP);table dbo.TMESprvsnObj, colsexcept (TIMESTAMP);table dbo.TCaseJudgment, colsexcept (TIMESTAMP);table dbo.CancelDebt, colsexcept (TIMESTAMP);table dbo.ResoundBrand, colsexcept (TIMESTAMP);table dbo.BrandApply, colsexcept (TIMESTAMP);table dbo.NonPubParAnlys, colsexcept (TIMESTAMP);table dbo.EntityCurrentLicence, colsexcept (TIMESTAMP);table dbo.TCaseInfo_GB, colsexcept (TIMESTAMP);table dbo.BizindividualInvestor, colsexcept (TIMESTAMP);table dbo.Activity, colsexcept (TIMESTAMP);table dbo.TCaseInfoAppend, colsexcept (TIMESTAMP);table dbo.Wzgsjyqk, colsexcept (TIMESTAMP);table dbo.ADOutDoor, colsexcept (TIMESTAMP);table dbo.modifyLog, colsexcept (TIMESTAMP);table dbo.Ad, colsexcept (TIMESTAMP);table dbo.AdPerson, colsexcept (TIMESTAMP);table dbo.AdExaminant, colsexcept (TIMESTAMP);table dbo.Pledge, colsexcept (TIMESTAMP);table dbo.Debtor, colsexcept (TIMESTAMP);table dbo.ApplicantInfo, colsexcept (TIMESTAMP);table dbo.TKeyInfo, colsexcept (TIMESTAMP);table dbo.ExamineField, colsexcept (TIMESTAMP);table dbo.Wzgswhqk, colsexcept (TIMESTAMP);table dbo.AfterAuction, colsexcept (TIMESTAMP);table dbo.ADQualificationInfo, colsexcept (TIMESTAMP);table dbo.AnnualBaseInfo, colsexcept (TIMESTAMP);table dbo.Auction, colsexcept (TIMESTAMP);table dbo.CurrentIndividualInvestor, colsexcept (TIMESTAMP);table dbo.CurStockFreeze, colsexcept (TIMESTAMP);table dbo.CurStockImpawn, colsexcept (TIMESTAMP);table dbo.BizEntityInfo, colsexcept (TIMESTAMP);table dbo.InvestedCapital, colsexcept (TIMESTAMP);table dbo.LiquidateGroup, colsexcept (TIMESTAMP);table dbo.LiquidatePerson, colsexcept (TIMESTAMP);table dbo.BrandProposer, colsexcept (TIMESTAMP);table dbo.Brand, colsexcept (TIMESTAMP);table dbo.EntityBelong, colsexcept (TIMESTAMP);table dbo.EntityVIPList, colsexcept (TIMESTAMP);table dbo.MarketEntity, colsexcept (TIMESTAMP);table dbo.CancelOpinion, colsexcept (TIMESTAMP);table dbo.TSupervisionObjectIndex, colsexcept (TIMESTAMP);table dbo.FoodBusinessLoc, colsexcept (TIMESTAMP);table dbo.TQuashCaseAuditing, colsexcept (TIMESTAMP);table dbo.TCaseInfo, colsexcept (TIMESTAMP);table dbo.entityLegalRepresentative, colsexcept (TIMESTAMP);table dbo.FoodPermit, colsexcept (TIMESTAMP);table dbo.FoodPermitHea, colsexcept (TIMESTAMP);table dbo.EntityName, colsexcept (TIMESTAMP);table dbo.BizInvest, colsexcept (TIMESTAMP);table dbo.CorpInvestor, colsexcept (TIMESTAMP);table dbo.CurFreezeInvest, colsexcept (TIMESTAMP);table dbo.curStockPledge, colsexcept (TIMESTAMP);table dbo.StockTransferInfo, colsexcept (TIMESTAMP);table dbo.Person, colsexcept (TIMESTAMP);table dbo.MoveInfo, colsexcept (TIMESTAMP);table dbo.TLawbreaking, colsexcept (TIMESTAMP);table dbo.HandinDesc, colsexcept (TIMESTAMP);table dbo.TAffAuditing, colsexcept (TIMESTAMP);table dbo.Wzgsfqcz, colsexcept (TIMESTAMP);table dbo.Wzgsdwtz, colsexcept (TIMESTAMP);table dbo.Wzgsjckqk, colsexcept (TIMESTAMP);table dbo.Wzgsczqk, colsexcept (TIMESTAMP);table dbo.Wzgsqtqk, colsexcept (TIMESTAMP);table dbo.ControlledName, colsexcept (TIMESTAMP);table dbo.ControlledEntity, colsexcept (TIMESTAMP);table dbo.t_orgUnits, colsexcept (TIMESTAMP);table dbo.Coin, colsexcept (TIMESTAMP);table dbo.RefDetail, colsexcept (TIMESTAMP);table dbo.EnterpriseType, colsexcept (TIMESTAMP);table dbo.GDAICcode, colsexcept (TIMESTAMP);table dbo.ChangeFieldCnfg, colsexcept (TIMESTAMP);3.2.4 配置表定义脚本，并传输表定义文件一定要通过FTP ASCII方式传输生成的表定义文件。ggsci edit params defgendefsfile /home/sybase/ogg/dirdef/hnsyb.defsourcedb aicbiz, userid oggaic, password oggaictable dbo.TSUPERVISIONHISTORY;table dbo.BUSINESSINFO;table dbo.PAWNITEM;table dbo.TILLEGALRECORD;table dbo.TINSPECTIONLOG;table dbo.TPARTYINFO;table dbo.BROKER;table dbo.BUYER;table dbo.ENTERPRISEFORMONEY_GB;table dbo.TSAMPLECASEINFO;table dbo.ENTITYCURRENTBIZRANGE;table dbo.FCLM_SUPMAGINDICATORS;table dbo.TAFFINFO;table dbo.TAMENDSINFO;table dbo.TAMENDSOPINION;table dbo.TAMENDSAUDITING;table dbo.TCOMPOSEINFO;table dbo.TDECLARATION;table dbo.BROKERHISTORY;table dbo.TSUPERVISIONTASK;table dbo.CASE_FY_ADMREVDECINFO_GB;table dbo.CASE_FY_APPPARTY_GB;table dbo.CASE_SS_LITIGATION_GB;table dbo.WZGSJBQK;table dbo.TMESPRVSNOBJ;table dbo.TCASEJUDGMENT;table dbo.CANCELDEBT;table dbo.RESOUNDBRAND;table dbo.BRANDAPPLY;table dbo.NONPUBPARANLYS;table dbo.ENTITYCURRENTLICENCE;table dbo.TCASEINFO_GB;table dbo.BIZINDIVIDUALINVESTOR;table dbo.ACTIVITY;table dbo.TCASEINFOAPPEND;table dbo.WZGSJYQK;table dbo.ADOUTDOOR;table dbo.MODIFYLOG;table dbo.AD;table dbo.ADPERSON;table dbo.ADEXAMINANT;table dbo.PLEDGE;table dbo.DEBTOR;table dbo.APPLICANTINFO;table dbo.TKEYINFO;table dbo.EXAMINEFIELD;table dbo.WZGSWHQK;table dbo.AFTERAUCTION;table dbo.ADQUALIFICATIONINFO;table dbo.ANNUALBASEINFO;table dbo.AUCTION;table dbo.CURRENTINDIVIDUALINVESTOR;table dbo.CURSTOCKFREEZE;table dbo.CURSTOCKIMPAWN;table dbo.BIZENTITYINFO;table dbo.INVESTEDCAPITAL;table dbo.LIQUIDATEGROUP;table dbo.LIQUIDATEPERSON;table dbo.BRANDPROPOSER;table dbo.BRAND;table dbo.ENTITYBELONG;table dbo.ENTITYVIPLIST;table dbo.MARKETENTITY;table dbo.CANCELOPINION;table dbo.TSUPERVISIONOBJECTINDEX;table dbo.FOODBUSINESSLOC;table dbo.TQUASHCASEAUDITING;table dbo.TCASEINFO;table dbo.ENTITYLEGALREPRESENTATIVE;table dbo.FOODPERMIT;table dbo.FOODPERMITHEA;table dbo.ENTITYNAME;table dbo.BIZINVEST;table dbo.CORPINVESTOR;table dbo.CURFREEZEINVEST;table dbo.CURSTOCKPLEDGE;table dbo.STOCKTRANSFERINFO;table dbo.PERSON;table dbo.MOVEINFO;table dbo.TLAWBREAKING;table dbo.HANDINDESC;table dbo.TAFFAUDITING;table dbo.WZGSFQCZ;table dbo.WZGSDWTZ;table dbo.WZGSJCKQK;table dbo.WZGSCZQK;table dbo.WZGSQTQK;sourcedb aicbas, userid sa, password 123456table dbo.CONTROLLEDNAME;table dbo.CONTROLLEDENTITY;table dbo.T_ORGUNITS;table dbo.COIN;table dbo.REFDETAIL;table dbo.ENTERPRISETYPE;table dbo.GDAICCODE;table dbo.CHANGEFIELDCNFG;3.2.5 配置replicateggsci dblogin userid dbo_aicbiz, password dbo_aicbizggsci add checkpointtable dbo_aicbiz.checkpointggsci add replicat hnrsyb, exttrail d:ogg_oradirdathn, begin now, checkpointtable dbo_aicbiz.checkpointggsci edit params hnrsybreplicat hnrsybreplicat hnrsybsourcedefs d:ogg_oradirdefhnsyb.defuserid dbo_aicbiz, password dbo_aicbizreperror default,discarddiscardfile d:ogg_oradirrpthnsyb.dsc,purge, megabytes 200map dbo.Wzgswhqk, target dbo_aicbiz.Wzgswhqk;map dbo.AfterAuction, target dbo_aicbiz.AfterAuction;map dbo.Ad, target dbo_aicbiz.Ad;map dbo.AdExaminant, target dbo_aicbiz.AdExaminant;map dbo.AdPerson, target dbo_aicbiz.AdPerson;map dbo.ADQualificationInfo, target dbo_aicbiz.ADQualificationInfo;map dbo.AnnualBaseInfo, target dbo_aicbiz.AnnualBaseInfo;map dbo.Auction, target dbo_aicbiz.Auction;map dbo.BizEntityInfo, target dbo_aicbiz.BizEntityInfo;map dbo.BizInvest, target dbo_aicbiz.BizInvest;map dbo.Brand, target dbo_aicbiz.Brand;map dbo.BrandProposer, target dbo_aicbiz.BrandProposer;map dbo.BusinessInfo, target dbo_aicbiz.BusinessInfo;map dbo.CancelOpinion, target dbo_aicbiz.CancelOpinion;map dbo.ControlledName, target dbo_aicbiz.ControlledName;map dbo.CorpInvestor, target dbo_aicbiz.CorpInvestor;map dbo.CurrentIndividualInvestor, target dbo_aicbiz.CurrentIndividualInvestor;map dbo.CurStockFreeze, target dbo_aicbiz.CurStockFreeze;map dbo.CurStockImpawn, target dbo_aicbiz.CurStockImpawn;map dbo.Entitybelong, target dbo_aicbiz.Entitybelong;map dbo.entityLegalRepresentative, target dbo_aicbiz.entityLegalRepresentative;map dbo.EntityName, target dbo_aicbiz.EntityName;map dbo.EntityVIPList, target dbo_aicbiz.EntityVIPList;map dbo.HandinDesc, target dbo_aicbiz.HandinDesc;map dbo.InvestedCapital, target dbo_aicbiz.InvestedCapital;map dbo.LiquidateGroup, target dbo_aicbiz.LiquidateGroup;map dbo.LiquidatePerson, target dbo_aicbiz.LiquidatePerson;map dbo.MarketEntity, target dbo_aicbiz.MarketEntity;map dbo.modifyLog, target dbo_aicbiz.modifyLog;map dbo.MoveInfo, target dbo_aicbiz.MoveInfo;map dbo.PawnItem, target dbo_aicbiz.PawnItem;map dbo.Person, target dbo_aicbiz.Person;map dbo.Pledge, target dbo_aicbiz.Pledge;map dbo.StockTransferInfo, target dbo_aicbiz.StockTransferInfo;map dbo.TAffAuditing, target dbo_aicbiz.TAffAuditing;map dbo.TCaseInfo, target dbo_aicbiz.TCaseInfo;map dbo.TIllegalRecord, target dbo_aicbiz.TIllegalRecord;map dbo.TInspectionLog, target dbo_aicbiz.TInspectionLog;map dbo.TKeyInfo, target dbo_aicbiz.TKeyInfo;map dbo.TLawbreaking, target dbo_aicbiz.TLawbreaking;map dbo.TPartyInfo, target dbo_aicbiz.TPartyInfo;map dbo.TSampleCaseInfo, target dbo_aicbiz.TSampleCaseInfo;map dbo.TSupervisionObjectIndex, target dbo_aicbiz.TSupervisionObjectIndex;map dbo.Wzgsczqk, target dbo_aicbiz.Wzgsczqk;map dbo.Wzgsdwtz, target dbo_aicbiz.Wzgsdwtz;map dbo.Wzgsfqcz, target dbo_aicbiz.Wzgsfqcz;map dbo.Wzgsjbqk, target dbo_aicbiz.Wzgsjbqk;map dbo.Wzgsjyqk, target dbo_aicbiz.Wzgsjyqk;map dbo.Debtor, target dbo_aicbiz.Debtor;map dbo.TMESprvsnObj, target dbo_aicbiz.TMESprvsnObj;map dbo.TCaseJudgment, target dbo_aicbiz.TCaseJudgment;map dbo.TCaseInfoAppend, target dbo_aicbiz.TCaseInfoAppend;map dbo.FoodPermit, target dbo_aicbiz.FoodPermit;map dbo.FoodPermitHea, target dbo_aicbiz.FoodPermitHea;map dbo.ExamineField, target dbo_aicbiz.ExamineField; map dbo.FoodBusinessLoc, target dbo_aicbiz.FoodBusinessLoc;map dbo.BizIndividualInvestor, target dbo_aicbiz.BizIndividualInvestor;map dbo.Wzgsqtqk, target dbo_aicbiz.Wzgsqtqk;map dbo.Wzgsjckqk, target