清行陌华的博客

达梦数据迁移工具-新建迁移-选择输入用户名、密码，点击指定驱动 驱动路径：点击浏览，根据具体oracle安装路径，选择ojdbc5.jar，如234上的：D:\app\lenovo\product\11.2.0\dbhome_1\jdbc\lib\ojdbc5.jar 驱动类名：自动获取 URL：以234为例jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 10.13.1.234)(PORT = 1521...

简单迁移：如果表结构简单，数据不需要特殊处理，直接换一下字段名或者多表联查出想要的字段直接用insert into …select即可。如：insert into "QY"."REGISTER" ("ID","CODE","TYPE","AREA","PROVINCE")select "CODE","CODE","LX","DQ","SF" from "QYTEST"."XF_REGISTER"复杂迁移：1.需要梳理原系统业务逻辑，登录老系统，操作系统数据同时观察数...