Oracle Setup
  • Introduction
  • Oracle Installation Requirements
  • Download Oracle
  • Install Oracle
  • Connect to Oracle with SQLPlus
  • How to start and stop Oracle
  • What is SQL Developer
  • Download SQL Developer
  • Connect SQL Developer to Oracle
  • Download Sample Schema
  • Unlock sample schema account
  • Unlock sample schema tables
  • Connect sample Schema account to Oracle
  • What is TNS Names
  • Creating TNS Names
  • Connect to Oracle with TNS Names
SQL Server Setup
  • Download SQL Server
  • Install SQL Server
  • Install SQL Server Management Studio -SSMA
  • Connect SSMS to SQL Server
Migrating Oracle Database to SQL Server
  • Install SSMA for Oracle
  • Creating a new SSMA Project
  • Connect to the Oracle database server.
  • Connect to an instance of SQL Server.
  • Create pre-migration assessment reports
  • Map Oracle database schemas to SQL Server database schemas.
  • Convert Oracle database schemas into SQL Server schemas.
  • Load the converted database objects into SQL Server.
  • Migrate data to SQL Server.
  • Post Migration Test