mysql数据转为oracle

-- MySQL
CREATE TABLE users (
    id INT PRIMARY KEY,
    name VARCHAR(255)
);

-- Oracle
CREATE TABLE users (
    id NUMBER PRIMARY KEY,
    name VARCHAR2(255)
);

# MySQL导出数据时指定字符集
mysqldump -u username -p --default-character-set=utf8 database_name > dump.sql

ALTER SYSTEM SET NLS_CHARACTERSET = 'AL32UTF8';

-- MySQL存储过程
DELIMITER //
CREATE PROCEDURE get_user(IN user_id INT)
BEGIN
    SELECT * FROM users WHERE id = user_id;
END //
DELIMITER ;

-- Oracle存储过程
CREATE OR REPLACE PROCEDURE get_user(user_id IN NUMBER) IS
BEGIN
    SELECT * FROM users WHERE id = user_id;
END;

mysqldump -u username -p --default-character-set=utf8 database_name > dump.sql

import re

def convert_mysql_to_oracle(sql):
    # 替换数据类型
    sql = re.sub(r'INT', 'NUMBER', sql)
    sql = re.sub(r'VARCHAR\((\d+)\)', r'VARCHAR2(\1)', sql)
    # 其他转换逻辑...
    return sql

with open('dump.sql', 'r') as file:
    mysql_sql = file.read()

oracle_sql = convert_mysql_to_oracle(mysql_sql)

with open('converted_dump.sql', 'w') as file:
    file.write(oracle_sql)

sqlplus username/password@oracle_instance @converted_dump.sql