sql2000数据库导入到mysql

bcp "SELECT * FROM YourTableName" queryout YourTableName.csv -c -t, -T -S YourServerName

CREATE DATABASE YourDatabaseName;
USE YourDatabaseName;

CREATE TABLE YourTableName (
    -- 字段定义
);

LOAD DATA INFILE 'YourTableName.csv'
INTO TABLE YourTableName
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n';

import pyodbc
import csv

# 连接到 SQL Server
conn_sql = pyodbc.connect('DRIVER={SQL Server};SERVER=YourServerName;DATABASE=YourDatabaseName;UID=YourUsername;PWD=YourPassword')
cursor_sql = conn_sql.cursor()

# 执行查询并导出为CSV
cursor_sql.execute("SELECT * FROM YourTableName")
with open('output.csv', 'w', newline='', encoding='utf-8') as csvfile:
    writer = csv.writer(csvfile)
    writer.writerow([i[0] for i in cursor_sql.description])  # 写入列名
    writer.writerows(cursor_sql)

# 连接到 MySQL
conn_mysql = pymysql.connect(host='localhost', user='YourUsername', password='YourPassword', database='YourDatabaseName')
cursor_mysql = conn_mysql.cursor()

# 导入CSV到MySQL
with open('output.csv', 'r', encoding='utf-8') as csvfile:
    reader = csv.reader(csvfile)
    next(reader)  # 跳过列名
    for row in reader:
        placeholders = ', '.join(['%s'] * len(row))
        query = f"INSERT INTO YourTableName VALUES ({placeholders})"
        cursor_mysql.execute(query, row)

conn_mysql.commit()
cursor_mysql.close()
conn_mysql.close()