达梦数据库 - 使用DM数据迁移工具迁移CSFrameworkV6数据库|C/S框架网
达梦数据库 - 使用DM数据迁移工具迁移CSFrameworkV6数据库
目录
迁移流程
新建模式 -> 新建表空间 -> 迁移数据库到对应的模式 -> 更改表空间
1、运行 DM管理工具新建模式
新建 CSFrameworkV6_System、 CSFrameworkV6_Normal 两个模式
操作步骤：https://www.cscode.net/archive/newdoc/608552765227013.html#mcetoc_1ibt407b6k
新建 CSFrameworkV6_System、 CSFrameworkV6_Normal 两个表空间
操作步骤：https://www.cscode.net/archive/newdoc/608552765227013.html#mcetoc_1ibt3c9afn
2、运行 DM数据迁移工具
3、新建工程、新建迁移
1、新建工程，输入名称：CSFRAMEWORKV6_TO_DM，点【确定】
2、【迁移】节点右键弹出菜单，点【新建迁移】，在【迁移名称】输入：迁移CSFrameworkV6数据库，点【确定】
操作完成后：
双击【SQLServer ==> DM】数据源
4、【刷新】数据库报错解决方案
解决方案
修改达梦数据库对应文件：C:\Program Files\dmdbms\jdk\jre\lib\security\java.security
（修改前建议备份一下文件）
原始值(修改前)
HTML 全选
jdk.tls.disabledAlgorithms=SSLv3, TLSv1, TLSv1.1, RC4, DES, MD5withRSA, \
DH keySize < 1024, EC keySize < 224, 3DES_EDE_CBC, anon, NULL, \
include jdk.disabled.namedCurves删除安全级别低的算法(修改后)
HTML 全选
jdk.tls.disabledAlgorithms=SSLv3, RC4, DES, MD5withRSA, \
DH keySize < 1024, EC keySize < 224, anon, NULL, \
include jdk.disabled.namedCurves修改后重启DM数据迁移工具。
若迁移失败（如表结构原因），处理完后可以【重新执行】
打开DM管理工具，查看模式下的表，迁移成功。
5、更改表空间
生成Sql脚本
C# 全选
--查询用户表
SELECT * FROM USER_TABLES where TABLESPACE_NAME='MAIN';
SELECT * FROM USER_TABLES ORDER BY TABLESPACE_NAME
--生成移动表空间的SQL脚本
SELECT 'alter table "CSFrameworkV6_Normal"."' || TABLE_NAME || '" move tablespace "CSFrameworkV6_Normal";' FROM USER_TABLES where TABLESPACE_NAME='MAIN';
SELECT 'alter table "CSFrameworkV6_System"."' || TABLE_NAME || '" move tablespace "CSFrameworkV6_System";' FROM USER_TABLES where TABLESPACE_NAME='MAIN';系统数据库
SQL语法
C# 全选
alter table "CSFrameworkV6_System"."sys_BackupHistory" move tablespace "CSFrameworkV6_System";参数说明：
- "CSFrameworkV6_System"."sys_BackupHistory" 是表名，格式：迁移数据库后选择的schema+表名。
- "CSFrameworkV6_System" 是空间名。
一张物理表对应一个表空间，Table --->1..1 TableSpace
一个表空间有多张物理表，TableSpace ---> 1..n Table
C# 全选
alter table "CSFrameworkV6_System"."sys_BackupHistory" move tablespace "CSFrameworkV6_System";
alter table "CSFrameworkV6_System"."sys_DocType" move tablespace "CSFrameworkV6_System";
alter table "CSFrameworkV6_System"."sys_FieldNameDefs" move tablespace "CSFrameworkV6_System";
alter table "CSFrameworkV6_System"."sys_GeneratorConfig_DevExpress" move tablespace "CSFrameworkV6_System";
alter table "CSFrameworkV6_System"."sys_GeneratorConfig_NetFramework" move tablespace "CSFrameworkV6_System";
alter table "CSFrameworkV6_System"."sys_LanguageCulture" move tablespace "CSFrameworkV6_System";
alter table "CSFrameworkV6_System"."sys_LanguageData" move tablespace "CSFrameworkV6_System";
alter table "CSFrameworkV6_System"."sys_LogData" move tablespace "CSFrameworkV6_System";
alter table "CSFrameworkV6_System"."sys_LogLogin" move tablespace "CSFrameworkV6_System";
alter table "CSFrameworkV6_System"."sys_LogOperation" move tablespace "CSFrameworkV6_System";
alter table "CSFrameworkV6_System"."sys_Message" move tablespace "CSFrameworkV6_System";
alter table "CSFrameworkV6_System"."sys_MSG_Queue" move tablespace "CSFrameworkV6_System";
alter table "CSFrameworkV6_System"."sys_MSG_Read" move tablespace "CSFrameworkV6_System";
alter table "CSFrameworkV6_System"."sys_SystemSettings" move tablespace "CSFrameworkV6_System";
alter table "CSFrameworkV6_System"."sys_SystemSettingsByUser" move tablespace "CSFrameworkV6_System";
alter table "CSFrameworkV6_System"."sys_UserCustomAction" move tablespace "CSFrameworkV6_System";
alter table "CSFrameworkV6_System"."tb_DataSet" move tablespace "CSFrameworkV6_System";
alter table "CSFrameworkV6_System"."tb_Factory" move tablespace "CSFrameworkV6_System";
alter table "CSFrameworkV6_System"."tb_MyActions" move tablespace "CSFrameworkV6_System";
alter table "CSFrameworkV6_System"."tb_MyFormTagName" move tablespace "CSFrameworkV6_System";
alter table "CSFrameworkV6_System"."tb_MyGroup" move tablespace "CSFrameworkV6_System";
alter table "CSFrameworkV6_System"."tb_MyGroupRole" move tablespace "CSFrameworkV6_System";
alter table "CSFrameworkV6_System"."tb_MyGroupUser" move tablespace "CSFrameworkV6_System";
alter table "CSFrameworkV6_System"."tb_MyMenu" move tablespace "CSFrameworkV6_System";
alter table "CSFrameworkV6_System"."tb_MyRole" move tablespace "CSFrameworkV6_System";
alter table "CSFrameworkV6_System"."tb_MyRoleActions" move tablespace "CSFrameworkV6_System";
alter table "CSFrameworkV6_System"."tb_MyRoleSystemDefaut" move tablespace "CSFrameworkV6_System";
alter table "CSFrameworkV6_System"."tb_MyUser" move tablespace "CSFrameworkV6_System";
alter table "CSFrameworkV6_System"."tb_MyUserRoles" move tablespace "CSFrameworkV6_System";
账套数据库
C# 全选
alter table "CSFrameworkV6_Normal"."tb_AP" move tablespace "CSFrameworkV6_Normal";
alter table "CSFrameworkV6_Normal"."tb_APs" move tablespace "CSFrameworkV6_Normal";
alter table "CSFrameworkV6_Normal"."tb_AR" move tablespace "CSFrameworkV6_Normal";
alter table "CSFrameworkV6_Normal"."tb_ARs" move tablespace "CSFrameworkV6_Normal";
alter table "CSFrameworkV6_Normal"."tb_AttachFile" move tablespace "CSFrameworkV6_Normal";
alter table "CSFrameworkV6_Normal"."tb_BOM" move tablespace "CSFrameworkV6_Normal";
alter table "CSFrameworkV6_Normal"."tb_BOMList" move tablespace "CSFrameworkV6_Normal";
alter table "CSFrameworkV6_Normal"."tb_DO" move tablespace "CSFrameworkV6_Normal";
alter table "CSFrameworkV6_Normal"."tb_DOs" move tablespace "CSFrameworkV6_Normal";
alter table "CSFrameworkV6_Normal"."tb_IA" move tablespace "CSFrameworkV6_Normal";
alter table "CSFrameworkV6_Normal"."tb_IAs" move tablespace "CSFrameworkV6_Normal";
alter table "CSFrameworkV6_Normal"."tb_IC" move tablespace "CSFrameworkV6_Normal";
alter table "CSFrameworkV6_Normal"."tb_ICs" move tablespace "CSFrameworkV6_Normal";
alter table "CSFrameworkV6_Normal"."tb_IN" move tablespace "CSFrameworkV6_Normal";
alter table "CSFrameworkV6_Normal"."tb_INs" move tablespace "CSFrameworkV6_Normal";
alter table "CSFrameworkV6_Normal"."tb_Inventory" move tablespace "CSFrameworkV6_Normal";
alter table "CSFrameworkV6_Normal"."tb_InventoryLog" move tablespace "CSFrameworkV6_Normal";
alter table "CSFrameworkV6_Normal"."tb_IO" move tablespace "CSFrameworkV6_Normal";
alter table "CSFrameworkV6_Normal"."tb_IOs" move tablespace "CSFrameworkV6_Normal";
alter table "CSFrameworkV6_Normal"."tb_IT" move tablespace "CSFrameworkV6_Normal";
alter table "CSFrameworkV6_Normal"."tb_ITs" move tablespace "CSFrameworkV6_Normal";
alter table "CSFrameworkV6_Normal"."tb_IV" move tablespace "CSFrameworkV6_Normal";
alter table "CSFrameworkV6_Normal"."tb_IVs" move tablespace "CSFrameworkV6_Normal";
alter table "CSFrameworkV6_Normal"."tb_MultiKeyTestDetail" move tablespace "CSFrameworkV6_Normal";
alter table "CSFrameworkV6_Normal"."tb_MultiKeyTestMaster" move tablespace "CSFrameworkV6_Normal";
alter table "CSFrameworkV6_Normal"."tb_PD" move tablespace "CSFrameworkV6_Normal";
alter table "CSFrameworkV6_Normal"."tb_PDs" move tablespace "CSFrameworkV6_Normal";
alter table "CSFrameworkV6_Normal"."tb_PF" move tablespace "CSFrameworkV6_Normal";
alter table "CSFrameworkV6_Normal"."tb_PFProcess" move tablespace "CSFrameworkV6_Normal";
alter table "CSFrameworkV6_Normal"."tb_PFs" move tablespace "CSFrameworkV6_Normal";
alter table "CSFrameworkV6_Normal"."tb_PN" move tablespace "CSFrameworkV6_Normal";
alter table "CSFrameworkV6_Normal"."tb_PNDtlA" move tablespace "CSFrameworkV6_Normal";
alter table "CSFrameworkV6_Normal"."tb_PNDtlASub" move tablespace "CSFrameworkV6_Normal";
alter table "CSFrameworkV6_Normal"."tb_PNDtlB" move tablespace "CSFrameworkV6_Normal";
alter table "CSFrameworkV6_Normal"."tb_PO" move tablespace "CSFrameworkV6_Normal";
alter table "CSFrameworkV6_Normal"."tb_POs" move tablespace "CSFrameworkV6_Normal";
alter table "CSFrameworkV6_Normal"."tb_PR" move tablespace "CSFrameworkV6_Normal";
alter table "CSFrameworkV6_Normal"."tb_Process" move tablespace "CSFrameworkV6_Normal";
alter table "CSFrameworkV6_Normal"."tb_ProcessPrice" move tablespace "CSFrameworkV6_Normal";
alter table "CSFrameworkV6_Normal"."tb_ProcessWorkReport" move tablespace "CSFrameworkV6_Normal";
alter table "CSFrameworkV6_Normal"."tb_PRs" move tablespace "CSFrameworkV6_Normal";
alter table "CSFrameworkV6_Normal"."tb_QO" move tablespace "CSFrameworkV6_Normal";
alter table "CSFrameworkV6_Normal"."tb_QOs" move tablespace "CSFrameworkV6_Normal";
alter table "CSFrameworkV6_Normal"."tb_SO" move tablespace "CSFrameworkV6_Normal";
alter table "CSFrameworkV6_Normal"."tb_SOs" move tablespace "CSFrameworkV6_Normal";
alter table "CSFrameworkV6_Normal"."tb_SR" move tablespace "CSFrameworkV6_Normal";
alter table "CSFrameworkV6_Normal"."tb_SRs" move tablespace "CSFrameworkV6_Normal";
alter table "CSFrameworkV6_Normal"."tb_SU_Ex" move tablespace "CSFrameworkV6_Normal";
alter table "CSFrameworkV6_Normal"."tb_SUs_Ex" move tablespace "CSFrameworkV6_Normal";
alter table "CSFrameworkV6_Normal"."tb_YK" move tablespace "CSFrameworkV6_Normal";
alter table "CSFrameworkV6_Normal"."tb_YKs" move tablespace "CSFrameworkV6_Normal";
alter table "CSFrameworkV6_Normal"."ZX_CostSummary" move tablespace "CSFrameworkV6_Normal";
alter table "CSFrameworkV6_Normal"."ZX_Eval" move tablespace "CSFrameworkV6_Normal";
alter table "CSFrameworkV6_Normal"."ZX_EvalProduct" move tablespace "CSFrameworkV6_Normal";
alter table "CSFrameworkV6_Normal"."ZX_EvalProductDtl" move tablespace "CSFrameworkV6_Normal";
alter table "CSFrameworkV6_Normal"."ZX_Process" move tablespace "CSFrameworkV6_Normal";
alter table "CSFrameworkV6_Normal"."_Demo_Customer" move tablespace "CSFrameworkV6_Normal";
alter table "CSFrameworkV6_Normal"."_Demo_IN" move tablespace "CSFrameworkV6_Normal";
alter table "CSFrameworkV6_Normal"."_Demo_INs" move tablespace "CSFrameworkV6_Normal";
alter table "CSFrameworkV6_Normal"."_Demo_INV" move tablespace "CSFrameworkV6_Normal";
alter table "CSFrameworkV6_Normal"."_Demo_INVs" move tablespace "CSFrameworkV6_Normal";
alter table "CSFrameworkV6_Normal"."_Demo_Product" move tablespace "CSFrameworkV6_Normal";
alter table "CSFrameworkV6_Normal"."_Demo_Supplier" move tablespace "CSFrameworkV6_Normal";
alter table "CSFrameworkV6_Normal"."_Demo_Supplier2" move tablespace "CSFrameworkV6_Normal";
版权声明：本文为开发框架文库发布内容,转载请附上原文出处连接
NewDoc C/S框架网
