SQL Server 迁移助手 (SSMA)：错误 [22018] [MySQL][ODBC 5.3(a) 驱动程序][mysqld-5.1.51-commun

SQL Server 迁移助手 (SSMA)：错误 [22018] [MySQL][ODBC 5.3(a) 驱动程序][mysqld-5.1.51-community]

sql
-- 创建测试表
CREATE TABLE Customers (
    CustomerID INT PRIMARY KEY,
    CustomerName VARCHAR(50),
    Age INT,
    Email VARCHAR(50)
);
-- 插入示例数据
INSERT INTO Customers (CustomerID, CustomerName, Age, Email)
VALUES (1, 'John Doe', '30', 'johndoe@example.com'),
       (2, 'Jane Smith', '25', 'janesmith@example.com'),
       (3, 'Mike Johnson', '35', 'mikejohnson@example.com');
-- 将数据从 MySQL 迁移到 SQL Server
SELECT * INTO dbo.Customers FROM Customers;
-- 检查数据类型不匹配的字段
SELECT COLUMN_NAME, DATA_TYPE
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'Customers' AND DATA_TYPE NOT IN ('INT', 'VARCHAR');
-- 修改数据类型不匹配的字段
ALTER TABLE dbo.Customers
ALTER COLUMN Age INT;
-- 再次检查数据类型不匹配的字段
SELECT COLUMN_NAME, DATA_TYPE
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'Customers' AND DATA_TYPE NOT IN ('INT', 'VARCHAR');
-- 数据迁移完成