oracle sql developer 移植数据库ITeye - 亚美娱乐

oracle sql developer 移植数据库ITeye

2019年02月18日09时46分24秒 | 作者: 孤风 | 标签: 组件,端口,补丁 | 浏览: 2655

1.增加第三方组件jdts 在更新中挑选

2.承认sql 1433端口开 (sql2000 打上sp4补丁)
运转-cmd-netstat/na

3.prepare for the migration
a)create migrate user
create user
CREATE USER migration IDENTIFIED BY migration
DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp;
grant
GRANT CONNECT, RESOURCE, CREATE VIEW, CREATE PUBLIC SYNONYM TO migration WITH ADMIN OPTION;
GRANT ALTER ANY ROLE, ALTER ANY SEQUENCE,
ALTER ANY TABLE, ALTER TABLESPACE, ALTER ANY TRIGGER,
COMMENT ANY TABLE, CREATE ANY SEQUENCE, CREATE ANY TABLE,
CREATE ANY TRIGGER, CREATE ROLE, CREATE TABLESPACE,
CREATE USER, DROP ANY SEQUENCE, DROP ANY TABLE,
DROP ANY TRIGGER, DROP TABLESPACE, DROP USER,
DROP ANY ROLE, GRANT ANY ROLE, INSERT ANY TABLE,
SELECT ANY TABLE, UPDATE ANY TABLE TO migration;
处理用户migration不能登录的问题
GRANT CREATE SESSION TO migration WITH ADMIN OPTION;


a)sql developer-migration-repository management-create repository
b)associate migration repository

capture mssql server-convert to oracle
convert modelgenerate履行ddl
convert model-move data


版权声明
本文来源于网络,版权归原作者所有,其内容与观点不代表亚美娱乐立场。转载文章仅为传播更有价值的信息,如采编人员采编有误或者版权原因,请与我们联系,我们核实后立即修改或删除。

猜您喜欢的文章