简单迁移:
如果表结构简单,数据不需要特殊处理,直接换一下字段名或者多表联查出想要的字段
直接用insert into …select 即可。
如:
insert into "QY"."REGISTER" ("ID","CODE","TYPE","AREA","PROVINCE")
select "CODE","CODE","LX","DQ","SF" from "QYTEST"."XF_REGISTER"
如果表结构简单,数据不需要特殊处理,直接换一下字段名或者多表联查出想要的字段
直接用insert into …select 即可。
如:
insert into "QY"."REGISTER" ("ID","CODE","TYPE","AREA","PROVINCE")
select "CODE","CODE","LX","DQ","SF" from "QYTEST"."XF_REGISTER"