mysql 可以连接到 sql 服务器吗

<code class="python">import mysql.connector
import pyodbc
import csv

# MySQL 连接配置
mysql_config = {
    'user': 'your_mysql_user',
    'password': 'your_mysql_password',
    'host': 'your_mysql_host',
    'database': 'your_mysql_database'
}

# SQL Server 连接配置
sqlserver_config = {
    'server': 'your_sqlserver_server',
    'database': 'your_sqlserver_database',
    'uid': 'your_sqlserver_user',
    'pwd': 'your_sqlserver_password'
}

# 从 MySQL 导出数据到 CSV 文件
def export_to_csv(filename, query):
    mydb = mysql.connector.connect(**mysql_config)
    cursor = mydb.cursor()
    cursor.execute(query)
    results = cursor.fetchall()
    with open(filename, 'w', newline='') as csvfile:
        writer = csv.writer(csvfile)
        writer.writerow([i[0] for i in cursor.description]) # 写入表头
        writer.writerows(results)
    mydb.close()

# 从 CSV 文件导入到 SQL Server
def import_from_csv(filename, table_name):
    conn = pyodbc.connect('DRIVER={ODBC Driver 17 for SQL Server};SERVER=' + sqlserver_config['server'] + ';DATABASE=' + sqlserver_config['database'] + ';UID=' + sqlserver_config['uid'] + ';PWD=' + sqlserver_config['pwd'])
    cursor = conn.cursor()
    with open(filename, 'r') as file:
        reader = csv.reader(file)
        next(reader) # 跳过表头
        for row in reader:
            cursor.execute("INSERT INTO " + table_name + " VALUES (" + ','.join(['?'] * len(row)) + ")", row)
    conn.commit()
    conn.close()

# 示例用法
export_to_csv('data.csv', "SELECT * FROM your_mysql_table")
import_from_csv('data.csv', 'your_sqlserver_table')
</code>