sqlserver导出数据库 mysql

import pyodbc
import subprocess

# 连接到SQL Server
conn = pyodbc.connect('DRIVER={SQL Server};SERVER=your_server;DATABASE=your_database;UID=your_username;PWD=your_password')
cursor = conn.cursor()

# 生成SQL脚本
cursor.execute("SELECT * FROM sys.tables")
tables = cursor.fetchall()

for table in tables:
    table_name = table[0]
    with open(f"{table_name}.sql", "w") as f:
        cursor.execute(f"SELECT * INTO OUTFILE 'C:\\path\\to\\{table_name}.csv' FROM {table_name}")
        f.write(f"DROP TABLE IF EXISTS `{table_name}`;\n")
        cursor.execute(f"SHOW CREATE TABLE {table_name}")
        create_table_sql = cursor.fetchone()[1]
        f.write(create_table_sql + ";\n")
        cursor.execute(f"SELECT * FROM {table_name}")
        rows = cursor.fetchall()
        for row in rows:
            f.write(f"INSERT INTO `{table_name}` VALUES ({','.join(['%s']*len(row))});\n" % tuple(row))

# 关闭连接
cursor.close()
conn.close()