只用总账的用友T3升级到T6V6的SQL语句

只⽤总账的⽤友T3升级到T6V6的SQL语句
只⽤总账的⽤友T3升级到T6V6.0的语句
以下语句使⽤条件：
1、只⽤总账部分；
2、从⽤友T3V10.6升级到T6V6.0；
3、源数据路径和⽬的数据路径需要⼿⼯修改；
4、加快升级速度，不保证全部都能成功。

--导⼊科⽬表；
insert into
ufdata_004_2012..code(cclass,cclass_engl,cclassany,cclassany_engl,ccode,ccode_name,ccode_en
gl,igrade,bproperty,cbook_type,cbook_type_engl,
chelp,cexch_name,cmeasure,bperson,bcus,bsup,bdept,bitem,cass_item,br,be,cgather,bend,bexc
hange,bcash,bbank,bused,bd_c,dbegin,dend,itrans,bclose,
cother,iotherused,bcDefine1,bcDefine2,bcDefine3,bcDefine4,bcDefine5,bcDefine6,bcDefine7,bc
Define8,bcDefine9,bcDefine10,iViewItem,bGCJS,bCashItem)
select
cclass,cclass_engl,cclassany,cclassany_engl,ccode,ccode_name,ccode_engl,igrade,bproperty,cboo
k_type,cbook_type_engl,
chelp,cexch_name,cmeasure,bperson,bcus,bsup,bdept,bitem,cass_item,br,be,cgather,bend,bexc
hange,bcash,bbank,bused,bd_c,dbegin,dend,itrans,bclose,
cother,iotherused,bcDefine1,bcDefine2,bcDefine3,bcDefine4,bcDefine5,bcDefine6,bcDefine7,bc
Define8,bcDefine9,bcDefine10,iViewItem,bGCJS,bCashItem
from code
--导⼊客户分类；
insert into ufdata_004_2012..customerclass(ccccode,cccname,iccgrade,bccend) select ccccode,cccname,iccgrade,bccend from customerclass
--导⼊客户档案；
insert into
ufdata_004_2012..customer(cCusCode,cCusName,cCusAbbName,cCCCode,cDCCode,cTrade,cCus
Address,cCusPostCode,cCusRegCode,cCusBank,cCusAccount,
dCusDevDate,cCusLPerson,cCusEmail,cCusPerson,cCusPhone,cCusFax,cCusBP,cCusHand,cCusPPer
son,iCusDisRate,cCusCreGrade,iCusCreLine,iCusCreDate,cCusPayCond,
cCusOAddress,cCusOType,cCusHeadCode,cCusWhCode,cCusDepart,iARMoney,dLastDate,iLastMo
ney,dLRDate,iLRMoney,dEndDate,iFrequency,cCusDefine1,cCusDefine2,cCusDefine3, iCostGrade)
select
cCusCode,cCusName,cCusAbbName,cCCCode,cDCCode,cTrade,cCusAddress,cCusPostCode,cCusR
egCode,cCusBank,cCusAccount,
dCusDevDate,cCusLPerson,cCusEmail,cCusPerson,cCusPhone,cCusFax,cCusBP,cCusHand,cCusPPer
son,iCusDisRate,cCusCreGrade,iCusCreLine,iCusCreDate,cCusPayCond,
cCusOAddress,cCusOType,cCusHeadCode,cCusWhCode,cCusDepart,iARMoney,dLastDate,iLastMo
ney,dLRDate,iLRMoney,dEndDate,iFrequency,cCusDefine1,cCusDefine2,cCusDefine3, iCostGrade
from customer
--导⼊供应商分类；
insert into ufdata_004_2012..vendorclass(cvccode,cvcname,ivcgrade,bvcend) select cvccode,cvcname,ivcgrade,bvcend from vendorclass
--导⼊供应商档案；
insert into
ufdata_004_2012..vendor(cVenCode,cVenName,cVenAbbName,cVCCode,cDCCode,cTrade,cVenA
ddress,cVenPostCode,cVenRegCode,cVenBank,cVenAccount,
dVenDevDate,cVenLPerson,cVenPhone,cVenFax,cVenEmail,cVenPerson,cVenBP,cVenHand,cVenPP
erson,iVenDisRate,iVenCreGrade,iVenCreLine,iVenCreDate,
cVenPayCond,cVenIAddress,cVenIType,cVenHeadCode,cVenWhCode,cVenDepart,iAPMoney,dLast
Date,iLastMoney,dLRDate,iLRMoney,dEndDate,iFrequency,bVenTax,
cVenDefine1,cVenDefine2,cVenDefine3)
select
cVenCode,cVenName,cVenAbbName,cVCCode,cDCCode,cTrade,cVenAddress,cVenPostCode,cVen
RegCode,cVenBank,cVenAccount,
dVenDevDate,cVenLPerson,cVenPhone,cVenFax,cVenEmail,cVenPerson,cVenBP,cVenHand,cVenPP
erson,iVenDisRate,iVenCreGrade,iVenCreLine,iVenCreDate,
cVenPayCond,cVenIAddress,cVenIType,cVenHeadCode,cVenWhCode,cVenDepart,iAPMoney,dLast
Date,iLastMoney,dLRDate,iLRMoney,dEndDate,iFrequency,bVenTax,
cVenDefine1,cVenDefine2,cVenDefine3
from vendor
--导⼊部门档案；
insert into
ufdata_004_2012..department(cDepCode,bDepEnd,cDepName,iDepGrade,cDepPerson,cDepProp
,cDepPhone,cDepAddress,cDepMemo)
select
cDepCode,bDepEnd,cDepName,iDepGrade,cDepPerson,cDepProp,cDepPhone,cDepAddress,cDep Memo
from department
--导⼊凭证类别主表；
insert into ufdata_004_2012..dsign(csign,isignseq,ctext,itype,iotherused) select
csign,isignseq,ctext,itype,iotherused from dsign
--导⼊凭证类别⼦表；
insert into ufdata_004_2012..dsigns(csign,ccode) select csign,ccode from dsigns
--导⼊⾃动转账；
insert into
ufdata_004_2012..gl_bautotran(itype,ctran_id,inid,csign,ctext,idoc,ccode,cexch_name,cdigest,cc
us_id,csup_id,cperson_id,cdept_id,citem_class,
citem_id,bd_c,cformula,cformula_s,cformula_f)
select
itype,ctran_id,inid,csign,ctext,idoc,ccode,cexch_name,cdigest,ccus_id,csup_id,cperson_id,cdept_ id,citem_class, citem_id,bd_c,cformula,cformula_s,cformula_f
from gl_bautotran
--导⼊常⽤摘要；
insert into ufdata_004_2012..gl_bdigest(cid,ctext,ccode) select cid,ctext,ccode from gl_bdigest
--导⼊常⽤凭证；
insert into
ufdata_004_2012..gl_bfreq(c_id,inid,csign,ctext,idoc,cdigest,ccode,md,mc,csettle,cdept_id,cpers
on_id,ccus_id,csup_id,citem_id,
citem_class,md_f,mc_f,nfrat,nd_s,nc_s)
select
c_id,inid,csign,ctext,idoc,cdigest,ccode,md,mc,csettle,cdept_id,cperson_id,ccus_id,csup_id,citem _id,
citem_class,md_f,mc_f,nfrat,nd_s,nc_s
from gl_bfreq
--导⼊现⾦流量表；
insert into ufdata_004_2012..gl_cashtable(iPeriod,iSignSeq,iNo_id,inid,cCashItem,md,mc) select
iPeriod,iSignSeq,iNo_id,inid,cCashItem,md,mc from gl_cashtable
delete ufdata_004_2012..gl_mend
--导⼊结账状态表；
insert into
ufdata_004_2012..gl_mend(iperiod,bflag,bcheck,dpri_check,bpri_check,bflag_AP,bflag_AR,bflag_
CA,bflag_FA,bflag_FD,bflag_IA,bflag_PP,
bflag_PU,bflag_RP,bflag_WA,bflag_ST,bflag_SA,bFlag_NB)
select
iperiod,bflag,bcheck,dpri_check,bpri_check,bflag_AP,bflag_AR,bflag_CA,bflag_FA,bflag_FD,bflag_
IA,bflag_PP,
bflag_PU,bflag_RP,bflag_WA,bflag_ST,bflag_SA,bFlag_NB
from gl_mend
--导⼊辅助账；
insert into
ufdata_004_2012..gl_accass(ccode,cexch_name,cdept_id,cperson_id,ccus_id,csup_id,citem_class
,citem_id,iperiod,cbegind_c,cbegind_c_engl,
mb,md,mc,cendd_c,cendd_c_engl,me,mb_f,md_f,mc_f,me_f,nb_s,nd_s,nc_s,ne_s)
select
ccode,cexch_name,cdept_id,cperson_id,ccus_id,csup_id,citem_class,citem_id,iperiod,cbegind_c, cbegind_c_engl,
mb,md,mc,cendd_c,cendd_c_engl,me,mb_f,md_f,mc_f,me_f,nb_s,nd_s,nc_s,ne_s
from gl_accass
--导⼊总账；
insert into
ufdata_004_2012..gl_accsum(ccode,cexch_name,iperiod,cbegind_c,cbegind_c_engl,mb,md,mc,c
endd_c,cendd_c_engl,me,mb_f,md_f,mc_f,me_f,nb_s,nd_s,nc_s,ne_s)
select
ccode,cexch_name,iperiod,cbegind_c,cbegind_c_engl,mb,md,mc,cendd_c,cendd_c_engl,me,mb
_f,md_f,mc_f,me_f,nb_s,nd_s,nc_s,ne_s
from gl_accsum
--导⼊凭证；
insert into
ufdata_004_2012..gl_accvouch(iperiod,csign,isignseq,ino_id,inid,dbill_date,idoc,cbill,ccheck,cbo
ok,ibook,ccashier,iflag,ctext1,ctext2,cdigest,
ccode,cexch_name,md,mc,md_f,mc_f,nfrat,nd_s,nc_s,csettle,cn_id,dt_date,cdept_id,cperson_id,
ccus_id,csup_id,citem_id,citem_class,cname,ccode_equal,
iflagbank,iflagPerson,bdelete,coutaccset,ioutyear,coutsysname,coutsysver,doutbilldate,ioutperio
d,coutsign,coutno_id,doutdate,coutbillsign,coutid,
bvouchedit,bvouchAddordele,bvouchmoneyhold,bvalueedit,bcodeedit,ccodecontrol,bPCSedit,bD eptedit,bItemedit,bCusSupInput,cDefine1,cDefine2,cDefine3,
cDefine4,cDefine5,cDefine6,cDefine7,cDefine8,cDefine9,cDefine10)
select
iperiod,csign,isignseq,ino_id,inid,dbill_date,idoc,cbill,ccheck,cbook,ibook,ccashier,iflag,ctext1,cte xt2,cdigest, ccode,cexch_name,md,mc,md_f,mc_f,nfrat,nd_s,nc_s,csettle,cn_id,dt_date,cdept_id,cperson_id,
ccus_id,csup_id,citem_id,citem_class,cname,ccode_equal,
iflagbank,iflagPerson,bdelete,coutaccset,ioutyear,coutsysname,coutsysver,doutbilldate,ioutperio
d,coutsign,coutno_id,doutdate,coutbillsign,coutid,
bvouchedit,bvouchAddordele,bvouchmoneyhold,bvalueedit,bcodeedit,ccodecontrol,bPCSedit,bD eptedit,bItemedit,bCusSupInput,cDefine1,cDefine2,cDefine3,
cDefine4,cDefine5,cDefine6,cDefine7,cDefine8,cDefine9,cDefine10
from gl_accvouch。