Testing should cover the hardware, the SQL Server
installation, security, database objects, data, and performance.

Physical architecture of the database. Have the data files,
transaction log, tablespaces, and other items that comprise
the database been created correctly? Has the SQL Server
instance been properly configured?
•	

Security. Have the logins and users been correctly created?
Have the appropriate permissions been assigned? Is the
database physically secure?
•	

Logical architecture of the database. Have the tables,
views, stored procedures, triggers, and other database
objects been created successfully?
•	

Data. Have the contents of the tables been transferred
correctly? Do tables contain the correct numbers of rows? Is
the data valid?
•	

Functionality. Do the stored procedures, triggers, views,
and other items comprising Transact-SQL code operate in the
same manner as the original Oracle objects?
•	

Performance. Does response time and throughput meet
requirements and match user expectations?