接到一个维护项目，需要升级40套用友畅捷通T3数据到U8，通常数据升级总会遇到各种各样的报错，这次遇到的问题在百度也没有找到解决办法。撸起袖子追踪数据库语句，终于发现了控制参数，写一个脚本。希望对后来人有帮助。在每个数据库下执行以下语句 UPDATE accinformation SET cValue = ‘False’ WHERE cSysID = ‘SA’ And cName = ‘bOptimized’ go update accinformation set cValue=‘1’ where cName=‘iOpFlow’ and cSysId=‘PU’ go UPDATE accinformation SET cValue = 'False' WHERE cSysID = 'SA' And cName = 'bOptimized' go update accinformation set cValue='1' where cName='iOpFlow' and cSysId='PU' go if(window.hljsLoader && !document.currentScript.parentNode.hasAttribute('data-s9e-livepreview-onupdate')) { window.hljsLoader.highlightBlocks(document.currentScript.parentNode); }

可能在T3转T6时提示摘要过多处理语句 DELETE TOP (20000) FROM GL_bfreq DELETE TOP (20000) FROM GL_blreq if(window.hljsLoader && !document.currentScript.parentNode.hasAttribute('data-s9e-livepreview-onupdate')) { window.hljsLoader.highlightBlocks(document.currentScript.parentNode); }

T3升级T6，用的升级工具提示此T3账套采购或销售是优化流程，不支持升级

用友小张

接到一个维护项目，需要升级40套用友畅捷通T3数据到U8，通常数据升级总会遇到各种各样的报错，这次遇到的问题在百度也没有找到解决办法。撸起袖子追踪数据库语句，终于发现了控制参数，写一个脚本。希望对后来人有帮助。

在每个数据库下执行以下语句

UPDATE accinformation SET cValue = ‘False’ WHERE cSysID = ‘SA’ And cName = ‘bOptimized’

update accinformation set cValue=‘1’ where cName=‘iOpFlow’ and cSysId=‘PU’

UPDATE accinformation SET cValue = 'False' WHERE cSysID = 'SA' And cName = 'bOptimized'

go

update accinformation set cValue='1' where cName='iOpFlow' and cSysId='PU'

go

用友小张

可能在T3转T6时提示摘要过多处理语句

DELETE TOP (20000)  FROM         GL_bfreq

DELETE TOP (20000)   FROM         GL_blreq