Sybase到oracleOGG實(shí)施文檔.docx

Sybase到oracle OGG實(shí)施文檔1 結(jié)構(gòu)圖1.1 源機(jī)器IP:48 數(shù)據(jù)庫產(chǎn)品：Sybase端口號(hào)：7220用戶名：sa 密碼：123456數(shù)據(jù)庫：aicbas/aicbiz1.2 目的機(jī)器IP:52 數(shù)據(jù)庫產(chǎn)品：oracle端口號(hào)：1521用戶名：dbo_aicbiz 密碼：dbo_aicbiz數(shù)據(jù)庫：orcl2 環(huán)境說明源端一服務(wù)器地址：44，用戶名：root，口令：1234567，操作系統(tǒng)為Linux，數(shù)據(jù)庫為Sybase 12.5，在操作系統(tǒng)上設(shè)置了sybase用戶，數(shù)據(jù)庫安裝在/home/sybase目錄下，OGG安裝在/home/sybase/ogg目錄下，訪問OGG時(shí)需要先切換到sybase用戶下，否則環(huán)境變量不生效。Sybase生產(chǎn)庫需要同步95張表，分布在Sybase的aicbiz和aicbas兩個(gè)庫中。源端二服務(wù)器地址：99，用戶名：root，口令：12345678，操作系統(tǒng)為Linux，且為虛擬機(jī)，數(shù)據(jù)庫為Oracle 10g，在操作系統(tǒng)上設(shè)置了oracle用戶，數(shù)據(jù)庫安裝在/u01/oracle目錄下，OGG安裝在/u01/ogg目錄下，訪問OGG時(shí)需要先切換到oracle用戶下，否則環(huán)境變量不生效。12315數(shù)據(jù)庫需要同步4張表。運(yùn)行ogg的ggsci命令必須在/home/sybase/ogg或/u01/ogg目錄下，也就是說，必須在ogg的安裝目錄下，否則ggsci不能正確讀取配置信息。由于Sybase數(shù)據(jù)庫里會(huì)在數(shù)據(jù)表里自動(dòng)生成TIMESTAMP列，Oracle數(shù)據(jù)庫中不支持此數(shù)據(jù)類型，而且此列也沒有用處，所以在數(shù)據(jù)抽取過程中要忽略此列，因此，在extract配置文件中需要增加colsexcept （TIMESTAMP）參數(shù)。3 Sybase生產(chǎn)庫安裝配置過程及腳本3.1 Sybase生產(chǎn)庫環(huán)境準(zhǔn)備（1）在Sybase數(shù)據(jù)庫上創(chuàng)建用戶oggaic，并賦予sa_role和replication_role權(quán)限。sp_role grant, sa_role, oggaicsp_role grant,replication_role, oggaic（2）打開本地日志dbcc settrunc （ltm， valid）（2）為sybase數(shù)據(jù)庫需復(fù)制的表打開log復(fù)制ggsci dblogin sourcedb aicbiz, userid oggaic, password oggaic3.2 生產(chǎn)庫配置過程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