运用navicat将oracle表结构转换为mysql表结构

文档课题：运用navicat将oracle表结构转换为mysql表结构.

源端数据库：oracle 19.13

目标端数据库：mysql 8.0.27

navicat连接oracle与mysql，点击"工具"选项，选择"数据传输"选项. 

oracle端建表语句如下：

rptuser@TMIS> create table fruits

(

f_id varchar2(10) not null,

s_id number(38) not null,

f_name varchar2(255) not null,

f_price number(8,2) not null,

primary key(f_id)

);

 

rptuser@TMIS> create table books

(

bk_id number(38) not null primary key,

bk_title varchar2(50) not null,

copyright date not null

  6  );

 

自动转换为mysql建表语句如下：

SET NAMES utf8;

SET FOREIGN_KEY_CHECKS = 0;

 

-- ----------------------------

-- Table structure for BOOKS

-- ----------------------------

DROP TABLE IF EXISTS `BOOKS`;

CREATE TABLE `BOOKS`  (

  `BK_ID` decimal(38, 0) NOT NULL,

  `BK_TITLE` varchar(50) NOT NULL,

  `COPYRIGHT` datetime NOT NULL,

  PRIMARY KEY (`BK_ID`)

);

 

-- ----------------------------

-- Table structure for FRUITS

-- ----------------------------

DROP TABLE IF EXISTS `FRUITS`;

CREATE TABLE `FRUITS`  (

  `F_ID` varchar(10) NOT NULL,

  `S_ID` decimal(65, 30) NOT NULL,

  `F_NAME` varchar(255) NOT NULL,

  `F_PRICE` decimal(8, 2) NOT NULL,

  PRIMARY KEY (`F_ID`)

);

 

SET FOREIGN_KEY_CHECKS = 1;