# 步骤1：创建Azure Database Migration Service
# 在Azure门户中创建迁移服务

# 步骤2：评估数据库
# 使用Azure Database Migration Assistant评估数据库

# 步骤3：准备目标环境
# 创建Azure SQL Database

# 步骤4：执行迁移
# 使用Azure Database Migration Service执行迁移

# 使用AWS Database Migration Service迁移到AWS RDS

# 步骤1：创建AWS DMS复制实例
aws dms create-replication-instance \
–replication-instance-identifier fgedu-dms-instance \
–allocated-storage 50 \
–engine-version 3.4.6 \
–region us-east-1 \
–replication-instance-class dms.t3.medium

# 步骤2：创建源端点
aws dms create-endpoint \
–endpoint-identifier fgedu-source-endpoint \
–endpoint-type source \
–engine-name sqlserver \
–username fgedu \
–password FgEdu123!@# \
–server-name fgedu1.fgedu.net.cn \
–port 1433 \
–database-name fgedudb

# 步骤3：创建目标端点
aws dms create-endpoint \
–endpoint-identifier fgedu-target-endpoint \
–endpoint-type target \
–engine-name sqlserver \
–username fgedu \
–password FgEdu123!@# \
–server-name fgedu-rds.c9xyz.us-east-1.rds.amazonaws.com \
–port 1433 \
–database-name fgedudb

# 步骤4：创建迁移任务
aws dms create-replication-task \
–replication-task-identifier fgedu-migration-task \
–source-endpoint-arn arn:aws:dms:us-east-1:123456789012:endpoint:source-endpoint \
–target-endpoint-arn arn:aws:dms:us-east-1:123456789012:endpoint:target-endpoint \
–replication-instance-arn arn:aws:dms:us-east-1:123456789012:rep:fgedu-dms-instance \
–migration-type full-load-and-cdc \
–table-mappings ‘{“rules”:[{“rule-type”:”selection”,”rule-id”:”1″,”rule-name”:”1″,”object-locator”:{“schema-name”:”dbo”,”table-name”:”%”},”rule-action”:”include”}]}’

# 步骤5：启动迁移任务
aws dms start-replication-task \
–replication-task-arn arn:aws:dms:us-east-1:123456789012:task:fgedu-migration-task \
–start-replication-task-type start-replication

# 步骤1：备份本地数据库
BACKUP DATABASE fgedudb TO DISK = ‘\\fgedu1\backup\fgedudb_full.bak’ WITH INIT, COMPRESSION;
GO

# 步骤2：将备份文件上传到云存储
# 例如，上传到Azure Blob存储
az storage blob upload \
–account-name fgedustorage \
–container-name backups \
–name fgedudb_full.bak \
–file \\fgedu1\backup\fgedudb_full.bak

# 步骤3：从备份还原到云数据库
# 在Azure SQL Managed Instance中还原
RESTORE DATABASE fgedudb FROM URL = ‘https://fgedustorage.blob.core.windows.net/backups/fgedudb_full.bak’ WITH MOVE ‘fgedudb’ TO ‘/var/opt/mssql/data/fgedudb.mdf’, MOVE ‘fgedudb_log’ TO ‘/var/opt/mssql/data/fgedudb_log.ldf’;
GO

# 步骤4：验证数据完整性
— 检查数据库对象
SELECT name, type_desc FROM sys.objects WHERE type_desc NOT LIKE ‘%SYSTEM_TABLE%’ ORDER BY type_desc, name;
GO

— 检查数据行数
SELECT COUNT(*) FROM dbo.fgedu_users;
GO

— 检查索引状态
SELECT name, index_id, state_desc FROM sys.indexes WHERE object_id = OBJECT_ID(‘dbo.fgedu_users’);
GO

— 检查数据库对象
SELECT
schema_name(schema_id) AS schema_name,
name AS object_name,
type_desc AS object_type
FROM sys.objects
WHERE type_desc NOT LIKE ‘%SYSTEM_TABLE%’
ORDER BY schema_name, object_type, object_name;
GO

— 检查数据完整性
DBCC CHECKDB(‘fgedudb’) WITH NO_INFOMSGS;
GO

— 检查索引状态
SELECT
t.name AS table_name,
i.name AS index_name,
i.type_desc AS index_type,
i.state_desc AS index_state
FROM sys.tables t
JOIN sys.indexes i ON t.object_id = i.object_id
WHERE i.name IS NOT NULL
ORDER BY t.name, i.name;
GO

— 检查存储过程和函数
SELECT
name,
type_desc,
create_date,
modify_date
FROM sys.objects
WHERE type IN (‘P’, ‘FN’, ‘IF’, ‘TF’)
ORDER BY type_desc, name;
GO

# 验证应用程序连接
— 测试应用程序连接
— 确保应用程序能够正常连接到云数据库
— 执行应用程序的关键业务操作，验证功能正常

# 验证性能
— 执行性能测试
— 比较迁移前后的性能指标
— 优化云数据库性能

— 监控性能指标
SELECT
counter_name,
cntr_value
FROM sys.dm_os_performance_counters
WHERE counter_name IN (
‘Batch Requests/sec’,
‘Page Reads/sec’,
‘Page Writes/sec’,
‘Buffer cache hit ratio’,
‘CPU usage %’
);
GO

# 步骤1：评估数据库
# 使用Azure Database Migration Assistant评估数据库

# 步骤2：创建Azure SQL Managed Instance
# 在Azure门户中创建Managed Instance

# 步骤3：配置网络连接
# 设置虚拟网络和子网
# 配置网络安全组

# 步骤4：执行迁移
# 使用Azure Database Migration Service执行迁移

# 步骤5：验证迁移

— 检查数据库状态
SELECT name, state_desc FROM sys.databases;
GO

— 检查数据完整性
DBCC CHECKDB(‘fgedudb’) WITH NO_INFOMSGS;
GO

— 测试应用程序连接
— 更新应用程序连接字符串
— 测试关键业务功能

# 步骤6：优化性能

— 配置Azure SQL Managed Instance参数
ALTER DATABASE fgedudb SET COMPATIBILITY_LEVEL = 150;
GO

— 创建必要的索引
CREATE INDEX IX_fgedu_users_email ON dbo.fgedu_users(email);
GO

— 更新统计信息
UPDATE STATISTICS dbo.fgedu_users;
GO