Extract, Transfer, Load Instructions: MS SQL Server to Oracle SQL Server Environment (Testing)

Step 1: Access a MS SQL Server Using Pre- Existing Admin credentials. Step 2: Double-Click: MS SQL Server Icon

Step 3: Expand SQL Server Data-store

Step 4: Expand Database

Step 5: Locate Database Source

Step 6: Expand Dataset Table

Step 7: Right-click required Dataset (Select top 2000 rows)

Step 8: Analyze Selected Rows Values (Highlighting Value Types & Row Count)

Step 9: Select Tools, Options, Expand (+ Query Result) on Top Microsoft SQL Server Management Studio Ribbon. Set results as follows (Select OK)

Step 10: Prepare for Extraction (MS SQL Server to Oracle) -Right Click on Table and Issue following query on source (e.g., Album Table) SELECT * FROM Album; Step 11: Validate that results populated -Save as filenameOfChoice.rpt for extraction on to a medium that has access to an Oracle Server Platform. Step 12: Load Data on to Oracle Platform

Step 13: Login to Oracle Database XE 11.2 w/DB Admin Account

Step 14: Login to Oracle Database XE 11.2 w/DBA Admin Role

Step 15: Select - SQL Workshop

Step 16: Select - SQL Utilities

Step 17: Select: Data Workshop

Step 18: Select - Data Load – Text Data

Step 19: Change Input Data as Needed

Step 20: Load the Data

Step 21: Compare Data to Original Data Set Before (MS SQL Server)

After (Oracle Application Express)