— 目标数据库
SELECT
type_desc,
COUNT(*) AS count
FROM fgedudb.sys.objects
GROUP BY type_desc;
GO

— 步骤2：验证数据完整性
— 检查表行数
— 源数据库
SELECT COUNT(*) AS row_count FROM source_server.fgedudb.dbo.large_table;
GO

— 目标数据库
SELECT COUNT(*) AS row_count FROM fgedudb.dbo.large_table;
GO

— 检查数据一致性
SELECT
a.*
FROM source_server.fgedudb.dbo.large_table a
FULL JOIN fgedudb.dbo.large_table b ON a.id = b.id
WHERE a.id IS NULL OR b.id IS NULL OR a.col1 <> b.col1;
GO

— 步骤3：验证索引和约束
— 检查索引
SELECT
name,
index_id,
type_desc,
is_disabled
FROM fgedudb.sys.indexes
WHERE object_id = OBJECT_ID(‘fgedudb.dbo.large_table’);
GO

— 检查约束
SELECT
name,
type_desc,
is_disabled
FROM fgedudb.sys.check_constraints
WHERE parent_object_id = OBJECT_ID(‘fgedudb.dbo.large_table’);
GO

— 步骤4：验证存储过程和函数
— 检查存储过程
SELECT
name,
type_desc
FROM fgedudb.sys.objects
WHERE type_desc = ‘SQL_STORED_PROCEDURE’;
GO

— 测试存储过程
EXEC fgedudb.dbo.sp_test;
GO

— 步骤5：验证权限
— 检查用户和权限
SELECT
name,
type_desc
FROM fgedudb.sys.database_principals
WHERE type_desc IN (‘SQL_USER’, ‘SQL_ROLE’);
GO

— 步骤6：验证性能
— 运行性能测试
SELECT TOP 100 * FROM fgedudb.dbo.large_table WHERE col1 = ‘test’;
GO

— 检查执行计划
SET SHOWPLAN_XML ON;
GO

SELECT TOP 100 * FROM fgedudb.dbo.large_table WHERE col1 = ‘test’;
GO

SET SHOWPLAN_XML OFF;
GO

执行结果：